ETL Engineer - Extract, Transform, Load

If you are interested in multiple opportunities, you will need to apply for each position separately.

Apply Now

916957

Vidant Health

Full Time

Regular

Summary

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.  Vidant Health has been recognized as one of the 100 Most Wired healthcare organizations by Hospitals and Health Networks magazine. 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 1 recognition and is also approaching Stage 7 for HIMSS Analytics’ Electronic Medical Records Adoption Model (EMRAM) recognition.

Responsibilities

The Extract, Transform, Load (ETL) Engineer’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 ETL 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.

  • Strategy & Planning
    • Orchestrate integration projects and corresponding strategies between business units, data stewards, and development teams.
    • Plan, execute, and manage the strategic integration of new data and data stores into existing systems and infrastructure throughout the enterprise, including introduction of Cloud services as applicable.
    • Ensure that integration projects meet business requirements and goals, fulfill end-user requirements, and identify and resolve systems issues.
    • Ensure that integration planning and practices are aligned with strategic business goals and the company’s overall strategic vision.
  •  Acquisition & Deployment
    • Conduct research on emerging ETL products, languages, and standards in support of procurement, development, security, and integration efforts in relation to the Cloud, BI, and big data management.
    • Manage the selection, deployment, and maintenance of any ETL tools, be they ETL as-a-service (ETLaaS) or ETL On-premise, deemed appropriate for the organization.
    • Collaborate with analysts, data stewards, developers, and system owners in the testing of newly-incorporated databases and integration measures.
    • Lead testing phase of ETL development in order to identify and remedy potential problem areas.
  • Operational Management
    • Ensure the collection and coherent interpretation of the various business processes affected by integration efforts.
    • Work diligently to enhance or improve business processes via integration, or, as necessary, minimize the impact of integration on those processes.
    • Evaluate results of integration projects, then report and make recommendations based on findings.
    • Frequently compare ETL solutions with those available in the market to assess and monitor levels of service provided by current vendors.
    • Where applicable, investigate and qualify potential integration solutions in the Cloud, On-Premise, or in a Hybrid arrangement to better allocate resources.

Minimum Requirements

  • Four-year college diploma or university degree in computer science or computer engineering, and/or equivalent work experience.
  • 3+ years experience in an ETL administration or ETL/application development environment
  • Epic Clarity certification preferred
  • Proven experience in overseeing the linking of cross-functional databases between disparate business units and systems.
  • Experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.
  • Advanced knowledge of one or more of the following areas of experience:  ETL principles, Epic Clarity console, Epic Compass, Epic Clarity execution management, Epic Clarity data structures, Epic Cogito, Epic Universes, Epic Cubes, Epic Registries, SQL Server Integration Services
  • Previous exposure to Cloud ETL and management.
  • Strong background in risk management methodologies as they relate to integration and Cloud computing.
  • Direct, hands-on experience with automated ETL tools.
  • Knowledge of relational database design and management techniques.
  • Good project management skills and/or substantial exposure to project-based work structures, project lifecycle models, etc.
  • Strong knowledge of system and software quality assurance best practices and methodologies.

Other Information

  • Occasional evening and weekend work to meet deadlines.
  • Lifting and transporting of moderately heavy objects, such as computers.
  • Physically able to participate in sessions, presentations, and meetings.
  • Some travel may be required for the purpose of offsite software and system integration efforts.

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 This: