Data Engineer

Fresh Consulting; Ciudad de México; Presencial; MXN 700.000 - 1.000.000; Jornada completa

Descripción de la vacante

Fresh Consulting is seeking a Senior Data Engineer to lead the design and implementation of cloud-native data platforms for international clients in the US. Remote in Mexico with preferred travel to Monterrey, Mexico City, or Guadalajara.

The role emphasizes building a modern data warehouse, maintaining data flows, and enabling AI/LLM integrations while ensuring governance and security per U.S. regulations. Fluent English is required.

Formación

• 4–7 years of verifiable experience building end-to-end cloud data warehouses.
• Fluent professional English (CEFR C1).
• Experience designing, building, and operating data pipelines and data models.
• Willingness to travel to the U.S. quarterly.

Responsabilidades

• Design, build, and operate modern, cloud-native data warehouses for clients.
• Develop and maintain ELT/ETL pipelines integrating multiple data sources.
• Create scalable data models for reporting, BI, and AI/ML initiatives.
• Implement data quality, governance, and security aligned with U.S. regulations.
• Collaborate with U.S. executives to translate requirements into data architecture.
• Optimize query and workflow performance for cost efficiency.

Conocimientos

Microsoft Fabric

BigQuery

Snowflake

Databricks

Herramientas

Azure Data Factory

Airflow

dbt

Dagster

Descripción del empleo

Fresh Consulting is seeking a Senior Data Engineer (Individual Contributor) to technically lead the design and implementation of cloud-native data platforms for international clients in the US.

The successful candidate will not only maintain existing data flows but also design, build, and implement a modern data warehouse from the ground up, laying the foundation for future AI/LLM integrations and automated workflows.

Location: Remote (Mexico — Preferred: Monterrey, Mexico City, Guadalajara)

Language Requirement: Fluent professional English (Minimum CEFR C1)
Travel: Availability to travel to the U.S. quarterly (approximately 1 week per trip)

Key Responsibilities

• Design, build, and operate modern, end-to-end, cloud-native data warehouses.
• Develop and maintain robust ELT/ETL pipelines that integrate multiple internal systems (servicing, origination, CRM) and third‑party data feeds.
• Create scalable data models for reporting, BI (semantic layer), and future AI/ML initiatives.
• Implement data quality, governance, and security practices aligned with stringent U.S. financial regulations.
• Work closely with C‑suite stakeholders and directors in the U.S. to translate business requirements into technical data architecture.
• Optimize the performance of queries, pipelines, and workflows to ensure efficiency and cost control.

Required Skills

• Microsoft Fabric (highly preferred) OR portable stacks (BigQuery, Snowflake, Databricks).
• 4 to 7 years of verifiable experience building end‑to‑end cloud data warehouses (real projects taken from zero to production), not just maintaining existing systems.
• Cloud Infrastructure: Azure data stack (Data Factory, Synapse, Fabric) or equivalent on AWS/GCP.
• Core Languages: Advanced SQL (dimensional modeling, performance optimization) and Python (transformation, orchestration, scripting).
• BI Tools: Power BI or equivalent (Looker, Tableau, Mode).
• Orchestration and Transformation: Azure Data Factory, Airflow, dbt, Dagster, or similar tools.
• Direct Exposure to Stakeholders: Experience working directly with executives in the U.S.
• Valid US Visa (Minimum B1/B2): Confirmed availability to travel to the US quarterly.