Data Engineer
Fresh Consulting4 months ago
Remote, MexicoMid Level / Senior
Responsibilities
- Design, build, and operate modern end-to-end cloud-native data warehouses.
- Develop and maintain ELT/ETL pipelines integrating servicing, origination, CRM, and third-party data feeds.
- Create scalable data models for reporting, BI semantic layers, and future AI/ML initiatives.
- Implement data quality, governance, and security practices aligned with U.S. financial regulations.
- Collaborate with U.S. C-suite stakeholders and directors to translate business requirements into technical data architecture.
- Optimize query, pipeline, and workflow performance for efficiency and cost control.
Requirements
- 4 to 7 years of verifiable experience building end-to-end cloud data warehouses from zero to production.
- Advanced SQL skills including dimensional modeling and performance optimization.
- Python experience for transformation, orchestration, and scripting.
- Experience with Microsoft Fabric or portable data warehouse stacks such as BigQuery, Snowflake, or Databricks.
- Experience with Azure Data Factory, Synapse, and Fabric, or equivalent AWS/GCP data infrastructure.
- Experience with Power BI or equivalent BI tools such as Looker, Tableau, or Mode.
- Experience with Azure Data Factory, Airflow, dbt, Dagster, or similar orchestration and transformation tools.
- Experience working directly with executives in the U.S.
- Fluent professional English at a minimum CEFR C1 level.
- Valid U.S. B1/B2 visa and confirmed availability to travel to the U.S. quarterly.
Benefits
- Remote position based in Mexico, with Monterrey, Mexico City, and Guadalajara preferred.
- Quarterly travel to the U.S., approximately one week per trip.
- Opportunity to build a modern data warehouse from the ground up and establish a foundation for future AI/LLM integrations and automated workflows.
Tech Stack
Categories
Data Engineering
About Fresh Consulting
Fresh Consulting is a strategy, design, software, and hardware engineering consultancy that builds digital products, robotics, and connected systems for businesses. It delivers end-to-end services—UX/UI, brand identity, web/mobile and embedded development, and systems engineering—via integrated project teams. The company is privately held and headquartered in Bellevue, Washington, supporting initiatives that link humans, software, and devices from early strategy through delivery.