Sr. Specialist, Yield Management - GTM Data Engineer

Ford Motor Company is hiring a Sr. Specialist focused on Yield Management GTM Data Engineering, responsible for end-to-end data solutions and business-ready metrics that support analytics, BI dashboards, and decision-making. The role spans data engineering, business intelligence, data science, and data governance, with close collaboration across cross-functional stakeholders.

• Design, build, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver data from diverse sources into Google Big Query and other cloud data platforms.
• Develop, document, and maintain curated business-ready metrics to support internal advanced analytics and AI/ML models, dashboards, and other data 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 used by executive leadership for business insights.
• Implement and maintain a data catalog or knowledge catalog (for example, Google Data Catalog) to improve data discoverability, lineage tracking, and metadata management.
• Optimize Big Query performance using partitioning, clustering, query tuning, and cost-management best practices.
• Build and maintain data quality checks, monitoring, and alerting to support pipeline reliability and data trustworthiness.
• Partner 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 and SQL, including backend frameworks for API-based ingestion routines.
• Create and maintain CI/CD pipelines to support deployments and change review across the code base.
• Participate in code reviews and architecture discussions, including CI/CD pipeline development for data and application deployments.

• Bachelor’s degree in computer science, engineering, information systems, or a related field (or a 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, Google Big Query, and Dataflow.
• 3 years of hands-on experience with Google Big Query 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 of experience using business intelligence tools such as 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 strong understanding of testing, monitoring, reliability, and maintainable software design.

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

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