Sr. Specialist, Yield Management - GTM Data Engineer

Ford; Dearborn (MI); Hybrid; USD 115,000 - 193,000; Full time

Benefits offered by this job

Vehicle discount program for employees

Tuition assistance

Paid time off

Flexible family care days

Job summary

Ford Motor Company is seeking a Sr. Specialist, Yield Management - GTM Data Engineer to design, build, and maintain end-to-end data solutions powering analytics and dashboards.

You will work with data analysts, scientists, and stakeholders to ensure data are defined, accessible, reliable, and well-documented across the org. The role emphasizes governance, scalable pipelines, and BI/analytics delivery.

Qualifications

• 5+ years in data engineering or similar roles.
• 3+ years with Python, SQL, BigQuery, Dataflow.
• 3 years with Google BigQuery, Dataform; modeling & cost management.
• 3 years building a data mart to standardize business metrics.
• 2+ years in BI tools (Looker/Power BI/Tableau) or Dash apps.
• 2+ years designing ingestion routines via APIs (REST).
• 2+ years in testing, monitoring, reliability, and maintainable software design.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver data to BigQuery and cloud platforms.
• Develop curated metrics and expose data to analytics models, dashboards, and consumers.
• Create a curated data layer with consistent, business-friendly metrics and definitions.
• Build and manage dashboards for executive insights; maintain a data catalog for lineage and metadata.
• Optimize BigQuery via partitioning, clustering, and cost-management best practices.
• Implement data quality checks, monitoring, and alerts for pipeline reliability.
• Collaborate with analytics, product, and business teams to translate requirements into scalable data models.
• Enforce data governance, security, and access control (PII handling).
• Write clean, well-tested Python/SQL code and develop CI/CD pipelines for deployments.
• Participate in code reviews, architecture discussions, and CI/CD pipeline development.

Skills

Python

SQL

BigQuery

Dataflow

CI/CD

Data governance

Testing/Monitoring

Education

Bachelor's degree in CS/Engineering/IS

Master's degree (nice to have)

Tools

Google BigQuery

Dataflow

Dataform

Looker

Power BI

Tableau

Dash

Google Data Catalog

Git

Airflow / Cloud Composer

Job description

Sr. Specialist, Yield Management - GTM Data Engineer

We made history and now we work to transform the future – for our customers, our communities and our families. You'll see your work on the road every day, helping people move freely and pursue their dreams. At Ford, you can build more than vehicles. Come build what matters.

Our Marketing, Sales & Service organization advances the Ford reputation as a visionary vehicle and mobility services company and helps deliver a trusted customer experience. Use your marketing, sales and service expertise to turn data-driven insights into innovative solutions that enhance sales and customer loyalty. Join us and be the eyes, ears and voice of Ford.

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

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

You'll have...

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

Even better, you may have...

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

You may not check every box, or your experience may look a little different from what we've outlined, but if you think you can bring value to Ford Motor Company, we encourage you to apply!

As an established global company, we offer the benefit of choice. You can choose what your Ford future will look like: will your story span the globe, or keep you close to home? Will your career be a deep dive into what you love, or a series of new teams and new skills? Will you be a leader, a changemaker, a technical expert, a culture builder…or all of the above? No matter what you choose, we offer a work life that works for you, including:

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

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

Visa sponsorship is available for this position.

Candidates for positions with Ford Motor Company must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status. In the United States, if you need a reasonable accommodation for the online application process due to a disability, please call 1-888-336-0660.

This position is hybrid with a requirement to be onsite four or more days per week.