Full Time 1 Attachments
This position is based remotely in Mexico.
Our Business Intelligence team supports data-driven decision-making across all departments, from production and operations to sales and distribution.
We're looking for a Senior Data Engineering Consultant who can own the data infrastructure that powers our analytics environment. You'll build and maintain ETL pipelines, develop and optimize our SQL Server data warehouse, design Fabric lakehouse ingestion workflows, and establish CI/CD practices for our data assets, all while working remotely with our USA-based team. The adecuado candidate is self-sufficient, understands how data flows from source to consumption, and can navigate a complex data environment with minimal guidance.
Develop, maintain, and optimize ETL/ELT pipelines using SSIS and Microsoft Fabric
~ Build and maintain data warehouse staging, transformation, and loading processes in SQL Server
~ Design and implement data ingestion workflows from multiple source systems into SQL Server and Fabric lakehouses
~ Write and optimize complex SQL queries,



stored procedures, and indexing strategies
~ Design and maintain star schemas, dimensional models, and data warehouse architecture
~ Monitor pipeline health, troubleshoot data issues, and implement error handling and logging
~ Implement and maintain CI/CD pipelines for automated testing and deployment of data assets
~ Manage version control for data pipelines, SQL objects, and BI assets using GitHub
~ Document data flows, transformation logic, pipeline architecture, and business rules thoroughly
~ Gather requirements from stakeholders and translate them into data engineering solutions
~ Collaborate with the BI team to ensure data models support downstream reporting needs
~ Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field
~3+ years of experience in data engineering or data warehouse development
~ Strong SQL Server skills (complex queries, stored

📌 Senior Data Engineer Consultant (Ciudad de México)
🏢 Ole' Mexican Foods
📍 Ciudad de México