Data Analytics Engineer I

3 months ago

Responsibilities

Design and maintain modular, well-tested ELT pipelines using dbt, Azure Data Factory, or equivalent orchestration frameworks.
Build and maintain semantic and analytical data layers in Snowflake or Microsoft Fabric, including fact tables, dimension tables, conformed metrics, and reusable dbt models.
Develop production-grade Power BI reports and dashboards with structured data models, DAX measures, and row-level security.
Define and implement data quality rules, testing frameworks, and monitoring for analytics outputs.
Translate reporting requirements into robust, governed data assets with analysts, business stakeholders, and data engineers.
Apply dimensional modeling principles, including star schemas and slowly changing dimensions.
Manage datasets, optimize query performance, and control data access in Azure and Snowflake environments.
Document pipelines, semantic models, metric definitions, and report logic.
Participate in code reviews and improve team standards for analytics engineering.

Bachelor's degree in Computer Science, Information Technology, Business Analytics, Statistics, or a related field.
Two to four years of hands-on experience in analytics engineering, data engineering, or BI development.
Strong SQL skills and solid working knowledge of Python for data transformation tasks.
Working knowledge of dbt, including transformation development, tests, documentation, and lineage.
Hands-on professional experience delivering Power BI solutions, including data modeling, DAX, report design, and workspace governance.
Familiarity with Microsoft Fabric or Azure Data Factory for pipeline orchestration and data movement.
Solid understanding of dimensional modeling, including star schemas, snowflake schemas, and SCD types.
Understanding of BI governance principles, including semantic model management, certified datasets, and Power BI access control.
Experience with Snowflake or Azure Synapse Analytics for data warehousing and query optimization.
Experience with Git-based version control and collaborative development workflows.
Fluent in English; ITIL certification is advantageous but not mandatory.