Senior Health Intelligence & BI Developer

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

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.