Data Engineer, Pro360 Product Group

Ford • Dearborn, MI

9h • $115,000 - $192,900 • Hybrid

About The Position

Ford Pro is a global business within Ford dedicated to helping commercial customers maximize productivity. Ford Pro offers a work-ready portfolio of vehicles, accessories, and services for nearly every vocation, powered by advanced technology and designed for maximum uptime. As a one-stop shop, Ford Pro provides a full range of electrified and internal combustion vehicles that integrate seamlessly with the Ford Pro ecosystem, enabling customers to succeed today and into the future of electrification.
Ford GDIA – Data & Analytics (D&A) is a global team responsible for delivering enterprise data services, modern business intelligence, and advanced analytics solutions that power Ford Pro. Our work enables Ford Pro to operate as an analytics-driven business in a highly competitive market.
We are looking for experienced Data & Analytics professionals to join our product teams and help shape the next generation of commercial business solutions. D&A Cloud Data Engineers work in a product delivery model, partnering closely with business stakeholders, analytics managers, product owners, product designers, data scientists, business intelligence engineers, and software developers to drive innovation from concept to deployment.
This is a fast-paced and highly impactful role that requires strong technical expertise in data engineering and analytics, along with the ability to deliver meaningful outcomes for the Ford Pro commercial business.
Pro360 Product Group
Pro360 Product Group leads the design and development of core operational data capabilities for Ford GDIA. This includes:
ELT, EL, and ETL processes
Multi-tier data model design and implementation
Data quality strategy and monitoring
Domain expertise across enterprise data sets
Third-party data evaluations
Development of intelligence layers to improve data accessibility and usability

Requirements

• Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related technical discipline
• 3+ years of experience with SQL and Python
• 2+ years of experience using GitHub and Terraform for code development and infrastructure management
• 2+ years of experience orchestrating data pipelines using Airflow or a similar cloud-based service
• 2+ years of experience with GCP or AWS cloud services
• Candidates with 5+ years of experience in a traditional data warehouse environment, including ETL development with tools such as Informatica, will also be considered
• 3+ years of experience building data pipelines from scratch in distributed and fault-tolerant environments
• Experience working with a wide range of relational and non-relational databases
• Proven track record of building applications and solutions in data-focused roles across both cloud and traditional data warehouse environments

Nice To Haves

• 1+ years of experience with continuous integration and continuous delivery (CI/CD), preferably using Tekton

Responsibilities

• Develop EL, ELT, and ETL pipelines to make data available in BigQuery for Salesforce CRM, Business Intelligence, Data Science, Marketing Analytics, and other technology teams.
• Work with both on-premises data sources such as Hadoop and SQL Server, as well as cloud-native platforms such as GCP, to understand business rules and data models and build scalable data pipelines.
• Design and implement data ingestion and transformation solutions using GCP services such as Dataflow, Data Fusion, DataProc, Cloud Functions, and Cloud Run.
• Provision and manage data products using BigQuery, Cloud SQL, Pub/Sub, APIs, and other cloud-based services.
• Build cloud-native services and APIs to support and expose data-driven solutions.
• Partner closely with data scientists and analytics teams to ensure timely delivery of high-quality data for impactful business solutions.
• Design, build, and launch shared data services for internal and external developer communities.
• Create scalable, reliable, and fault-tolerant data pipelines while selecting the right tools and technologies for each use case.
• Monitor, optimize, and manage data pipelines to meet operational, performance, and scalability requirements.
• Provide technical and strategic guidance to stakeholders on data transformation initiatives and help the organization better understand and leverage enterprise data.

Benefits

• Immediate medical, dental, vision and prescription drug coverage
• Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up childcare 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: Mid Level