Data Analyst

Epitec is seeking an experienced Data Analyst to join our automotive client's team in Dearborn, MI. As a Data Analyst, the candidate will play a pivotal role in bridging the gap between the physical world of automotive testing and the digital world of big data. In this role, you won't just sit behind a screen. You will be a key part of the feedback loop that makes ADAS features exciting for customers. • This is a hybrid position in Dearborn, MI (4 days onsite, 1 day remote) • This is an ongoing W2 contract (with potential for conversion) Top Responsibilities: • Participate in hands-on in-vehicle test drives (development vehicles in Dearborn) to validate ADAS data collection functions and triggers • Execute structured vehicle test plans and document results, including edge cases and failures • Perform deep-dive data analysis on collected datasets to ensure data quality, accuracy, and completeness • Support end-to-end data analysis, including data ingestion, trend identification, anomaly detection, and performance tracking • Write and maintain SQL-based data models using Dataform within the Google BigQuery environment • Build, update, and maintain automated dashboards to track data collection progress and overall system health • Troubleshoot missing, incomplete, or corrupted data by debugging the pipeline from vehicle sensors to cloud systems • Collaborate with engineers and cross-functional teams to coordinate vehicle availability and test schedules • Follow data governance and privacy standards, including proper handling of sensitive and regulated data Qualifications: • Bachelor’s Degree • 1+ year of experience in data analysis, analytics, or systems-level vehicle testing • Strong analytical skills with experience performing end-to-end data analysis and synthesizing insights into actionable recommendations • Strong troubleshooting and problem-solving skills, especially in technical or vehicle-based systems • Ability to methodically diagnose issues using logs, hardware checks, software debugging, and configuration analysis • Comfortable working in a hybrid role that combines hands-on vehicle testing with cloud-based data analytics Preferred: • Proficiency in SQL, including joins, aggregations, and subqueries • Experience using Google Cloud Platform, specifically BigQuery • Experience building dashboards and visualizations using tools such as Tableau, Looker, Power BI, or similar • Ability to perform data storytelling, translating complex datasets into clear narratives for technical and business stakeholders • Familiarity with data governance practices, including data integrity, access control, and privacy/PII handling • Exposure to automotive systems, ADAS testing, or vehicle data logging is a plus