Data Analyst II

OpenLoop is hiring a Data Analyst II to own analytics for one or more business areas and turn ambiguous business questions into actionable insights. The role analyzes health-related data, builds KPIs and dashboards, and partners with cross-functional teams to improve patient care, optimize the platform, and guide decisions.

Responsibilities:

• Own analytics for one or more business areas (e.g., Customer Success, Operations, Patient Support) end-to-end — from framing the problem to delivering the recommendation
• Independently scope ambiguous business questions into structured analyses, with limited guidance on approach
• Write and optimize SQL to pull, clean, and analyze data from multiple sources, ensuring integrity and accuracy
• Apply statistical techniques and tools (SQL, Excel, R, Python) to identify trends, patterns, and anomalies
• Build and maintain KPI frameworks, dashboards, and visualizations that stakeholders rely on to make decisions
• Partner directly with cross-functional stakeholders (finance, operations, customer success) to shape their data needs and influence outcomes with your insights
• Proactively identify and drive improvements to data collection and analysis processes

Requirements:

• Bachelor's degree in Data Science, Statistics, Mathematics, Computer Science, or a related field
• 3–5 years of experience as a data analyst or in a similar role
• Demonstrated hands-on SQL depth — able to write and troubleshoot queries independently (required)
• Proficiency in Excel and data visualization tools (e.g., Tableau, Power BI)
• Proven ability to work independently through ambiguity, managing competing priorities without close oversight
• Strong communication skills, with the ability to translate complex data into stakeholder-ready recommendations that drive action
• Effective both independently and as part of a team
• Proficiency in Zoho Analytics strongly preferred