Analytics Engineer IT

Dana Canada Corp.; Santiago de Querétaro; Híbrido; MXN 350.000 - 550.000; Jornada completa

Descripción de la vacante

Dana Canada Corp. in Querétaro, Mexico, is seeking a senior data engineer to design and implement scalable data models and transformations using dbt within the Microsoft Fabric ecosystem.

You will collaborate with business stakeholders to understand data needs, ensure data quality and governance, optimize performance across large datasets, and contribute to best practices for data modeling, transformation, and source control.

Formación

• +5 years of experience in data engineering, analytics engineering, or a related field.
• Proficiency with SQL, ideally in dbt (Core or Cloud) for data transformation and modeling.
• Hands-on experience with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, and Power BI artifacts.
• Strong SQL skills and experience working with large-scale data warehouses or lakehouses.
• Familiarity with Git-based version control and CI/CD practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Experience with Power BI semantic models and DAX.

Responsabilidades

• Design and implement scalable data models and transformations using dbt within the Microsoft Fabric ecosystem.
• Collaborate with business stakeholders to understand data needs and deliver high-quality datasets.
• Ensure data quality, consistency, and governance through testing, documentation, and version control.
• Optimize performance of data transformations and queries across large datasets.
• Monitor and troubleshoot data workflows and proactively resolve issues.
• Contribute to the development of best practices and standards for data modeling, transformation, and source control.

Conocimientos

SQL

dbt

Power BI

Python

Git

CI/CD

Data Modeling

Big data

Agile/DevOps

Data governance

Herramientas

dbt

Microsoft Fabric

OneLake

Lakehouse

Power BI artifacts

Git-based version control

CI/CD

Descripción del empleo

Select how often (in days) to receive an alert:

Requisition: 64617

Job Purpose

Job Duties and Responsibilities

• Design and implement scalable data models and transformations usingdbtwithin theMicrosoft Fabricecosystem.
• Collaborate with business stakeholders to understand data needs and deliver high-quality datasets.
• Ensure data quality, consistency, and governance through testing, documentation, and version control.
• Optimize performance of data transformations and queries across large datasets.
• Monitor and troubleshoot data workflows and proactively resolve issues.
• Contribute to the development of best practices and standards for data modeling, transformation, and source control.

Education and Qualifications

• +5 years of experience in data engineering, analytics engineering, or a related field.
• Proficiency with SQL, ideally indbt (Core or Cloud)for data transformation and modeling.
• Hands-on experience withMicrosoft Fabric, includingOneLake,Lakehouse, Warehouse, and Power BI artifacts.
• Strong SQL skills and experience working with large-scale data warehouses or lakehouses.
• Familiarity with Git-based version control and CI/CD practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Experience withPower BI semantic modelsand DAX.

Skills and Competencies

• Experience with data models for SAP ECC, Oracle EBS, and/or QAD strongly preferred.
• Experience with data models for Salesforce, GetPaid, iNexus, Concur, SAP S4/HANA, SAP SuccessFactors, Hyperion Financial Management, Hyperion Planning (PBCS), Siemens Teamcenter.
• Knowledge of data governance, lineage, and observability tools.
• Familiarity with Python or other scripting languages.
• Experience working in Agile or DevOps environments.

Join our team of 28,000 problem solvers who are fostering a culture of innovation by leveraging the diverse perspectives of our global team. We believe in facing challenges head-on by finding opportunity and uncovering possibility, where roadblocks and barriers become targets instead of obstacles. We are One Dana with limitless opportunity.