Senior Health Intelligence Programmer

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 company’s mission, actively engage in problem-solving, and take ownership of your work daily. 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 seeks a Senior Health Intelligence Programmer to join our growing team.

Job Summary:

We are seeking a Senior Health Intelligence Programmer with a strong database background in SQL and AWS services. The candidate will assist with re-engineering current database systems to transition from SQL Server to the AWS cloud while continuing to support existing SQL Server report requests. 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.

*Position is remote within the United States.

Job Responsibilities: 

• Participate in the migration and re-engineering of existing SQL databases to AWS Redshift
• Analyze and design database systems and reports to determine the new report database requirements
• Develop and implement database objects and code to address business requirements
• Optimize and debug SQL queries, stored procedures, database transformations, and processes for both Redshift and SQL Server to ensure efficiency
• Maintain and enhance scalable database structures to ensure high performance and reliability
• Create and manage database objects such as tables, views, indexes, stored procedures, and triggers
• Write new stored procedures and design optimized views to improve database functionality and performance
• Collaborate with internal and external stakeholders to define database design requirements and specifications
• Mentor junior programmers and provide guidance on best practices in AWS Redshift and database design
• Design and implement data pipelines and ETL processes to facilitate efficient data flow and integration
• Research and resolve data inconsistencies and issues in database systems

Requirements

Required Qualifications/Experience:

• Bachelor’s degree in information systems, Computer Science, or a related field (Master’s degree preferred)
• 10+ years of hands-on experience with SQL, database programming, and performance tuning
• …