Staff Data Analyst (SQL Developer)

ABOUT OPENLOOP OpenLoop was co-founded by CEO, Dr. Jon Lensing, and COO, Christian Williams, with the vision to bring care anywhere. Our telehealth support solutions are thoughtfully designed to streamline and simplify go-to-market care delivery for companies offering meaningful virtual support to patients across an expansive array of specialties, in all 50 states. ABOUT THE ROLE OpenLoop’s mission is to bring care anywhere by powering telehealth solutions at scale. OpenLoop is seeking a Staff Data Analyst to support the growth on our Business Intelligence team. This role will serve as an analytical partner across our growing healthcare organization. They will be responsible for shaping how data informs executive decision-making, operational excellence, regulatory compliance, and patient outcomes across our national tele-health platform. As a senior individual contributor, this role combines advanced analytics expertise with strong business partnership. IMPORTANT - PLEASE READ: - If your experience is primarily with pre-packaged data or systems, this likely isn’t the right fit. You should be able to interpret, organize, and integrate data from multiple sources, and demonstrate how you use SQL to clean and structure it in a clear, efficient way. - This role requires hands-on, day-to-day use of SQL in an advanced developer capacity. Although a Staff level Analyst may have leadership skill and experience, ALL of our analysts are still using SQL daily and often. - As part of the interview process, a skill assessment will be conducted to evaluate your SQL proficiency and analytical reasoning. WHAT YOU’LL DO: - Define, and drive analytics strategy, in partnership with executive leadership - Shape long-term KPI frameworks tied to patient outcomes, provider performance, compliance metrics, and operational scalability. - Support regulatory reporting needs and ensure analytical frameworks will align - Use SQL developer skills, you will often / daily, clean, organize and analyze data. to provide trends, patient engagement, provider performance, and quality measures.

- We are expecting you to know how to do this outside of the use of AI tools, in order to evaluate data quality. - Ensure alignment across data definitions, reporting structures, and metric calculations. - Identify risks related to accuracy, audit readiness, and healthcare requirements. - Support critical reporting tied to quality, operational and compliance initiatives. - Anticipate impacts on analytics and proactively recommend data adjustments. - Develop predictive models and forecasting using SQL, Python, R, or similar tools. - Design senior level frameworks to evaluate all operational delivery initiatives. - Build scalable, reusable data models that support enterprise-level reporting. - Serve as a strategic analytics across all operations Finance, Operations, Clinical, etc. - Translate info from non-technical stakeholders, into structured analytical plans. - Lead presentations that synthesize complex data into strategic recommendations. - Elevate standards for data quality, reporting rigor, and analytical methodologies. - Mentor Senior and mid-level analysts; in both technical and business acumenIdentify gaps in data collection, governance, and reporting processes and implement scalable improvements. WHO YOU ARE REQUIRED - Experienced (ideally between 7–10 years) professional experience with exceptionally strong analytical thinking and strategic stakeholder engagement skills, focused on driving effective and influential business decisions. This role is positioned to serve as a dependable right-hand to the director, consistently demonstrating leadership capability. - Hands on experience with data analytics, preferably within healthcare, tele-health, or highly regulated industries -- please refer to the years of experience and details above, to differentiate between the two levels.