Sr. ETL Developer

Sr. ETL Developer

16 Jun 2024
Tennessee, Franklin, 37064 Franklin USA

Sr. ETL Developer

Vacancy expired!



Job Number: 235415

Sr. ETL Developer

Sr. ETL Developer

Remote/partial onsite Nashville, TN

6 Month Contract to Hire (no visa sponsorship available)

Must have Healthcare domain experience

Description

: As a

Sr.

ETL Developer, you will be part of a team responsible for developing and maintaining ETL/ELT solutions for managing the data exchange via files and API between the company, its clients/vendors, and other entities. You will meet frequently with business owners, project managers, and business analysts to discuss requirements for implementing data flows and the business processes that will depend upon them.

Essential Job Functions:


  • Develop, maintain and support automated ETL jobs and batch processes to facilitate data exchange with clients, vendors, and business partners.

  • Develop data integration using APIs to integrate third-party solutions as needed.

  • Support automated ETL jobs in production, troubleshoot errors/failures, performance issues, and apply fixes as needed.

  • Participate in data interface specifications discussions with business units, clients, vendors and help devise a solution.

  • Communicate with client or vendor's technical teams to implement solutions, troubleshoot issues.

  • Document and maintain data mappings and specifications of data extracts/files being exchanged with different entities.

  • Perform analysis of data sources and processes to ensure data integrity, completeness, and accuracy

  • Participate in data warehouse initiatives with key business stakeholders by gathering and documenting key business definitions, measures, and standards

  • Identify and facilitate implementation of improvement opportunities

  • Facilitate requirements gathering from non-technical business personnel and suggest efficient reporting solutions based on requirements

  • Document data flows, ETL processes, logic as flowcharts/ process diagrams.

  • Work in an agile environment and provide regular updates on the progress of projects.

  • Perform other job-related duties as assigned


Qualifications


  • Bachelor's degree in Computer Science, Management Information Systems, Finance, Healthcare Administration or other related field

  • Advance level in TSQL development - SPs, functions, views etc.

  • Advance level in SSIS development

  • Advance level in designing ETL/ELT processes using SQL, SSIS, C# to implement automated inbound/outbound file-based data exchange.

  • Intermediate level proficiency in C#.Net or other programming language for developing code for API integration, implementing custom transformations in SSIS.

  • 8+ years of hands on experience with developing TSQL code on MS SQL Server

  • 8+ years of hands on experience with SSIS (SQL Server Integration Services)

  • 4+ years of experience in the healthcare industry preferred with expertise in healthcare medical and pharmacy claims, membership, authorization, admissions/discharges, provider data, CMS data - MMR , MOR , RAPS.

  • 3+ years of hands on experience with ascii X12, HL7, XML preferred.



THIRD PARTY AGENCIES, SUBCONTRACTORS, AND RECRUITERS NEED NOT APPLY. Applicants received from firms will not be considered. Subcontracting is not available for this position.

Job Details

  • ID
    JC15513862
  • State
  • City
  • Job type
    Contract
  • Salary
    N/A
  • Hiring Company
    Softworld, Inc.
  • Date
    2021-06-16
  • Deadline
    2021-08-15
  • Category

Jocancy Online Job Portal by jobSearchi.