REPORTS TO: Director, Data and Software Engineering
Keywords: Senior Data Engineer, Senior Software Engineer, data interfaces, data integrations, coding, healthcare
OVERVIEW:
The Senior Data Engineer is responsible for designing, building, maintaining, and testing of data interfaces, integrations, pipelines, processing modules, and data visualizations in support of hospital utilization management, community health, advocacy, quality and patient safety measurement, business operations, and other emerging analytic and business intelligence needs.
CHA is a not-for-profit organization, dedicated to the advancement of the health of individuals and communities in Connecticut by leading, representing, and serving Connecticut hospitals and integrated health systems, including related healthcare organizations.
JOB SUMMARY:
The Senior Data Engineer will design, build, and maintain data interfaces, integrations, pipelines, and processing modules for ChimeData’s data assets. This individual is part of a small team responsible for designing and developing high performance and scalable solutions, working with complex high volume real-time and batch data sources. The Senior Data Engineer will contribute to ongoing support of ChimeData services by performing functions such as testing, documentation, user support, and validation. While the majority of ChimeData’s assets are hosted on premises, cloud migration and offerings will be part of our future.
DESCRIPTION OF DUTIES:
1. Analyze and translate business requirements and specifications into technical design specifications.
2. Design and build data integration, pipeline, and process modules capable of handling complex high volume near real-time and batch data feeds.
3. Write queries and stored procedures, build tables, and optimize database operations.
4. Work with vendor support teams to address platform issues or limitations.
5. Build and maintain custom web applications to support data entry and analytics.
6. Log change requests and issues related to data integration, pipeline, and process enhancements and modifications.
7. Document and maintain data integrations, pipelines, and processes in ChimeData’s data infrastructure.
8. Support both existing and new data integrations, pipelines, and processes, and provide backup for other team members, as needed.
9. Identify the steps/tasks needed to complete a project and tracks progress in project management software.
QUALIFICATIONS:
1. A Bachelor’s degree is required in Computer Science, Computer Information Systems, or Information Technology, with at least five (5) years of experience designing and building scalable / high performance data systems.
2. Strong experience with data integration, pipelining, processes, and interface engines (Talend Data Fabric, Lyniate Rhapsody, Microsoft Integration Services).
3. Experience working with large datasets, consisting of structured and semi-structured data from a variety of sources (FTPs, RDBMs, APIs, Interface Engines) and formats (CSV, XML, JSON, Excel).
4. Extensive experience with relational database technologies, MS SQL and PostgreSQL. Experience with NoSQL technologies is preferred.
5. Experience supporting databases, pipelines, and processes in cloud environments (AWS, Azure, Google).
6. Knowledge of Electronic Health Record (EHR) data, Admit-Discharge-Transfer (ADT), Fast Healthcare Interoperability Resources (FHIR), Continuity of Care Document (CCD), Administrative Claims, and Electronic Data Interchange 837 (EDI 837) is preferred.
7. Strong experience with Object-oriented programming languages (C++, Java, C# .NET).
8. Experience with scripting languages and frameworks (JavaScript, Python, jQuery, Angular).
9. Ability to troubleshoot problems, identify defects in logic or code and resolve issues efficiently.
10. Attention to detail, ability to produce accurate and high-quality work is critical.
11. Ability to shift focus to support high-priority ad-hoc requests while managing multiple long-term projects and deadlines.
12. Experience and strong desire to work in a team-oriented, collaborative environment; ability to establish effective interpersonal relationships and articulate information needs and potential blockers.