ETL Engineer

Ensemble Health Partners

About The Position

Ensemble is a leading provider of technology-enabled revenue cycle management solutions for health systems, including hospitals and affiliated physician groups. They offer end-to-end revenue cycle solutions as well as a comprehensive suite of point solutions to clients across the country. Ensemble keeps communities healthy by keeping hospitals healthy. We recognize that healthcare requires a human touch, and we believe that every touch should be meaningful. This is why our people are the most important part of who we are. By empowering them to challenge the status quo, we know they will be the difference! O.N.E Purpose: Customer Obsession: Consistently provide exceptional experiences for our clients, patients, and colleagues by understanding their needs and exceeding their expectations. Embracing New Ideas: Continuously innovate by embracing emerging technology and fostering a culture of creativity and experimentation. Striving for Excellence: Execute at a high level by demonstrating our “Best in KLAS” Ensemble Difference Principles and consistently delivering outstanding results. The Opportunity: Designing and developing (enhancements and maintenance) new ETL and Business Intelligence Solutions using the Microsoft SSIS and SQL Server Relational Database technologies. Monitor production jobs, maintain, and enhance legacy ETL processes on a regular basis. Improve slow running jobs with the help of redesign and better ETL processes to meet business needs. Work very closely with the existing team to design, model, develop, and maintain existing and new SQL databases objects required for all business solutions. The Software Senior Engineer designs, develops, and maintains complex software applications that support healthcare revenue cycle operations. Ensures high-quality, scalable solutions that optimize performance and compliance with industry standards. Collaborates with cross-functional teams to deliver innovative technology solutions that enhance operational efficiency and client satisfaction. Develops and implements software solutions using modern programming languages and frameworks, ensuring adherence to best practices in coding, testing, and deployment. Analyzes business requirements, translates them into technical specifications, and provides guidance on system architecture and design. Troubleshoots and resolves complex technical issues, optimizes application performance, and ensures data security and compliance with healthcare regulations. Mentors junior developers, contributes to code reviews, and actively participates in continuous improvement initiatives to enhance development processes and product quality.

Requirements

Microsoft SSIS
SQL Server Relational Database technologies

Responsibilities

Designing and developing (enhancements and maintenance) new ETL and Business Intelligence Solutions using the Microsoft SSIS and SQL Server Relational Database technologies.
Monitor production jobs, maintain, and enhance legacy ETL processes on a regular basis.
Improve slow running jobs with the help of redesign and better ETL processes to meet business needs.
Work very closely with the existing team to design, model, develop, and maintain existing and new SQL databases objects required for all business solutions.
Designs, develops, and maintains complex software applications that support healthcare revenue cycle operations.
Ensures high-quality, scalable solutions that optimize performance and compliance with industry standards.
Collaborates with cross-functional teams to deliver innovative technology solutions that enhance operational efficiency and client satisfaction.
Develops and implements software solutions using modern programming languages and frameworks, ensuring adherence to best practices in coding, testing, and deployment.
Analyzes business requirements, translates them into technical specifications, and provides guidance on system architecture and design.
Troubleshoots and resolves complex technical issues, optimizes application performance, and ensures data security and compliance with healthcare regulations.
Mentors junior developers, contributes to code reviews, and actively participates in continuous improvement initiatives to enhance development processes and product quality.