DBT Data Analytics Engineer

Title: DBT Data Analytics Engineer

Duration: 6+ months contract (Possible Extension-Long Term Project)

Work location: Mountain View, CA

Analytics Engineer

• You will help us model data into our Semantic Layer, redistribute the data via reverse ETL processes, maintain our data at a high quality, and provide technical guidance to analysts and business users.
• As an Analytics Engineer, you will work closely with Data Analysts, playing a pivotal role in providing reliable, high-quality, and valuable data resources.
• You will also ensure these assets are updated and adapted as business requirements evolve.
• We seek someone passionate about structuring data into reusable, maintainable solutions and who can bring enthusiasm to help us expand this function.

What You ll do:

• Design, build, and validate data transformation pipelines to create data models
• Develop, maintain, and optimize the semantic layer architecture in dbt, ensuring accurate and efficient data modeling that supports business intelligence, insights, and analytical needs
• Collaborate across departments to apply our data strategy and corporate-wide data definitions that meet the demands of our fast[1]growing business
• Take responsibility for delivering new data assets and enhancing the quality and functionality of existing ones
• Promote the importance of upholding high-quality, easily maintainable data assets by following best practices and standards via internal code & data reviews
• Oversee and refine our CI/CD process to streamline the automated deployment of high-quality code
• Develop test cases to guarantee the continuous delivery of accurate and reliable data and safeguard it from future changes.
• Document our data models, logic, and the raw data itself
• Monitor our data and solve data quality issues

Your qualifications:

• You have a deep understanding of dbt (cloud or core) and can develop data models and create and maintain dbt architecture
• You possess extensive experience in SQL, both data definition and data manipulation
• You are experienced with data tools and platforms, including BigQuery.
• You have experience with Python tools used in data engineering
• You have expertise in understanding business strategy and metrics
• You have more than 3 years of experience in data-related roles such as data engineering or data analytics
• You have experience with test automation tools to ensure confident, reliable delivery
• You are proficient with Git
• You have experience collaborating in an agile team environment, consistently delivering incremental value each sprint
• You have been exposed to data visualization tools like Tableau or Power BI for transforming data into insight