SENIOR ETL DEVELOPER

POSITION OVERVIEW

Dazzlon is looking for a Senior ETL Developer works with the ETL Supervisor and ETL team in accelerated development and deployment of health care ETL, EDI and proprietary interfaces. Working closely with developers, a data architect, analysts, and business users, the Sr. ETL Developer is challenged with implementing robust, reusable development for SSIS and ETL packages.

 

WHAT YOU’LL BE DOING

As a Senior ETL Developer at Dazzlon, you will be expected to:

  • Provide support to IT management with developing and implementing a comprehensive ETL & EDI strategy.

  • Create and manage SSIS packages, ETL packages, triggers, stored procedures, views, SQL transactions.

  • Develop new secure data feeds with external parties as well as internal applications including the data warehouse and business intelligence applications.

  • Maintain and enhance key Alameda Alliance systems including the Pre-Processor, Provider Not Found and Member Not Found interfaces.

  • Perform analysis and QA.

  • Lead SQL and SSIS programming initiatives.

  • Work to train key IT Staff on advanced SSIS, SQL, XML (x12) and EDI techniques and design patterns.

  • Diagnose ETL and database related issues, perform root cause analysis, and recommend corrective actions to management.

  • Work with a project team to support the design, development, implementation, monitoring, and maintenance of new ETL programs.

  • Complete other related duties and special projects as assigned by IT management.

WHAT EXPERIENCE WOULD WE LIKE TO SEE?

  • Minimum five years experience in ETL programming utilizing SSIS packages, DTS, stored procedures, Informatica, Pentaho and SQL scripts desired.

  • Minimum seven years demonstrated professional experience in IT development and support roles with at least 4 years of direct ETL experience.

  • At least 3 years of building EDI file sets including data extraction/consumption and data loading from/to EDI file sets.

  • Experience working with Healthcare-related EDI files (834, 835, 837, etc.)

 

Job Type: Full-time

 

Education & Experience:

Bachelor’s Degree in Computer Science.
Professional experience in a health care setting is highly desirable and a definite plus.

 

Certifications:​

  • ETL Certifications are a bonus.

  • Strong critical thinking and problem solving skills required.

Location:

  • Anywhere in United States

Work authorization:

  • United States (Required)

Dazzlon Computer Services, Inc., Phone: 469-333-7066, Fax: 469-716-4439