Health Intelligence Programmer, Senior

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.

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

Job Summary:

We are seeking a Sr. Health Intelligence Programmer with a strong background in AWS cloud technologies, data transformation, and data modeling. The candidate will play a key role in migrating and optimizing our data infrastructure to AWS, while also enhancing and maintaining core data processing platforms. This role is crucial in driving business solutions by building data models and actionable reporting, with a focus on leveraging AWS resources for advanced analytics.

Responsibilities:

• Lead the migration and optimization of data platforms to AWS, leveraging AWS services such as S3, Redshift, Glue, and Lambda
• Creates and maintains conceptual, logical and physical data models using established enterprise tools and best practices
• Query and analyze existing databases to pull data necessary for reporting and transformation
• Develop, enhance, and maintain scalable data processing platforms in AWS
• Collaborate with internal and external stakeholders to gather and document business requirements
• Architect and implement data pipelines and ETL processes using AWS tools for data modeling and advanced analytics
• Optimize and debug complex SQL queries, stored procedures, and AWS data transformation tools
• Research data discrepancies and troubleshoot AWS data services, SQL queries, SSIS packages, views, and stored procedures
• Create and implement new database objects and data models through scripting in an AWS environment
• Mentor junior programmers and serve as a subject matter expert in AWS data architecture
• Design and develop complex queries, ETL jobs, and data transformation workflows to support business intelligence
• Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules

Required Qualifications

• Bachelor of Science in Information Systems, Computer Science, Health Services Research
• Extensive experience creating database tables, views, complex stored procedures, triggers, and functions
• Expertise in AWS services, including but not limited to S3, Redshift, Glue, Lambda, RDS, and other AWS data-related resources
• 6+ years of hands-on experience with SQL, programming, and performance tuning
• Experience with a host of commercial data modeling tools including Erwin Data Modeler and Microsoft SQL tools including SSMS, SSRS
• Skilled in requirement gathering and documentation
• Advanced skills in SQL query fine-tuning, stored program optimization, 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 dbeaver
• 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.

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."

Thank You!

We know your time is valuable and we thank you for applying for this position. Due to the high volume of applicants, only those who are chosen to advance in our interview process will be contacted. We sincerely appreciate your interest in Acentra Health and invite you to apply to future openings that may be of interest. Best of luck in your search!

~ The Acentra Health Talent Acquisition Team

Visit us at https://careers.acentra.com/jobs

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.

#LI-SF1