Note: The job is a remote job and is open to candidates in USA. Latitude AI develops automated driving technologies, and they are seeking an Operations Data Analyst II to support various departments through data analytics and project management. The role involves applying exploratory data analysis skills, optimizing SQL queries, and ensuring data quality across systems.
Responsibilities
- Apply strong exploratory data analysis skills to identify trends, anomalies, and opportunities within complex datasets
- Navigate and query various data management systems, primarily BigQuery schemas, to extract and manipulate raw data
- Construct, optimize, and troubleshoot complex SQL queries to join, filter, and transform data from disparate tables
- Leverage development tools like dbt (data build tool) within a code repository to build, test, and deploy production-level data models used by multiple teams
- Actively investigate and resolve data quality issues across various data tables to ensure accuracy and reliability
- Efficiently review and understand existing complex queries by tracing and interpreting multiple layers of data logic
- Interface with version control systems, specifically Git and GitHub, by creating feature branches, committing changes, and submitting pull requests for code review
- Assist in implementing lightly scripted solutions for data intake and integrations between our applications
Skills
- Bachelor's Degree in Mathematics, Statistics, Computer Science, or a related field
- 2+ years experience in a data analysis or business intelligence role
- Technical proficiency in multiple coding languages including SQL, Python, C++, and Javascript for data manipulation and software integration
- Experience operating within Linux environments to manage files, execute scripts, and navigate server-side directories
- Advanced expertise in writing, optimizing, and troubleshooting complex SQL queries for extracting and transforming data from cloud-based database schemas
- Hands-on experience with data transformation tools and version control systems like Git to build and maintain production-level data models
- Knowledge of Jira and Atlassian automation to configure technical workflows, manage task tracking, and streamline project delivery
- Strong skill set in exploratory data analysis and identifying logic-based solutions for data intake and application integrations
Company Overview