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.
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.
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.
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
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
Familiarity with the data vault methodology.
Additional Salary Information: Commensurate with experience
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.
Vidant provides paid time off and a comprehensive ben...efits package including but not limited to medical, dental, life and disability insurance and a 401(k) retirement plan. Benefits begin the first day of employment.
We are located in Greenville, NC which is located in the heart of North Carolina’s coastal plain, just a short drive from the famous Outer Banks beaches, the Blue Ridge Mountains and the attractions in the Triangle area (Raleigh, Durham and Chapel Hill). Greenville is home to East Carolina University, an integral part of North Carolina’s excellent university system. Greenville offers the best of urban amenities and a friendly environment.