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 tomorrow’s 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. We’re 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 you'll 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, MI. 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. 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.

You'll have…

Bachelor’s 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 $128,710.00 - $160,938.60/yr. 

You may not check every box, or your experience may look a little different from what we've 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 builder…or 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 Year's Day
• Paid time off and the option to purchase additional vacation time.

For a detailed look at our benefits, click here:

https://fordcareers.co/GSRnon-HTHD

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

#LI-DNI

#DNP