Senior Data & Analytics Engineer

At Ford Motor Company we believe freedom of movement drives human progress. We also believe in providing you with the freedom to define and realize your dreams. With our incredible plans for the future of mobility we have a wide variety of opportunities for you to accelerate your career potential as you help us define tomorrows transportation.

Working within our Marketing Sales & Service organization gives you the opportunity to advance the Ford reputation as a visionary vehicle and mobility services company delivering a trusted customer experience. Were looking for insightful individuals with the marketing sales and service expertise to turn data-driven insights into innovative solutions that enhance sales and customer loyalty. If you have an audience-first mindset join us and be the eyes ears and voice of Ford.

What youll be able to do:

Senior Data & Analytics Engineer - positions offered by Ford Motor Company (Dearborn Michigan). Note this is a hybrid position whereby the employee will work both from home and from the Dearborn office. Hence the employee must live within a reasonable commuting distance from Dearborn 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. Hands on experience is a must. 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.

Youll have

Bachelors degree or foreign equivalent in Mechanical Engineering Electrical Engineering Electronics Engineering Computer Engineering Aerospace Engineering Automotive Engineering or related field and 5 years of progressive post-baccalaureate experience in the job offered or related occupation. 5 years of experience with the following skill is required: 1. Designing and implementing large-scale data warehouses ETL processes and complex SQL development. 3 years of experience with each of the following skills is required:1. Programming in Python and Java. 2. Using SQL Analytical tools (Looker studio Qliksense BigQuery and Alteryx) and DevOps tools (GitHub). 3. Writing sophisticated SQL queries to extract and transform big data. 2 years of experience with each of the following skills is required: 1. Using Cloud platform with a focus on managing cloud infrastructure and deploying production-scale solutions. 2. Building dashboards using Qliksense and Lookerstudio and providing analytical insights with the data.

We are offering a salary of$128710.00 - $160938.60/yr.

You may not check every box or your experience may look a little different from what weve 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 builderor all the above No matter what you choose we offer a work life that works for you including:

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 Years Day
Paid time off and the option to purchase additional vacation time.

For a detailed look at our benefits click here:

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 the United States if you need a reasonable accommodation for the online application process due to a disability please call 1-.

#LI-DNI

#DNP