Data Engineer

Ford Motor Company • Dearborn, MI

2h • $85,400 - $143,200 • Hybrid

About The Position

The Pro360 team is creating a seamless, data-driven ecosystem for Ford Pro. The Data Engineer is responsible for the end-to-end data lifecycle, from ingestion and transformation through visualization and executive presentation. The role uses a Google Cloud Platform-centered technology stack, including SQL and Python for scalable pipelines, and combines data engineering with DevOps through infrastructure management using Terraform and Tekton. It also supports business decision-making by presenting insights through Looker Studio and Microsoft Office tools.

The role partners with business teams and leadership to define data and reporting needs, develop trusted analytics, and communicate technical findings as actionable insights. The position is hybrid, with an expectation to work onsite four days per week. Candidates who are not within commuting distance are expected to relocate. Visa sponsorship is provided.

Requirements

• Bachelor’s degree or foreign equivalent in computer science, information technology, or a technology-related field.
• At least 5 years of professional experience in data engineering, data-platform engineering, analytics engineering, or a related discipline.
• Experience designing, building, deploying, and supporting scalable data pipelines and cloud-based data solutions.
• Experience translating business stakeholders’ data requirements into technical solutions and actionable insights.
• Strong communication, analytical, problem-solving, and stakeholder-management skills.
• Ability to work independently and collaboratively in a cross-functional Agile delivery environment.
• Strong SQL skills, including writing complex queries, optimizing performance, and managing large-scale datasets.
• Hands-on experience with BigQuery and PostgreSQL, including pgAdmin or comparable database-management tools.
• Intermediate to advanced Python coding skills for data manipulation, automation, and analysis.
• Hands-on Google Cloud Platform experience, including BigQuery, Dataflow, and Cloud Run.
• Experience designing and managing data-pipeline orchestration using Apache Airflow, Astronomer, or similar technologies.
• Experience using Terraform for cloud-infrastructure provisioning and Infrastructure as Code.
• Experience with Tekton or comparable CI/CD technologies for data-platform deployment and release automation.
• Experience using GitHub and modern development tools, including Visual Studio Code, for version control and collaborative development.
• Experience building business dashboards and visualizations using Looker Studio or similar business-intelligence tools.
• Understanding of data quality, data governance, cloud security, monitoring, and operational-support practices.
• Legally authorized to work in the United States; employment eligibility will be verified at hire.

Nice To Haves

• Master’s degree in Computer Science, Data Engineering, Analytics, or a related quantitative field.
• Experience with additional GCP services relevant to data engineering, analytics, and application development.
• Experience processing high-volume data using Apache Spark, Dataflow, or other distributed data-processing technologies.
• Familiarity with data modeling, data warehousing, and modern data-lakehouse architecture patterns.
• Experience developing executive dashboards, KPI reporting, and strategic business insights.
• Experience with Microsoft Excel, PowerPoint, and other tools used for executive communications and data storytelling.
• Experience supporting Ford Pro, fleet-management, commercial-vehicle, mobility, or customer-productivity initiatives.
• Familiarity with Agile development methods, DevOps practices, automated testing, and cloud-native engineering principles.

Responsibilities

• Design, develop, maintain, and optimize complex data pipelines using Astronomer, Apache Airflow, and related orchestration technologies.
• Build scalable data ingestion, transformation, validation, and processing solutions across structured and semi-structured data sources.
• Deploy and manage cloud-based data services on Google Cloud Platform, including BigQuery, Dataflow, and Cloud Run.
• Write advanced SQL queries to extract, transform, analyze, and optimize large-scale datasets.
• Develop clean, maintainable Python code for data transformation, automation, workflow development, and analysis.
• Design and support data models, datasets, and reporting layers for trusted business intelligence and analytics.
• Use Terraform to provision and manage cloud infrastructure through Infrastructure as Code practices.
• Build and maintain CI/CD automation using Tekton, GitHub, and related DevOps tools.
• Implement data-quality controls, monitoring, error handling, and operational-support practices to ensure pipeline reliability and data accuracy.
• Build dashboards and reporting solutions in Looker Studio to track key performance indicators and inform business stakeholders.
• Partner with business teams and leadership to understand data needs, define reporting requirements, and align data strategy with business goals.
• Translate technical findings and complex data insights into clear, concise, actionable presentations for non-technical audiences.
• Use Microsoft Office tools, including PowerPoint and Excel, to develop executive-ready analyses, reports, and presentations.
• Participate in technical design sessions, Agile planning, peer reviews, and continuous-improvement activities.
• Contribute to data-engineering standards, documentation, reusable development patterns, and a collaborative engineering culture.

Benefits

• Immediate medical, dental, and prescription drug coverage.
• Flexible family care, parental leave, new parent ramp-up programs, subsidized backup child care, and more.
• Vehicle discount program for employees and family members, and management leases.
• Tuition assistance.
• Employee resource groups.
• Paid time off for individual and team community service.
• 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: Mid Level