Logo for Fresh Consulting

Data Engineer

Role overview

Qualifications

  • 4 to 7 years of verifiable experience building end-to-end cloud data warehouses
  • Advanced SQL and Python skills
  • Experience with Microsoft Fabric or equivalent cloud infrastructure
  • Direct experience working with executives in the U.S.

Responsibilities

  • Design, build, and operate modern, end-to-end, cloud-native data warehouses
  • Develop and maintain robust ELT/ETL pipelines
  • Create scalable data models for reporting and future AI/ML initiatives
  • Implement data quality, governance, and security practices aligned with U.S. regulations

Key facts

Hard skills

Other skills

  • Collaboration
  • Communication
  • Problem Solving

About the company

Fresh Consulting logo

Fresh Consulting

  • IT Services & Consulting
  • SME
  • 201–500
Fresh Consulting is a strategy, design, software, and hardware innovation company that offers end-to-end services with integrated teams. We design and build strategies, brands, products, robotics, systems, and apps to help you stay fresh. Whether your plan is to stay ahead or your need is to stay relevant, our multifaceted teams quickly integrate with yours to help you transform and create the future, together. From understanding where you are now, to guiding you where you want to be, we'll provide the engine to help you build, grow, and lead. We're hiring! https://www.freshconsulting.com/careers/

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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 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.
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.
     

Related jobs

See all Data Engineer jobs

Other jobs at Fresh Consulting