About

- Analytics Engineer – Data Engineering & Power BI We are looking for a hands-on Analytics Engineer who can work across both data engineering and analytics/reporting.

- This is not a Power BI-only role.

Key Responsibilities

- Build, maintain, and enhance data pipelines and transformation workflows using dbt and python DAG in Airflow.

- Develop clean, reliable, and reusable data models for analytics and reporting. Work with SQL and data warehouse platforms to investigate data, troubleshoot issues, 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.

- AI Forward - Understand how to marry AI tools to enhance productivity on tasks Required Skills Strong SQL and data analysis skills.

- Strong Python for data pipelines for complex transformations and integrations.





- Hands-on experience with dbt and/or modern ELT/data transformation practices.

- Solid understanding of data modeling, including dimensional modeling, fact/dimension structures, and analytics datasets.

- Experience working with a modern cloud data warehouse, preferably Snowflake.

- Strong working experience with Power BI, including data modeling, DAX, dashboard development, and performance considerations.

- Ability to understand unfamiliar datasets and identify relationships, data quality issues, and transformation requirements.

- Experience debugging and supporting existing data pipelines and analytics solutions.

- Comfortable working independently in a fast-paced environment and delivering tasks with limited supervision.

Must have below:·

10+ Years Experience · Great Communicator/Client Facing/ Attention to detail · Individual Contributor and ability to work as a team.

📌 Analytics Engineer – Data Engineering & Power BI (México)
🏢 Pyramid Consulting
📍 México