Description

Job Schedule: Full Time
Standard Hours: 40
Job Shift: Shift 1
Shift Details:

Work where every moment matters.

Every day, almost 30,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut’s most comprehensive healthcare network.

The creation of the HHC System Support Office recognizes the work of a large and growing group of employees whose responsibilities are continually evolving so that we and our departments now work on behalf of the system as a whole, rather than a single member organization.
With the creation of our new umbrella organization we now have our own identity with a unique payroll, benefits, performance management system, service recognition programs and other common practices across the system.

 

ETL Developer/Analyst

 

SECTION 1: DESCRIPTION

This position reports to the Master Data Management team.  The person in this position will provide ETL and data base query support for the Master Data Management Team, as well as other teams in the Analytics department.  The person will work with providers and subscribers of data to maintain current ETL routines, and develop and document new ETL routines.

    

SECTION 2: POSITION SUMMARY

• Provides application and technical information system support.
• Analyzes, designs, builds, tests, trains and supports ETL routines to support the Master Data Management environment.
• Works with developers and analysts to convert business requirements into ETL routines
• Documents ETL routines as appropriate.
• Coaches data stewards and other consumers of data
• Works with analyst and developers to incorporate data quality checks into ETL routines
• Develops ETL in such a way as to be able to include in existing and new job streams
• "On Call" responsibilities as required, circulated among the team.

SECTION 3: KEY ACCOUNTABILITIES

• Builds and maintains assigned applications and interfaces.
• Guides the development and execution of test scripts and testing methodology.
• Develops and maintains relationships with developers and analysts.
• Provides customer response and updates according to current policies and procedures.
• Maintains the confidentiality of data.
• Participates actively in “How Hartford Healthcare Works” (H3W), Hartford Healthcare’s Quality Improvement program, and in LEAN
• Participates in project management as assigned.
• Performs other duties as assigned.

SECTION 4: DIMENSIONS

• Ability to lift 20 lbs.
• Gross motor function; both hand, both feet
• Fine motor function; both hands
• Ability to bend, squat, reach, lift, carry, push, pull

Qualifications

SECTION 5: QUALIFICATIONS (Education, Experience, Additional Skills & Requirements)

• Bachelor's degree in Computer Science or related field and four to six (4 – 6) years of related experience.
• Four years’ experience with querying SQL data bases
• Minimum two years’ experience in creating ETL routines
• Excellent analysis, debugging and troubleshooting skills, and problem solving required
• Development experience in Informatica Powercenter strongly preferred
• Knowledge of or experience with data quality tools like Informatica IDQ strongly preferred
• Strong with  Oracle, SQL
• Good knowledge of Unix
• Healthcare experience is preferred.
• Work experience may substitute for minimum education requirement.
• Due to sensitive security and financial responsibilities, must successfully pass Credit/Financial screenings.
• Working knowledge of general information technology policies and procedures.
• Ability to multi-task.
• Ability to operate various office machines including printers, computers and various software packages.
• Ability to problem-solve.
• Strong analytical skills.
• Project management skills.
• Conflict resolution skills.
• Presentation skills.
• Prioritization skills.
• Process improvement and quality skills.
• Interpersonal skills.
• Organizational skills.
• Ability to train others.
• Ability to work as part of a team.
• Knowledge of Microsoft Office products.
• Written and verbal communication skills.
• Ability to maintain confidentiality, exercise discretion and sound judgment.
• Must be willing to learn new technologies and techniques.
• Must be willing and able to come to work in adverse weather conditions.
• Travel to Hartford Healthcare sites within 50 miles of Hartford will be required occasionally.

 

SUPERVISORY / BUDGET RESPONSIBILITIES

• No fiscal responsibility.

 

ORGANIZATIONAL COMPETENCIES

• Attends all mandatory education and training programs (including department specific) and can describe his/her responsibilities related to general safety and regulatory compliance as well as department safety and specific job-related hazards.
• Follows the hospital exposure control plans/bloodborne and airborne pathogens.
• Attire is professional, neat, clean, and appropriate for the work environment, according to the HHC and/or Department Appearance Policy and a high standard of personal cleanliness is maintained.
• Reports to work on time and meets acceptable standard for attendance, based upon the department attendance policy.
• Communicates messages clearly and concisely

 

We take great care of careers.

With locations around the state, Hartford HealthCare offers exciting opportunities for career development and growth. Here, you are part of an organization on the cutting edge – helping to bring new technologies, breakthrough treatments and community education to countless men, women and children. We know that a thriving organization starts with thriving employees-- we provide a competitive benefits program designed to ensure work/life balance. Every moment matters. And this is your moment.