Operations Data Analyst II (Automotive)

TL;DR

Operations Data Analyst II (Automotive): Analyzing complex datasets to drive enterprise-wide excellence and operational efficiency with an accent on SQL query optimization and data pipeline development. Focus on building production-level data models, resolving data quality issues, and integrating disparate systems to support automated driving technology development.

Location: Must be based in Pittsburgh, PA or Detroit, MI

Company

A Ford Motor Company subsidiary developing automated driving technologies at the speed of a startup.

What you will do

• Apply exploratory data analysis to identify trends and anomalies within complex datasets.
• Construct and optimize complex SQL queries for data extraction and transformation in BigQuery.
• Build, test, and deploy production-level data models using dbt.
• Investigate and resolve data quality issues to ensure system reliability.
• Manage code versions and collaborate via Git and GitHub.
• Implement scripted solutions for data intake and application integrations.

Requirements

• Must be legally authorized to work in the United States on a permanent basis.
• Bachelor’s degree in Mathematics, Statistics, Computer Science, or related field.
• 2+ years of experience in data analysis or business intelligence.
• Advanced proficiency in SQL, Python, C++, and Javascript.
• Experience operating within Linux environments.
• Hands-on experience with data transformation tools and version control systems.

Culture & Benefits

• Work alongside leading experts in machine learning and robotics.
• Opportunity to impact driving safety for millions of people.
• Fast-paced environment combining startup agility with automotive industry scale.
• Equal Opportunity Employer committed to a diverse workforce.