Sr. Specialist, Yield Management - GTM Data Engineer

Ford Motor Company • Dearborn, MI

13d • $115,000 - $192,900 • Hybrid

About The Position

This role sits at the intersection of data engineering, business intelligence, data science, and data governance, and is ideal for someone who enjoys solving a business problem from raw datasets to endpoint to business-ready metric. You'll work closely with data analysts, data scientists, and business stakeholders to ensure data and metrics are well-defined, accessible, reliable, well-documented, and easy to consume across the organization. We are looking for a Data Engineer to design, build, and maintain end-to-end data solutions — from raw data ingestion through to curated metrics that power advanced analytics, business intelligence dashboards and business decision-making.

Requirements

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

Nice To Haves

• Master's degree in Computer Science, Engineering, Information Systems, or a related field
• Experience using AI to build/maintain code/pipelines
• Document data flows, API specifications, metric definitions, and system architecture for internal and cross-team use.
• Experience working with a data catalog / metadata management tool (e.g., 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 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 / Cloud Composer.
• Experience in the automotive, manufacturing, or connected vehicle data domain (a plus, given Ford's business context).
• Knowledge of BI/visualization tools (Looker, Tableau, Power BI).

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 to expose data and metrics to internal advanced analytics AI/ML models, dashboards, and variety of consumers.
• Design and manage a curated data layer that translates raw data into consistent, business-friendly metrics and definitions.
• Design, build and manage business friendly dashboards that provide valuable business insights to the executive leadership
• Implement and maintain a data catalog / knowledge catalog (e.g., Google Data Catalog) to improve data 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 ensure pipeline reliability and data trustworthiness.
• Collaborate with cross-functional teams (analytics, product, business) to gather requirements and translate them into scalable data models, metrics
• Enforce data governance, security, and access control standards (PII handling, role-based access, encryption).
• Write clean, well-tested, and maintainable code (Python/SQL, and backend frameworks for API based ingestion routines).
• Create and maintain CI/CD pipelines for seamless deployments and change reviews across the code base.
• Participate in code reviews, architecture discussions, and CI/CD pipeline development for data and application deployments.

Benefits

• Immediate medical, dental, vision and prescription drug coverage
• Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care and more
• 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
• A generous schedule of paid holidays, including the week between Christmas and New Year’s Day
• Paid time off and the option to purchase additional vacation time.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior