Senior ETL/ELT Engineer (Chicagoland or Remote)
Discovery Health Partners offers payment and revenue integrity solutions that help health payers improve revenue, avoid costs, and enhance the member experience. We offer a unique combination of deep healthcare expertise and analytics-powered technology solutions to help our clients improve operational efficiency, achieve financial integrity, and generate measurable results.
These solutions reside on the 100% cloud-based and HIPAA-compliant Healthcare Analytics Platform, which combines sophisticated data mining with workflow management and reporting and dashboards. For the last three years, LaunchPoint has appeared on the INC. 5000 list of fastest growing privately held firms in the U. S. and in 2016 was cited as the #4 fastest growing company in the Chicagoland area.
Discovery Health Partners is looking for a Senior ETL/ELT Engineer to work at Itasca, IL corporate office. This is a full-time position. This professional will be responsible for supporting the company s payment integrity applications, database and reporting needs. Primary responsibilities will be to analyze, design, develop, implement and maintain technical solutions in AWS using data warehouse technologies, SQL Server 2016 with sharding, distributed cache solution, PostgreSQL, SSIS, and ETL solutions (Athena, HIVE, Hadoop clusters with Spark, Zeplin). Key Role/Responsibilities: - Assist in creating technical solutions to satisfy business requirements through database and application design and development. - Lead data modeling and requirements analysis efforts. - Debug and optimize enterprise distributed database-driven applications. - Create backup and archiving strategies for big data stored in various formats (files, SQL and NoSQL databases, etc.) - Assist in the development of database and application interfaces between various hardware and/or software systems. - Create data integration and technical solutions around Microsoft SQL Server, AWS RedShift and HBase, Redis, Hadoop, Athena. - Create and maintain various data import/export processes using ETL/ELT solutions such as SQL Server Integration Services, and HIVE/Spark. - Assist technical and business analyst in the preparation of the data analysis materials. - Participate in application design discussions and the change management process. - Apply a high standard of customer service when interacting with all levels of staff. - Responsible for maintaining technical documentation to support new and existing solutions. - Assist with other special projects or related duties as assigned.