Sr. Specialist, Yield Management - GTM Data Engineer

Ford Motor Company seeks a Sr. Specialist, Yield Management GTM Data Engineer to build end-to-end data solutions and business-ready metrics that support analytics, BI dashboards, and decision-making. This hybrid role in Dearborn, MI emphasizes reliable data pipelines, clear metric definitions, and governance-aligned delivery for internal AI and analytics consumers.

Key Responsibilities

• 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 for use by advanced analytics AI/ML models, dashboards, and multiple internal consumers.
• Design and manage a curated data layer that converts raw datasets into consistent, business-friendly metrics and definitions.
• Design, build, and manage business-friendly dashboards that communicate business insights to executive leadership.
• Implement and maintain a data catalog or knowledge catalog (for example, Google Data Catalog) to improve discoverability, lineage tracking, and metadata management.
• Optimize BigQuery performance through partitioning, clustering, query tuning, and cost-management best practices.
• Build data quality checks, monitoring, and alerting to support pipeline reliability and data trustworthiness.
• Collaborate with cross-functional teams (analytics, product, and business) to gather requirements and translate them into scalable data models and metrics.
• Enforce data governance, security, and access control standards including PII handling, role-based access, and encryption.
• Write clean, well-tested, and maintainable code using Python/SQL and 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.

Required Qualifications

• 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 of practical experience building and maintaining a data mart to standardize business metrics.
• 2+ years using business intelligence tools such as Looker, Power BI, Tableau, or custom apps built using Dash.
• 2+ years building ingestion routines based on API (REST).
• 2+ years experience in roles requiring strong understanding of testing, monitoring, reliability, and maintainable software design.

Technologies

• 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 (including CI/CD)

Compensation and Work Location

This position is based in Dearborn, MI (hybrid). The salary grade is 8 and ranges from USD 115,000 to 192,900 per year. Final compensation within the applicable range will be determined based on the candidate’s skills and experience, job scope, responsibility, and competitive market value.

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

Additional “Even Better” Experience

• Master’s degree in Computer Science, Engineering, Information Systems, or a related field
• Experience using AI to build or maintain code and pipelines
• Document data flows, API specifications, metric definitions, and system architecture for internal and cross-team use
• Experience with a data catalog or 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) (including Cloud Storage, Cloud Functions, Dataflow, Pub/Sub, and Composer/Airflow)
• Solid understanding of data modeling concepts including dimensional modeling, star or snowflake schemas, and normalization
• Familiarity with version control (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 or Cloud Composer
• Experience in the automotive, manufacturing, or connected vehicle data domain (a plus)
• Knowledge of BI and visualization tools including Looker, Tableau, and Power BI