ETL Data Developer - Greenville, NC

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

Apply Now

929297

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 8 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 Developer position is responsible for the integration of enterprise data by developing, testing and implementing packages and programs using Microsoft’s SSIS and/or Informatica’s Power Center.  In addition, this position is responsible for building, maintaining reference tables, master data domains and data extracts that are needed to ensure the efficient and accurate processing of information within Vidant Health.

Typical tasks will include, but are not limited to: requirements gathering, analysis, software architecture and design, software development, testing, implementation and documentation.

Responsibilities

  • Analyzes, designs, build, test, and implement integration technology solutions that meet the specifications of a project or service request.

  • Effectively utilizes standard enterprise tools to develop or implement technical solutions.

  • Writes test cases and report results

  • Identifies problems following problem management expectations and performs problem resolution.

  • Resolve most reported issues independently or escalates as needed to senior engineers.

  • Provides preventative maintenance, troubleshooting and quickly resolves routine problems to ensure infrastructure and application stability.

  • Adheres to standards and best practices, processes, and deliverables in accordance with standards.

  • Participates in defining operational readiness requirements.

  • Follows testing best practices and standards.

  • Adheres to SLA expectations.

  • Writes technical specifications for respective applications or infrastructure platforms.

  • Participates in creating prototypes or proofs of concepts for new infrastructure technology.

  • Remains current with respective technology capabilities

  • Collaborates with Project Managers to resolve requirements gaps uncovered in design or within specifications or requirements.

  • Prepares technical documentation for platform, service or infrastructure technical components.

  • Adheres to change and incident management standards and expectations.

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

Preferred Requirements

  • SQL Server development – T-SQL/stored procedures

  • Microsoft SSIS or Informatica Power Center ETL programming

  • 2+ years in Healthcare

  • Epic Caboodle 1+ years

  • SME on 2 or more Epic data Clarity modelsSAS administration or development experience

  • Hands on experience with the Epic Clarity supplied cubes, Excel spreadsheets, or Business Objects universes

  • Epic Clarity or Epic Data warehouse certification

Experience not required but a plus

  • Informatica Power Center

  • Informatica Analyst and or IDQ

  • Oracle SQL, PL/SQL

  • Data modeling

  • ER/Studio

  • Familiarity with the data vault methodology

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: