The Role
Lead design and implementation of cloud-native end-to-end data warehouses and ELT/ETL pipelines. Build scalable data models, enforce governance/security for U.S. financial regulations, optimize performance, and collaborate with U.S. executives to translate business needs into technical architecture.
Summary Generated by Built In
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
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 and Construction: Design, build, and operate modern, end-to-end, cloud-native data warehouses.
- Pipeline Development: Develop and maintain robust ELT/ETL pipelines that integrate multiple internal systems (servicing, origination, CRM) and third-party data feeds.
- Data Modeling: Create scalable data models for reporting, BI (semantic layer), and future AI/ML initiatives.
- Governance and Security: Implement data quality, governance, and security practices aligned with stringent U.S. financial regulations.
- Executive Collaboration: Work closely with C-suite stakeholders and directors in the U.S. to translate business requirements into technical data architecture.
- Optimization: Optimize the performance of queries, pipelines, and workflows to ensure efficiency and cost control.
- 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.
Skills Required
- 4 to 7 years verifiable experience building end-to-end cloud data warehouses (from zero to production)
- Experience with Microsoft Fabric
- Experience with portable cloud data platforms (BigQuery, Snowflake, Databricks)
- Azure data stack experience (Data Factory, Synapse, Fabric) or equivalent AWS/GCP infrastructure
- Advanced SQL (dimensional modeling, performance optimization)
- Python for transformation, orchestration, and scripting
- BI tool experience: Power BI or equivalent (Looker, Tableau, Mode)
- Orchestration/transformation tools: Azure Data Factory, Airflow, dbt, Dagster or similar
- Implement data quality, governance, and security practices aligned with U.S. financial regulations
- Experience working directly with U.S. executives/C-suite to translate business requirements
- Fluent professional English (Minimum CEFR C1)
- Valid U.S. visa (minimum B1/B2) and availability to travel to the U.S. quarterly
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Fresh is an integrated consulting team of designers, developers, and engineers that build fresh experiences people love. Powered by our multi-talented teams, our winning combination of innovative thinking, creative design, sophisticated development, and advanced engineering ensure we’re delivering end-to-end experiences to help you grow. From creative brands and websites to intuitive apps and robots, we work with you from strategy to execution to create what's next.
