ETL Developer

HealthEdge - Springfield, IL

Full-time - Mid Level

Remote - Springfield, IL

About the position

The ETL Developer at HealthEdge Software Inc. is responsible for designing, implementing, and supporting ETL processes that handle large healthcare data sets. This role requires a strong background in scripting languages and database management, with a focus on ensuring the performance and reliability of the product. The developer will collaborate with various stakeholders and cross-functional teams to enhance product features and troubleshoot technical issues, all while adhering to company policies related to information privacy and security.

Responsibilities

• Design, implement, and support ETL processes for large healthcare data sets.
• Develop new features and enhancements to align with product releases.
• Recommend and design best practices for efficient data loads.
• Deploy, orchestrate, and monitor ETL jobs.
• Create process, architecture, and deployment documentation.
• Interact with customers to troubleshoot technical issues.
• Perform production support activities and provide immediate solutions to issues.
• Actively participate in team meetings and scrum activities.
• Communicate effectively with team members and stakeholders.
• Provide high-quality work and identify opportunities for continuous improvement.
• Support during weekends as needed.
• Work during EST business hours to align with client operations.

Requirements

• Bachelor's degree in Computer Science or related fields (or equivalent work experience).
• 3+ years of hands-on coding/scripting experience in Python, C#, Shell.
• 3+ years of experience working with SQL, including query optimizations and writing stored procedures.
• Prior exposure to Airflow is a plus.
• Knowledge of healthcare data and EDI files like 834, 278, 837, 999.
• Experience with NoSQL databases like MongoDB.
• Familiarity with version control systems like Bitbucket/Git.
• Strong troubleshooting and problem-solving skills.
• Good understanding of SDLC and Agile methodologies.
• Experience with ticketing tools such as JIRA.
• Ability to prioritize and execute tasks in a high-pressure environment.
• Ability to work independently and collaboratively with multidisciplinary teams.
• Excellent written and verbal communication skills.

Nice-to-haves

• Experience with CI/CD pipelines.
• ETL development experience using Talend Studio.
• Familiarity with claim systems like Facets, QNXT, and Health Rules Payor.
• Knowledge of Azure pipelines.
• Hands-on experience with messaging platforms such as Azure Service Bus/Kafka.

Benefits

• Full-time, permanent employment.
• Remote work flexibility.
• Diversity and inclusion initiatives.
• Opportunities for professional development.