about

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
- great communicator/client facing/ attention to detail
- individual contributor and ability to work as a team.
- 100% hands on in the mentioned skills

idóneo 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.

📌 Analytics engineer – data engineering & power bi (México)
🏢 Pyramid Consulting
📍 México