Senior Data & Analytics Engineer

Ford Motor • Dearborn, MI

2h • $128,710 - $160,939 • Hybrid

About The Position

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.

Requirements

• 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.

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. 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.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level