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 insurance

Dental insurance

Vision insurance

Paid time off

Holidays

Job summary

BHcare is seeking an analytical EHR Data Report Writer & Developer II to design and optimize reports and dashboards across clinical, operational, and financial areas.

You will collaborate with clinical, quality, and IT teams to deliver data-driven insights, ensure data integrity, and support regulatory reporting. This full-time role requires strong SQL skills and experience with BI tools in a healthcare setting.

Qualifications

• Bachelor's degree in CS/IS/Health Informatics or related field with at least two years of report development experience, or four+ years of related experience without 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 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 departments to translate business needs into reporting and EHR solutions.
• Configure, test, implement, and support EHR enhancements, workflows, interfaces, and system upgrades.
• Troubleshoot reporting, application, and data issues and provide user training.

Skills

Advanced SQL

Analytical thinking

Data interpretation

Communication skills

Education

Bachelor's degree in Computer Science, Information Systems, Health Informatics, or related field

Tools

Pentaho

Looker

ETL tools

Job description

Job Details: Job Location: 127 Washington Avenue, North Haven, CT - North Haven, CT 06473, Position Type: Full Time, Education Level: High School, Salary Range: $35.90 - $46.15 Hourly, 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.

In this highly collaborative role, you'll serve as a key resource for reporting, analytics, EHR administration, and end-user support. You'll partner with clinical, operational, quality, and financial teams to develop reporting solutions, enhance workflows, ensure data integrity, and support regulatory compliance across the organization.

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.