Operations Data Analyst II (Contractor)

Latitude AI • Pittsburgh, PA

3d

About The Position

Latitude AI is hiring an Operations Data Analyst II as a 12-month contractor on the Continual Services Improvement (CSI) team within Latitude Operations. The CSI team supports departments across Latitude through project and program management, efficiency improvements, policy development, and data analytics. This role will analyze complex datasets, work primarily with BigQuery schemas, and develop production-level data models used by multiple teams. The analyst will also investigate data quality issues, work with existing data logic, collaborate through Git and GitHub, and assist with scripted data intake and application integrations.

Requirements

• Bachelor’s degree in Mathematics, Statistics, Computer Science, or a related field.
• At least 2 years of 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 in Linux environments to manage files, execute scripts, and navigate server-side directories.
• Advanced expertise writing, optimizing, and troubleshooting complex SQL queries to extract and transform data from cloud-based database schemas.
• Hands-on experience with data transformation tools and version control systems such as 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 exploratory data analysis skills and ability to identify logic-based solutions for data intake and application integrations.

Responsibilities

• Apply exploratory data analysis to identify trends, anomalies, and opportunities in complex datasets.
• Navigate and query 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.
• Use dbt within a code repository to build, test, and deploy production-level data models used by multiple teams.
• Investigate and resolve data quality issues across data tables to ensure accuracy and reliability.
• Review existing complex queries by tracing and interpreting multiple layers of data logic.
• Use Git and GitHub version control, including creating feature branches, committing changes, and submitting pull requests for code review.
• Assist in implementing lightly scripted solutions for data intake and integrations between applications.

What This Job Offers

• Career Level: Mid Level