Ford Motor Company

Senior Data & Analytics Engineer

Ford Motor Company

full-time

Posted on:

Location Type: Hybrid

Location: DearbornMissouriUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $128,710 - $160,938 per year

Job Level

About the role

  • 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
  • 5 years of progressive, post-baccalaureate experience in the job offered or related occupation
  • 5 years of experience with the following skill is required: 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: Programming in Python and Java, Using SQL, Analytical tools (Looker studio, Qliksense, BigQuery, and Alteryx), and DevOps tools (GitHub), Writing sophisticated SQL queries to extract and transform big data
  • 2 years of experience with each of the following skills is required: Using Cloud platform, with a focus on managing cloud infrastructure and deploying production-scale solutions, 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.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ETLdata modelingdata integrationSQLPythonDBTdata governancedata transformationcloud infrastructuredata warehousing
Soft Skills
collaborationleadershipmentorshipcommunicationanalytical thinkingproblem-solvingdocumentationknowledge sharingstrategic guidancestakeholder engagement