Analytics Engineer

**About the company:** Zeals Meguro-ku, Tokyo We are a group of scrappy and hungry bunch from different walks of life, looking to make an actual impact on the way people and businesses communicate through our AI Chatbot technology. **Responsibilities:** Designing and implementing robust dimensional data models that enable self-service analytics and reporting Building and maintaining transformation layers using dbt to deliver trusted, well-documented datasets Defining and managing business logic, metrics, and KPIs through a semantic layer Partnering with stakeholders to translate business requirements into scalable data models Establishing and enforcing data quality standards through testing, documentation, and monitoring Optimizing query performance and warehouse costs through effective modeling strategies Requirements 3+ years of experience in analytics, data engineering, or related fields with strong SQL proficiency 1+ years of hands-on experience with dbt (dbt Core or dbt Cloud) Solid understanding of dimensional modeling techniques (Kimball, Data Vault, or similar) Experience working with cloud data warehouses, preferably BigQuery Proven ability to translate complex business requirements into clear, maintainable data models Strong documentation habits and commitment to data governance Experience collaborating with both technical teams and non-technical stakeholders Fluent Japanese language skills with ability to have daily conversations in English Nice to haves While not specifically required, tell us if you have any of the following. Experience with dbt Semantic Layer or metrics layer implementations Familiarity with BI tools such as Tableau, Looker, or Omni Understanding of incremental materialization strategies and cost optimization Experience working in bilingual (Japanese/English) environments Fluent English language skills APPLY FOR THIS POSITION DO YOU NEED MORE INFO? ASK A QUESTION Meet Zeals's Developers Zeals Pushed Him Out of His Comfort Zone—and He’s Glad with Or Perlman Or Perlman shares how Zeals’s focus on end users transformed his career and led to business success. Read their story... **Requirements:** 3+ years of experience in analytics, data engineering, or related fields with strong SQL proficiency 1+ years of hands-on experience with dbt (dbt Core or dbt Cloud) Solid understanding of dimensional modeling techniques (Kimball, Data Vault, or similar) Experience working with cloud data warehouses, preferably BigQuery Proven ability to translate complex business requirements into clear, maintainable data models Strong documentation habits and commitment to data governance Experience collaborating with both technical teams and non-technical stakeholders Fluent Japanese language skills with ability to have daily conversations in English **Nice to have:** While not specifically required, tell us if you have any of the following. Experience with dbt Semantic Layer or metrics layer implementations Familiarity with BI tools such as Tableau, Looker, or Omni Understanding of incremental materialization strategies and cost optimization Experience working in bilingual (Japanese/English) environments Fluent English language skills APPLY FOR THIS POSITION DO YOU NEED MORE INFO? ASK A QUESTION Meet Zeals's Developers Zeals Pushed Him Out of His Comfort Zone—and He’s Glad with Or Perlman Or Perlman shares how Zeals’s focus on end users transformed his career and led to business success. Read their story...