Supply Chain Business Intelligence Engineer

Ford México; Naucalpan de Juárez; Presencial; MXN 420.000 - 720.000; Jornada completa

Descripción de la vacante

Ford of Mexico is seeking an Analytics Engineer to bridge manufacturing operations and data ecosystems. You will design, optimize, and govern data pipelines and semantic models to deliver real-time insights for supply chain and quality teams.

You will implement ETL/ELT processes using SQL and Python, collaborate across functions, and explore AI and automation to streamline reporting and governance while maintaining a scalable data architecture.

Formación

• Bachelor’s degree in a data-focused technical field or equivalent experience.
• 2–3 years in Analytics Engineering, Data Engineering, or BI in industrial settings.
• Proficient English communication of complex data insights.

Responsabilidades

• Design and optimize centralized semantic data models for a unified single source of truth.
• Develop and automate ETL/ELT pipelines using SQL and Python to BI platforms.
• Collaborate with supplier quality and technical support on data-driven root-cause analyses.
• Translate engineering data into clear, high-level reporting for planning and budget tracking.
• Identify and implement automation and AI solutions to improve workflows and documentation.
• Establish and maintain data governance and scalable star/snowflake schemas.

Conocimientos

Data modeling

DAX

Power Query

SQL

Python

Star/Snowflake schemas

Data governance

Educación

Bachelor’s degree in Mechatronics, Robotics, Computer Science, Industrial Engineering (with a data focus)

Herramientas

Power BI

Tableau

dbt

Snowflake

Azure Databricks

Python

SQL

Descripción del empleo

Job Description

At Ford, we made history, and now we work to transform the future of mobility for our customers, our communities, and our families. By joining us, you will build what matters and drive progress with heart, developing tangible innovations you will see on the road every day that help people move freely and pursue their dreams. Here, you can build more than vehicles; you will grow in ways that count, supported by a global family and a culture built on passion, capability, community, and trust.

Why Join Ford of Mexico

Celebrating over 100 years of legacy in Mexico, we are more than just a business we are a vibrant, collaborative community of over 14,000 innovators shaping the global future of transportation. At Ford, we build what matters, grow where it counts, and drive progress with heart. Whether you are collaborating at our state‑of‑the‑art Global Technology and Business Center (GTBC) or manufacturing iconic, award‑winning vehicles in our world‑class plants, you will find a culture evolving together, built on trust, passion, and shared purpose. Here, your work moves people forward, and your growth is personal. Join us, and let’s build what’s next together.

In this position

In this role, you will serve as the vital link between our physical manufacturing operations and our advanced data ecosystems. By designing, optimizing, and governing robust data pipelines and semantic models, you will empower our supply chain and supplier quality teams with actionable, real‑time insights. Your work will directly prevent operational bottlenecks, drive digital transformation through automation and AI, and build a unified "Single Source of Truth" that shapes the future of our global manufacturing efficiency.

Responsibilities

What you'll do

• Design and optimize centralized semantic data models (using tools like Power BI or Tableau) to establish a unified "Single Source of Truth" for critical supply chain and manufacturing metrics.
• Develop and automate robust ETL/ELT data pipelines using SQL and Python to streamline data integration from plant systems (such as manufacturing and enterprise resource planning systems) into business intelligence platforms.
• Collaborate with supplier quality and technical support teams to analyze manufacturing constraints, perform data‑driven root‑cause analyses, and track capacity planning and product launch milestones.
• Partner with business operations and strategy teams to translate complex technical engineering data into clear, high‑level reporting that supports resource allocation, budget tracking, and strategic planning.
• Identify and implement automation and artificial intelligence (AI) solutions (such as Generative AI, Microsoft Copilot, or custom Python scripts) to optimize daily workflows, reporting efficiency, and technical documentation.
• Establish and maintain data governance frameworks, designing scalable star/snowflake schemas to ensure data integrity, security, and long‑term operational continuity.

Qualifications

You’ll have

Education

Education: Bachelor’s degree in Mechatronics, Robotics, Computer Science, Industrial Engineering (with a data focus), or a related field—or equivalent practical experience. An advanced degree in a technology‑related field is highly valued.

Experience

Experience: 2 to 3 years of experience in Analytics Engineering, Data Engineering, or Business Intelligence roles within industrial, manufacturing, or supply chain environments. Demonstrated experience implementing or supporting AI/automation projects is preferred.

Languages

Languages: Professional working proficiency in English, with the ability to communicate technical insights clearly to both technical and non‑technical stakeholders.

Required Technical Stack

• Data Analysis & BI: Advanced proficiency in data modeling, DAX, and Power Query (Power BI and/or Tableau).
• Data Engineering: Advanced SQL (query optimization, complex JOINs, UPSERTs) and Python (Pandas, ETL automation scripting).
• Modeling & Governance: Strong experience designing Star/Snowflake schemas and applying data governance principles.

Even better, you may have

• Modern Data Stack: Experience with tools like dbt, Snowflake, or Azure Databricks.
• Industrial/Operational Systems: Familiarity with SCADA, MES, IoT protocols (e.g., MQTT, Modbus), or systems like Ignition.
• Software Development: Basic knowledge of C#, ASP.NET, or API development.

Ford of Mexico is committed to being an equal opportunity employer. We believe that a diverse and inclusive workplace is essential to our success. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, pregnancy, veteran status, or disability status.

We thank all candidates for their interest, but only those selected for an interview will be contacted.

#FordMexico