IT Data Warehousing Programmer - Health Alliance Plan
EDUCATION/EXPERIENCE REQUIRED:
- Bachelor’s degree required/ Master’s degree preferred.
- Three (3) to five (5) years of relevant domain experience in Data Warehousing, Data Mart builds, and other Information Management related initiatives.
- Required to understand general data warehousing concepts such as Star Schema and Snow flake.
- Must be familiar with Data Warehouse methodologies like Bill Inmon and/or Ralph Kimball.
- Minimum two (2) years of experience with IBM® InfoSphere toolset version 8 or above using DataStage, Shell Scripting, Scheduling tool and SharePoint technologies.
- Minimum three (3) years of experience with Oracle database.
- Minimum three (3) years of experience working in both Windows and Unix environments.
- Experience with FACETS, IKA, and/or PEGA is preferred.
- Exposure to cloud technologies such as Azure Data Factory, Azure Databricks, Azure Synapse, Azure Function Apps and programming with Python, Scala in data engineering space preferred.
- Experience/exposure to various System Development Life Cycle (SDLC) methodologies (Waterfall, Agile, etc.)
- Knowledge on database concepts like indexing, partitioning, views, materialized views, performance tuning and optimization is preferred.
- Good understanding of HIPAA data Privacy and Security requirements preferred.
- Experience working in a Health Insurance environment is preferred.
Overview
HAP is a Michigan-based, nonprofit health plan that provides health coverage to individuals, Â Â Â Â Â companies and organizations. A subsidiary of Henry Ford Health System, we partner with doctors, employers and community groups to enhance the overall health and well-being of the lives we touch. With more than 1,100 dedicated and passionate employees, our goal is to make health care easy for our members.
Â
Under the leadership of President and CEO Robert G. Riney, Henry Ford Health is a
$6 billion integrated health system comprised of six hospitals, a health plan, and 250+ sites
including medical centers, walk-in and urgent care clinics, pharmacy, eye care facilities and
other healthcare retail. Established in 1915 by auto industry pioneer Henry Ford, the health system
now has 32,000 employees and remains home to the 1,900-member Henry Ford Medical Group, one
of the nation’s oldest physician groups. An additional 2,200 physicians are also affiliated with the
health system through the Henry Ford Physician Network. Henry Ford is also one of the region’s Â
major academic medical centers, receiving between $90-$100 million in annual research funding and
remaining Michigan’s fourth largest NIH-funded institution. Also an active participant in medical
education and training, the health system has trained nearly 40% of physicians currently practicing
in the state and also provides education and training for other health professionals including nurses,
pharmacists, radiology and respiratory technicians. visit HenryFord.com.
Benefits
Whether it's offering a new medical option, helping you make healthier lifestyle choices or
making the employee enrollment selection experience easier, it's all about choice. Â Henry
Ford Health System has a new approach for its employee benefits program - My Choice
Rewards. Â My Choice Rewards is a program as diverse as the people it serves. Â There are
dozens of options for all of our employees including compensation, benefits, work/life balance
and learning - options that enhance your career and add value to your personal life. Â As an
employee you are provided access to Retirement Programs, an Employee Assistance Program
(Henry Ford Enhanced), Tuition Reimbursement, Paid Time Off, Employee Health and Wellness
and access to day care services at Bright Horizons Midtown Detroit, and a whole host of other
benefits and services. Employee's classified as contingent status are not eligible for benefits
Equal Employment Opportunity/Affirmative Action Employer
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, creed, religion, age, sex, national origin, disability, veteran status, size, height,
weight, marital status, family status, gender identity, sexual orientation, and genetic information,
or any other protected status in accordance with applicable federal and state laws.