Analytics Engineer
Summary
The Analytics Engineer will build and maintain data pipelines using dbt, Python, and Airflow while developing Power BI dashboards and data models. The role requires extensive experience in SQL, cloud data warehousing, and dimensional modeling to support business reporting and data quality.
Responsibilities
- Build, maintain, and enhance data pipelines and transformation workflows using dbt and Python DAGs in Airflow
- Develop clean, reliable, and reusable data models for analytics and reporting
- Work with SQL and data warehouse platforms to investigate data and implement transformations
- Develop and maintain Power BI dashboards, reports, semantic models, and DAX measures
- Translate business requirements into appropriate data models and reporting solutions
- Perform data analysis, validation, reconciliation, and data quality checks
- Troubleshoot data issues across the pipeline from source to reporting
- Use AI tools to enhance productivity on tasks
Requirements
- 10+ years of experience
- Strong SQL and data analysis skills
- Proficiency in Python for complex transformations and integrations
- Hands-on experience with dbt and modern ELT practices
- Solid understanding of dimensional modeling (fact/dimension structures)
- Experience with cloud data warehouses, preferably Snowflake
- Strong experience with Power BI, including DAX and performance optimization
- Ability to work independently in a fast-paced environment
- Advanced English fluency