Senior Data & Analytics Engineer

Ford • Dearborn, MI

9h • Hybrid

About The Position

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

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

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

What This Job Offers

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