Analytics Engineer – Data Engineering & Power BI

Pyramid Consulting, Inc; México; Presencial; MXN 600.000 - 900.000; Jornada completa

Descripción de la vacante

Pyramid Consulting, Inc. is seeking a hands-on Analytics Engineer who can bridge data engineering and analytics/reporting. You will own data tasks end-to-end—from understanding source data and building transformation pipelines to creating well-designed datasets and Power BI dashboards.

Ideal candidates will have strong SQL, Python, dbt, Snowflake, and Power BI proficiency, with the ability to translate business requirements into scalable analytics solutions and dashboards.

Formación

• 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.

Responsabilidades

• 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.
• Troubleshoot data issues across the pipeline, from source through transformation to reporting.
• Take ownership of assigned tasks and independently drive them through development, testing, and completion.
• Work closely with business, analytics, and engineering teams to deliver production-ready solutions.
• AI Forward - Understand how to marry AI tools to enhance productivity on tasks

Conocimientos

SQL

Python

dbt

data modeling

data warehouse

Power BI

DAX

data analysis

ELT

Herramientas

dbt

Airflow

Power BI

Descripción del empleo

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. The ideal candidate should be comfortable owning data tasks end-to-end — from understanding source data and building transformation pipelines to creating well-designed datasets and Power BI dashboards.

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.
• Troubleshoot data issues across the pipeline, from source through transformation to reporting.
• Take ownership of assigned tasks and independently drive them through development, testing, and completion.
• Work closely with business, analytics, and engineering teams to deliver production-ready solutions.
• 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
• Individual Contributor and ability to work as a team.
• 100% Hands on in the mentioned skills

Ideal Candidate

• We are looking for someone who is data-first and hands-on.
• The candidate should be equally comfortable writing SQL/dbt/Python transformations, investigating a data issue, designing an analytics model, and building or modifying a Power BI report.
• We are particularly looking for someone who can ramp up quickly, understand an existing data environment, take ownership of assigned work, and consistently deliver completed solutions.