Ford Pro · 9 hours ago
Senior Data & Analytics Engineer
20100 Rotunda Dr, Dearborn, MI, 48124, US
Full-time
Hybrid
Mid, Senior Level
$129K/yr - $161K/yr
5+ years expFord Motor Company is a leader in mobility services and is seeking a Senior Data & Analytics Engineer to enhance their marketing, sales, and service operations. The role involves leading collaboration with stakeholders to define data requirements, architecting ETL pipelines, and providing data-driven insights through advanced analytics and dashboards.
AutomotiveFleet ManagementSoftware
No H1B
Responsibilities
Lead collaboration with stakeholders and cross-functional teams to gather and define complex data requirements, ensuring alignment with strategic business objectives
Architect and implement sophisticated ETL pipelines, ensuring efficient data integration into BigQuery from diverse batch and streaming sources, with a focus on Supply Chain IT solutions
Design, build and optimize advanced data models to support comprehensive business intelligence and analytics
Spearhead the development and maintenance of data ingestion and analytics pipelines using cutting-edge tools and technologies, including Python, SQL, and DBT/Dataform
Ensure the highest standards of data quality and integrity across all data processes
Data workflow management using Astronomer and Terraform for cloud infrastructure, promoting best practices in Infrastructure as Code (IaC)
Lead the creation of interactive dashboards and reports using QlikSense, providing strategic insights and data visualization
Conduct thorough data mapping, impact analysis, root cause analysis, and document data lineage to support robust data governance
Develop comprehensive documentation for data engineering processes, promoting knowledge sharing and system maintainability
Utilize GCP monitoring tools to proactively address performance issues and ensure system resilience, while providing expert production support
Provide strategic guidance and mentorship to team members on data transformation initiatives, championing data utility within the enterprise
Qualification
Required
Bachelor's degree or foreign equivalent in Mechanical Engineering, Electrical Engineering, Electronics Engineering, Computer Engineering, Aerospace Engineering, Automotive Engineering, or related field
5 years of progressive, post-baccalaureate experience in the job offered or related occupation
5 years of experience with designing and implementing large-scale data warehouses, ETL processes and complex SQL development
3 years of experience with programming in Python and Java
3 years of experience with using SQL, Analytical tools (Looker studio, Qliksense, BigQuery, and Alteryx), and DevOps tools (GitHub)
3 years of experience with writing sophisticated SQL queries to extract and transform big data
2 years of experience with using Cloud platform, with a focus on managing cloud infrastructure and deploying production-scale solutions
2 years of experience with building dashboards using Qliksense and Lookerstudio and providing analytical insights with the data
Benefits
Immediate medical, dental, and prescription drug coverage
Flexible family care, parental leave, new parent ramp-up programs, subsidized back-up child care 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.
Company
Ford Pro
Ford Pro is a productivity accelerator designed to drive the business forward, delivering solutions to commercial customers of all sizes.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Andrew Frick
Interim Head
Recent News
2025-10-04
2025-10-01
Company data provided by crunchbase