Health Intelligence Programmer, Senior

Acentra; Northern (KY); On-site; USD 101,000 - 126,000; Full time

Job summary

Acentra Health is seeking a Health Intelligence Programmer, Senior to join our team. This role focuses on developing, enhancing, and maintaining core data processing platforms, building data pipelines, and delivering actionable reporting for health care data.

You will work with SQL, SSIS/SSRS/SSAS, and BI tools like Tableau or Power BI, ensuring HIPAA compliance and collaboration with customers and internal teams.

Qualifications

• Bachelor of Science in Information Systems, Computer Science, or Health Services Research; Master's degree preferred.
• Proficiency in business intelligence and data warehouse methodologies.
• Knowledge of database management systems (DBMS).
• Senior-level SQL skills.
• Proficiency in Microsoft SQL tools including SSMS, SSRS, SSAS, and SSIS.
• Skilled in requirement gathering and documentation.
• Skilled in data architecture, data modeling, and performance tuning.
• Familiarity with BI tools such as Tableau, Power BI, Qlik, etc.

Responsibilities

• Build and maintain data pipelines across various environments.
• Work with data transformation packages to support data modeling and advanced analytical processing.
• Analyze healthcare claim and utilization management data to support the business intelligence unit.
• Query existing databases to pull data necessary for reporting and data transformation.
• Develop, enhance, and maintain data processing platforms.
• Work collaboratively with internal and external customers to create business requirements.
• Identify and develop opportunities for process improvement through data processing, data architecture, and performance tuning.
• Research data discrepancies and troubleshoot complex SQL queries, SSIS packages, data transformations, views, and stored procedures.
• Create scripts for new database objects.
• Serve as a programming mentor and subject matter expert.
• Develop complex queries, ETL jobs, and data transformation jobs.
• Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules.

Skills

SQL

Microsoft SQL tools (SSMS SSRS SSAS SS

Education

Bachelor of Science in Information Systems, Computer Science, or Health Services Research

Master's degree preferred

Tools

Visual Studio

Azure DevOps / TFS

Tableau

Power BI

Qlik

Job description

Company Overview

Acentra Health exists to empower better health outcomes through technology, services, and clinical expertise. Our mission is to innovate health solutions that deliver maximum value and impact.

Lead the Way is our rallying cry at Acentra Health. Think of it as an open invitation to embrace the mission of the company; to actively engage in problem-solving; and to take ownership of your work every day. Acentra Health offers you unparalleled opportunities. In fact, you have all you need to take charge of your career and accelerate better outcomes – making this a great time to join our team of passionate individuals dedicated to being a vital partner for health solutions in the public sector.

Job Summary and Responsibilities

Acentra Health is looking for aHealth Intelligence Programmer, Senior to join our growing team.

Job Summary:

• This position is responsible for developing, enhancing, and maintaining the core data processing platforms of the company, driving business solutions by querying existing databases to create data models for actionable reporting, and creating and maintaining reporting applications that result in efficient data extraction.

Responsibilities:

• Build and maintain data pipelines across various environments.
• Work with data transformation packages to support data modeling and advanced analytical processing.
• Analyze healthcare claim and utilization management data to support the business intelligence unit.
• Query existing databases to pull data necessary for reporting and data transformation.
• Develop, enhance, and maintain data processing platforms.
• Work collaboratively with internal and external customers to create business requirements.
• Identify and develop opportunities for process improvement through data processing, data architecture, and performance tuning.
• Research data discrepancies and troubleshoot complex SQL queries, SSIS packages, data transformations, views, and stored procedures.
• Create scripts for new database objects.
• Serve as a programming mentor and subject matter expert.
• Develop complex queries, ETL jobs, and data transformation jobs.
• Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules.

Qualifications

Required Qualifications

• Bachelor of Science in Information Systems, Computer Science, Health Services Research; Master's degree preferred.
• Proficiency in business intelligence and data warehouse methodologies.
• Knowledge of database management systems (DBMS).
• Senior-level SQL skills.
• Proficiency in Microsoft SQL tools including SSMS, SSRS, SSAS, and SSIS.
• Skilled in requirement gathering and documentation.
• Skilled in data architecture, data modeling, and performance tuning.
• Familiarity with BI tools such as Tableau, Power BI, Qlik, etc.

Preferred Qualifications

• Prior experience working with healthcare claim and utilization management data.
• Familiarity with Visual Studio and TFS/Azure DevOps source control.
• Familiarity with agile methodology.
• Experience supporting ETL development.

Why us?

We are a team of experienced and caring leaders, clinicians, pioneering technologists, and industry professionals who come together to redefine expectations for the healthcare industry. State and federal healthcare agencies, providers, and employers turn to us as their vital partner to ensure better healthcare and improve health outcomes.

We do this through our people.

You will have meaningful work that genuinely improves people's lives across the country. We are a company that cares about our employees, and we give you the tools and encouragement you need to achieve the finest work of your career.

Benefits

Benefits are a key component of your rewards package. Our benefits are designed to provide you with additional protection, security, and support for both your career and your life away from work. Our benefits include comprehensive health plans, paid time off, retirement savings, corporate wellness, educational assistance, corporate discounts, and more.

Experience in Lieu of Degree

For non-clinical roles, or when not required by the contract specifically, the Company acknowledges that practical, hands-on experience can provide skills and competencies equivalent to formal education. As such, in cases where a Bachelor's degree may be required, the Company will accept a minimum of six (6) years of directly relevant professional experience in lieu of a degree. In instances where the candidate has an Associate's degree, the Company will accept a minimum of three (3) years of directly relevant professional experience in lieu of the Bachelor's degree.

Compensation

The pay range for this position is listed below.

“Based on our compensation philosophy, an applicant’s position placement in the pay range will depend on various considerations, such as years of applicable experience and skill level.”

EEO AA M/F/Vet/Disability

Acentra Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability, status as a protected veteran or any other status protected by applicable Federal, State or Local law.

Pay Range

USD $100,960.00 - USD $126,200.00 /Yr.