
Senior Data & Analytics Engineer
Ford Motor Company
full-time
Posted on:
Location Type: Hybrid
Location: Dearborn • Missouri • United States
Visit company websiteExplore more
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