Sr. Specialist, Yield Management - GTM Data Engineer

Ford Motor Company offers a hybrid role based in Dearborn, MI for a data engineer focused on yield management GTM analytics. You’ll build reliable end-to-end data solutions and decision-ready metrics that support analytics, BI dashboards, and business outcomes across teams, while working with modern cloud tooling on Google BigQuery and related platforms.

What you’ll do

• Design, build, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver data from diverse sources into Google BigQuery and other cloud data platforms.
• Develop, document, and maintain curated business-ready metrics used by internal advanced analytics, AI/ML models, dashboards, and other consumers.
• Create and manage a curated data layer that turns raw data into consistent, business-friendly definitions.
• Design, build, and manage business-friendly dashboards that deliver insights for executive leadership.
• Implement and maintain a data catalog / knowledge catalog (for example, Google Data Catalog) to improve discoverability, lineage tracking, and metadata management.
• Optimize BigQuery performance using partitioning, clustering, query tuning, and cost-management best practices.
• Build data quality checks, monitoring, and alerting to support pipeline reliability and data trust.
• Partner with cross-functional teams (analytics, product, business) to translate requirements into scalable data models and metrics.
• Enforce data governance, security, and access control, including PII handling, role-based access, and encryption.
• Write clean, well-tested, maintainable code using Python/SQL, including backend frameworks for API-based ingestion routines.
• Create and maintain CI/CD pipelines to support deployments and change reviews across the code base.
• Participate in code reviews, architecture discussions, and CI/CD pipeline development for data and application deployments.

What you bring

• Bachelor’s degree in computer science, Engineering, Information Systems, or a related field (or foreign equivalency), or an equivalent combination of relevant education and experience.
• 5+ years of experience in data engineering, software engineering, or a full-stack data role.
• 3+ years demonstrating strong programming skills in Python, SQL, BigQuery, and Dataflow.
• 3 years of hands-on experience with Google BigQuery and Dataform, including data modeling, query optimization, cost management, and scheduled queries.
• 3 years building and maintaining a data mart to standardize business metrics.
• 2+ years using BI tools such as Looker, Power BI, Tableau, or custom apps built using Dash.
• 2+ years designing and building ingestion routines based on REST APIs.
• 2+ years working with testing, monitoring, reliability, and maintainable software design.

Tools you’ll likely use

Python, SQL, Google BigQuery, ETL/ELT, Google Data Catalog, BigQuery partitioning, BigQuery clustering, Dataform, Google Dataflow, Looker, Power BI, Tableau, Dash, REST APIs, CI/CD pipelines

Benefits

• Immediate medical, dental, vision, and prescription drug coverage
• Flexible family care days, paid parental leave, new parent ramp-up programs, and subsidized back-up child care
• Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more
• Vehicle discount program for employees and family members and management leases
• Tuition assistance
• Established and active employee resource groups
• Paid time off for individual and team community service
• Paid time off for paid holidays, including the week between Christmas and New Year’s Day
• Paid time off and the option to purchase additional vacation time

Salary information

This position is a salary grade 8 role with a range of $115,000-$192,900 per year. Final determination of salary grade and base salary will be based on candidate skills and experience, set within the applicable range according to job scope, responsibility, and competitive market value.

Even better if you also have

• Master’s degree in Computer Science, Engineering, Information Systems, or a related field
• Experience using AI to build or maintain code and pipelines
• Experience documenting data flows, API specifications, metric definitions, and system architecture for internal and cross-team use
• Experience working with a data catalog / metadata management tool (for example, Google Data Catalog), including lineage, tagging, and governance workflows
• Strong SQL skills and experience with Python for data pipeline development and automation
• Experience with cloud platforms, preferably Google Cloud Platform (GCP) (Cloud Storage, Cloud Functions, Dataflow, Pub/Sub, Composer/Airflow)
• Solid understanding of data modeling concepts (dimensional modeling, star/snowflake schemas, normalization)
• Familiarity with Git and CI/CD practices for data and application deployments
• Strong understanding of data governance, security, and privacy best practices
• Experience with orchestration tools such as Apache Airflow / Cloud Composer
• Experience in the automotive, manufacturing, or connected vehicle data domain (a plus)
• Knowledge of BI/visualization tools (Looker, Tableau, Power BI)