Analyst - Data Engineering & Pipeline Development

IntroductionThe ADAS Data Analytics team is seeking a high-impact analytics professional to bridge the gap between physical automotive testing and cloud-based big data. In this role, you will be a key driver of the feedback loop for ADAS features-such as BlueCruise and Automatic Emergency Braking-by transforming raw vehicle data into actionable engineering narratives. We are looking for a developer-minded analyst with expert SQL skills and hands-on experience in the GCP/BigQuery ecosystem to build robust pipelines and high-fidelity visualizations. If you are a data storyteller who wants to see your code translate directly into physical vehicle behavior, this is the role for you.Required Skills & QualificationsAdvanced SQL Proficiency: Expert-level ability to write, debug, and optimize complex queries, including window functions, CTEs, and nested data structures.Google BigQuery Expertise: Deep understanding of BigQuery architecture, including partitioning, clustering, and slot utilization to manage large-scale datasets efficiently.Query Performance Optimization: Proven track record of auditing and refining slow-running queries to reduce computational costs and improve processing speed.Big Data Architecture: Familiarity with modern data warehouse design patterns, schema modeling (Star/Snowflake), and ETL/ELT pipelines.Prior work experience at a relevant client or in the automotive industry.Applicants must be able to work directly for Artech on W2.Preferred Skills & Qualifications Modern Data Transformation (Dataform/dbt): Experience using Dataform or dbt to manage data transformations, version control, and documentation.Python for Data Analysis: Ability to use Python (Pandas, NumPy) for data manipulation, automation, and extending analytical capabilities beyond SQL.AI-Assisted Development: Proficiency in leveraging Large Language Models (LLMs) like ChatGPT, Claude, or GitHub Copilot to accelerate code generation, SQL debugging, and documentation.Day-to-Day Responsibilities Design, develop, and maintain robust data transformation workflows using SQL and Dataform (or similar tools) within the Google Cloud Platform (GCP) / BigQuery ecosystem.Translate complex ADAS performance metrics into clear, compelling narratives for stakeholders, showing the "why" behind the numbers.Build and maintain high-fidelity data visualizations (e.g., Looker, Tableau, or PowerBI) that provide real-time insights into system performance and customer usage.For immediate consideration please click APPLY to begin the screening process with Alex.