Job Description
Returning Candidate?
Log back in!
IT Data Warehousing Programmer - ETL
Requisition #: 89899
Status: Full-Time with Full-Time Benefits (40 Hours)
Business Unit: Health Alliance Plan (HAP)
Shift: Days
Department: INFORMATION DELIVERY, MANAGED CARE TEAMS
Weekends: Yes
Job Family: Information Systems
Job Function: Information Technology
Campus/Job Location: Health Alliance Plan (HAP) Preferred
Location (State/City): US-MI-Southfield
More information about this position
Overview:
Henry Ford Health System, one of the largest and most comprehensive integrated U.S. health care systems, is a national leader in clinical care, research and education. The system includes the 1,100-member Henry Ford Medical Group, six hospitals, Health Alliance Plan (a health insurance and wellness company), Henry Ford Physician Network, a 150-site ambulatory network and many other health-related entities throughout southeast Michigan, providing a full continuum of care. In 2013, Henry Ford provided $314 million in uncompensated care. The health system also is a major economic driver in Michigan and employs more than 23,000 employees. Henry Ford is a 2011 Malcolm Baldrige National Quality Award recipient. The health system is led by CEO Nancy Schlichting. To learn more, visit HenryFord.com
Responsibilities
Under the general supervision of the Specialist or Senior Data Warehousing Programmer, the Project Manager, Manager or the Portfolio Director: responsible for production support, enhancement, and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate ETL/System programs and systems documentation. Assists with metadata repository management. Prepares and implements data verification and testing methods for the data warehouse. The responsibilities also include troubleshooting application issues and/or data issues when they arise. The Data Warehousing Programmer is member in an IT team that is accountable for production support (including on-call duties in a 24x7 environment) as well as new projects.
Qualifications:
Education and Experience:
Required:
* Bachelor's degree required, Master's degree preferred.
* 3 years of application programming and analysis with ETL tools
* 3 years of experience with IBM InfoSphere DataStage toolset version 7 or above (with at least 1 year of experience on version 8 or higher)
* 2 years of experience with Unix shell scripting
* 2 years of experience with Oracle database including SQL/ PL SQL, indexing, partitioning, views, materialized views, performance tuning and optimization
* 2 years of experience with analyzing and interpreting complex problems or processes that span multiple business areas, identify and understand requirements, and develop alternate solutions.
* 3 years of experience in data warehousing/data mart environments.
* 3 years of experience with Data Warehouse methodologies (like Bill Inmon or Ralph Kimball)
* 3 years of experience with implementing Star Schema or Snow Flake designs
* 2 years of experience/exposure to the System Development Life Cycle (SDLC), including Agile.
Preferred:
* 1 year applicable experience in the Healthcare / Health insurance domain, with good understanding of HIPAA data Privacy and Security requirements.
* 1 year of experience with IBM InfoSphere QualityStage, Information Analyzer, Business Glossary, Metadata Workbench
* 1 year of applicable experience with FACETS, IKA, PEGA
* 1 year of experience with Project Management (developing work plan timelines)
* Any experience defining development guidelines and standards
* 1 years of experience with evaluating options and making recommendations for potential solutions
Equal Employment Opportunity / Affirmative Action Employer
Henry Ford Health System is committed to the hiring, advancement and fair treatment of all individuals without regard to race, color, national origin, sex, sexual orientation, age, disability, religion, weight/height, marital status, familial status, veteran status or any other characteristic protected by law..
