ETL Developer

---

Job description

Company: MHK

Position: ETL Developer

Salary: 80 -110K

Role Overview:

The ETL Developer works closely with the development and product teams to build ETL solutions for large data sets. Also, will analyze data and provide solutions for transformation of the data sets for use within software application requirements. Required to document data ETL procedures/processes. You will also participate and lead data-integration related activities for new and existing customers.

Responsibilities:

• Leads the design, development, and implementation of ETL processes, while providing oversight of the maintenance of complex and sometimes unique business solutions.

• Manage and deliver ETL solutions by coordinating with product SMEs and customers to understand the business requirements.

• Recognizes the connection between the business operations and analytics to influence business strategies and solutions. Develops innovative approaches to address business problems and solutions.

• Parse data from various health standard data formats like EDI, HL-7 formats and store it into the data warehouse.

• Create and improve data workflows, crosswalks and outputs using data analytic tools to ensure efficiency, accuracy in meeting project specifications and deliverables.

• Execute, maintain, and troubleshoot existing scripts and reports developed using SQL, Microsoft Excel, or other analytics tools. Monitor data loads and fix errors during the load process and perform quality control on ingested data.

• Support execution of large-scale projects with limited direction from leadership.

• Design SQL queries and maintain database by updating database fields, properties and configuring jar files.

• Responsible for maintaining work in Python, SQL, HTML, Java or other similar coding languages.

• Will be expected to meet with plans and any applicable vendors to understand requirements, conduct testing sessions and troubleshoot issues

Education/Experience:

• Bachelor's degree in Computer Science, Information Systems, or equivalent background or experience.

• 3+ years of experience in an Information Technology/Software Development team.

Page 2

• Experience with Agile software engineering (Scrum, Kanban, Lean etc.) is preferred.

• 1+ years of Experience with ETL is required.

• Experience with Business Intelligence tools such as Spago (Knowage), SAP Business Objects, Microsoft BI Stack, Power BI and Tableau is preferred.

• Experience with Jasper Reports, Flatworm parser preferred.