Join our Talent Network
Skip to main content

ETL Data Developer II - Greenville, NC

Job ID: 945717
Facility: Vidant Health
Location: Greenville, NC
FT/PT: Full-Time
Reg/Temp: Regular
Date Posted: Jun 3, 2021

Save Job Job Saved

Job Description

Vidant Health

About Vidant Health

Vidant Health, located in eastern North Carolina, is a comprehensive health system that is made up of 9 hospitals that serve 1.4 million people in 29 counties. Vidant Health includes Vidant Medical Center, community hospitals, physician practices and partners that collaborate with Vidant Health to enhance the quality of life of our patients.

Information Services at Vidant Health

Vidant Health offers comprehensive Information Technology (IT) services and infrastructure to support and enable all aspects of organizational operations. Our IT division consists of a state-of-the-art data center located in Greenville, NC. The data center services all information technology needs of Vidant Health facilities. All Vidant Health owned or leased hospitals are on a common IT platform, including our electronic health record (EHR) that uses Epic's suite of applications. Vidant Health has achieved Meaningful Use Stage 2 recognition and is also approaching Stage 7 for HIMSS Analytics’ Electronic Medical Records Adoption Model (EMRAM) recognition.

Position Summary

The ETL Data Developer's role is to plan, coordinate, and supervise all activities related to the integration of data across various sources into an organized and unified view. This individual is also responsible for the monitoring of data flow between databases, servers and Cloud services to identify and implement the most suitable Data Integration architecture for the organization’s needs. Proven communication skills, problem-solving skills, and knowledge of integration best practices are critical to successful performance in this role.

Recommend, design and lead the implementation of new ETL processes that add new data or improve existing processes to reduce latency and reduce cost.

Key Activities

  • Monitor and own the success of all daily ETL processing across Vidant Health.

  • Leads highly complex ETL projects and efforts.

  • Develop understanding of all of the source file formats ingested and target data stores.

  • Work with internal teams to create the documentation of ETL processes.

  • Become familiar with the healthcare business model, and the corresponding workflows in the organization and EPIC.

  • You'll participate in full project lifecycle to understand business requirements and then complete the design, development, testing, implementation and post-production support of data engineering solutions

  • Provides support and troubleshooting for all (e.g SSIS, Informatica) systems and technologies.

  • Recommend, design and lead the implementation of new ETL processes that add new data or improve existing processes to reduce latency and reduce cost.

  • Provide mentoring for less skilled team mates.

  • This position is required to rotate on-call responsibilities.


  • Design, document, and implement new ETL enhancements and modify existing code. Work independently to develop, configure, and unit test programs from specs (source to target mappings)

  • Work closely with data architects, reporting team, and application team on ETL development efforts including analysis and design of integration solutions and enhancements. Must be able to explain and support decisions and actions taken

  • Understanding the clients/customers' requirements. Deliberating different viable options for implementing technical solutions to the customer's requirements

  • Develop and document the functional details of the procedures work within the data quality applications

  • Use Informatica Data Quality to profile the project source data, define or confirm the definition of the metadata, cleanse and validate the project data, check for duplicate or redundant records

  • Build IT Controls to protect the processed data or output in accordance with confidentiality, integrity, as well as the availability of the application

Minimum Requirements

  • Bachelor's degree in Information Technology or related field OR relevant work experience required.

  • 4+ years' experience in an ETL administration or ETL/application development environment Experience working with project teams to design and implement new solutions.

  • Experience working in team-oriented, collaborative environment.

  • Independently motivated to seek knowledge in areas pertaining to their current position Exhibits proficient in either SSIS or Informatica ETL tools.

  • 1+ years applicable experience in the Healthcare / Health domain, with good understanding of HIPAA data Privacy and Security requirements.

  • Self-educates and seeks knowledge from mentors / management of VH Information Services, and other business leaders from VH.

  • 2+ years of working with dimensional modeled data Knowledge of data vault modeling techniques.

  • Expert level knowledge in writing SQL code for queries, stored procedures, data cleansing and manipulation.

General Statement

It is the goal of Vidant Health and its entities to employ the most qualified individual who best matches the requirements for the vacant position.

Offers of employment are subject to successful completion of all pre-employment screenings, which may include an occupational health screening, criminal record check, education, reference, and licensure verification.

We value diversity and are proud to be an equal opportunity employer.   Decisions of employment are made based on business needs, job requirements and applicant’s qualifications without regard to race, color, religion, gender, national origin, disability status, protected veteran status, genetic information and testing, family and medical leave, sexual orientation, gender identity or expression or any other status protected by law. We prohibit retaliation against individuals who bring forth any complaint, orally or in writing, to the employer, or against any individuals who assist or participate in the investigation of any complaint.

Share: mail

Similar Jobs

RN - Children's Operational Leader

Greenville, NC, United States

Support Partner NEO-IV-NICU

Greenville, NC, United States

Cook I

Greenville, NC, United States