EHR Data Report Writer and Developer II

BHcare; North Haven (CT); On-site; USD 49,000 - 64,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

Paid time off

Company-observed holidays

Retirement savings plan

Job summary

BHcare is seeking an analytical EHR Data Report Writer & Developer II to drive data-driven decision making via advanced reporting, BI solutions, and EHR enhancements. You’ll collaborate across departments to translate business needs into robust data extracts, dashboards, and reliable workflows within our health information systems.

The role requires strong SQL, data governance awareness, and experience with production reporting environments.

Qualifications

• Requires a Bachelor’s degree in Computer Science, Information Systems, Health Informatics, or a related field or 4+ years of directly related experience.
• Advanced SQL skills including multi-table joins, subqueries, stored procedures, and query optimization.
• Experience developing reports and supporting applications in a production environment.
• HIPAA knowledge and PHI management.
• Strong analytical, troubleshooting, organizational, and communication skills.

Responsibilities

• Design, develop, and maintain reports, dashboards, and data extracts for clinical, operational, financial, and quality initiatives.
• Partner with BHcare departments to translate business needs into reporting and EHR solutions.
• Configure, test, implement, and support EHR enhancements, workflows, forms, interfaces, and system upgrades.
• Troubleshoot reporting, application, and data issues; provide technical support and end-user training.
• Monitor data integrity, system performance, and integrations between the EHR and other platforms.
• Administer user access; support HIPAA compliance and data governance efforts.
• Collaborate with vendors and stakeholders to drive continuous improvement and regulatory reporting.

Skills

Advanced SQL

Data reporting

Analytical thinking

Troubleshooting

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

Qualifacts CareLogic

Pentaho

Looker

AI tools for SQL development

Job description

EHR Data Report Writer & Developer II

BHcare | Information Technology & Electronic Health Records

At BHcare, we use technology and data to improve the quality of care delivered to individuals and families throughout our communities. We're seeking an analytical, solutions-focused EHR Data Report Writer & Developer II to help drive organizational performance through innovative reporting, system optimization, and data-driven decision-making.

This position is full-time, 37.5 hours per week.

Candidates must reside in Connecticut to be eligible for this position.

What You’ll Do:

• Design, develop, and maintain reports, dashboards, and data extracts that support clinical, operational, financial, and quality initiatives.
• Partner with departments across BHcare to translate business needs into effective reporting and EHR solutions.
• Configure, test, implement, and support EHR enhancements, workflows, forms, interfaces, and system upgrades.
• Troubleshoot reporting, application, and data issues while providing technical support and training to end users.
• Monitor and maintain data integrity, system performance, and integrations between the EHR and other platforms.
• Administer user access, support compliance with HIPAA and confidentiality requirements, and assist with data governance efforts.
• Collaborate with vendors and internal stakeholders to drive continuous improvement, optimize system functionality, and support regulatory reporting requirements.

What You’ll Bring:

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Health Informatics, or a related field and at least two years of report development experience; OR four or more years of directly related experience in lieu of a degree.
• Advanced SQL skills, including multi-table joins, subqueries, stored procedures, and query optimization.
• Experience developing reports and supporting applications in a production environment.
• Knowledge of HIPAA requirements and protected health information (PHI) management.
• Strong analytical, troubleshooting, organizational, and communication skills.

Preferred Qualifications

• Experience with EHR administration, development, or support.
• Experience with Qualifacts CareLogic.
• Knowledge of 42 CFR Part 2 regulations.
• Behavioral health, healthcare, or community health reporting experience.
• Familiarity with Pentaho, Looker, or similar ETL and business intelligence platforms.
• Experience utilizing AI tools for SQL development, data analysis, or technical documentation.

What We Offer:

The anticipated salary range for this position is $35.90 - $46.15. Actual compensation offered will be determined based on a variety of factors including relevant skills, experience, qualifications, certifications, and internal equity considerations.

BHcare offers a comprehensive benefits program including medical, dental, and vision insurance, paid time off, company-observed holidays, a retirement savings plan, and other fringe benefits. Benefit eligibility may vary based on position, schedule, and applicable plan or policy requirements.

BHcare is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, pregnancy, sexual orientation, gender identity or expression, national origin, ancestry, age, military or veteran status, disability, genetic information, marital or civil union status, or any other protected characteristic under applicable federal, state, or local law.