Data Analyst - Connie

## Overview **Compensation and Benefits Package** - Targeted base salary: 90k - 105k per year, based on experience and qualifications, plus benefits and bonuses - Benefits include the following but are not limited to health, dental, vision, life and disability insurance. CSS also has a 403(b) plan with discretionary employer match and contributions. You will be eligible for 20 days of Paid Time Off per year (accrued in accordance with CSS’s policies). PTO is in addition to 8 company designated holidays. If you are not PTO eligible, you may be eligible for applicable state and/or local sick and safe leave in accordance with the provisions of any applicable state and/or local sick and safe leave laws. **Website:** https://www.conniect.org/ **Location:** Hybrid, Hartford, CT CRISP Shared Services, Inc. is an equal opportunity employer. This means that CRISP Shared Services Inc. is dedicated to providing equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, ancestry, age, marital status, genetic information, disability, military or veteran status, or any other status protected by federal, state, or local law. We celebrate diversity and are committed to creating an inclusive environment for all team members. ## Description **Job Summary** CRISP Shared Services (CSS) provides technology and People Ops infrastructure support for the Connecticut state-wide health information exchange (HIE), Connie, a 501c3 established through state statute in 2019. Connie’s mission is to enhance the health and well-being of Connecticut residents through the provision of health information technology services. Connie supports clinical decision-making, keeps patient medical health information confidential and secure, and advances the state’s public health goals. More information about Connie is available at https://www.conniect.org/. The Data Analyst supports Connie’s mission by improving the quality, reliability, and usability of health data across participating organizations. This role plays a critical part in data quality improvement initiatives and is responsible for developing and maintaining SQL queries in Databricks to fulfill internal and external research data requests. The Data Analyst has a strong analytical mindset, experience working with healthcare data, and the ability to translate complex data requirements into accurate, well-documented queries while ensuring compliance with all privacy and security regulations. ## Requirements **Essential Duties and Responsibilities** Include the following. Other duties may be assigned. Data Quality Improvement - Monitor, analyze, and report on data quality issues across HIE data feeds (e.g., completeness, validity, and accuracy) – Using Microsoft Power BI, Microsoft Excel, and PIQXL Gateway. Partner with technical teams, data providers, and internal stakeholders to identify root causes of data quality issues and develop interventions for corrective action. - Use statistical process control to establish performance expectations, identify data quality issues, and track intervention effectiveness. - Develop data quality metrics, dashboards, and recurring reports to track improvements over time. - Conduct Post-Go-Live reviews of data quality for newly onboarded organizations. - Validate data transformations and ensure adherence to established data standards. Data Support - Translate research and stakeholder requirements into reproducible and auditable query logic. - Write, optimize, and maintain complex SQL queries to support approved research and ad hoc data requests. - Perform data extractions and aggregations while ensuring compliance with HIPAA and applicable data use agreements. - Document query logic, assumptions, and data limitations to support transparency and reproducibility. - Collaborate with researchers and internal analytics staff to refine cohort definitions and analyti…