IT Data Warehousing Programmer - Cognos - Health Alliance Plan - Troy
GENERAL SUMMARY:
Under the general supervision of the Specialist or Senior Data Warehousing Programmer, the Project Manager, Manager or the Portfolio Director: responsible for development, enhancement, production support and maintenance of the data warehouse. Responsible for job design for simple and medium complexity requirements and development of any high complexity jobs under Leads supervision. Responsible for creating and updating of all Project related artifacts which includes high level design and low level design documents, coding the job as per the standards, developing unit test script as well as integration test script documents and Run book creation for scheduling.
The responsibilities also include troubleshooting application issues and/or data issues when they arise. The Data Warehousing Programmer may be accountable for production support (including on-call duties in a 24x7 environment) as well as new projects.
PRINCIPAL DUTIES AND RESPONSIBILITIES:
- Participates in requirements definition sessions to gain a general perspective on the business objective(s) or business problem that is to be addressed by the system.
- Works with Business Analysts to gain an understanding of functional requirements.
- Works with Business Analysts to develop design documents.
- Design and develop prototype and work with the senior personnel to fine tune the data warehouse and make recommendations, including DB and ETL job tuning.
- Participates in code/design reviews to verify that quality standards and functional/technical requirements are met.
- Design, code, test and implement moderately complex programs; Develops appropriate programs and systems documentation according to established IT standards.
- Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in the system design.
- Assists in analyzing testing results throughout the project.
- Under the supervision of senior staff, supports production systems by helping resolve problems, providing timely follow-up on problem report, and optimizing performance and streamlining processes.
- Participates in technical reviews and inspections to verify 'intent of change' is carried out through the entire project.
- Provides support, escalation response to production issues/errors. Performs root cause analysis and application resolution.
- Provides on call second-level escalation response for client issues and application problem tickets
- Ensures proper documentation and on-time delivery of all technical artifacts and deliverables.
- Initiates a personal training plan, continue acquiring skills and knowledge, and pursue an understanding of the organization’s business plans and strategies.
EDUCATION/EXPERIENCE REQUIRED:
- Bachelor’s degree required / Master’s degree preferred.
- Required to understand general data warehousing concepts such as Star Schema, Snow flake;
- Must be familiar with Data Warehouse methodologies like Bill Inmon and/or Ralph Kimball;
- Minimum three (3) years with Cognos Report Studio
- Minimum three (3) years with query language such as SQL and/or PL/SQL.
- Experience with Cognos power cubes and/or dynamic cubes is preferred Experience with Framework Manager models is preferred
- Experience with FACETS, IKA, and/or PEGA is 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
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,200-member Henry Ford Medical Group, five 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 2015, Henry Ford provided $299 million in uncompensated care.
The health system also is a major economic driver in Michigan and employs more than 24,600
employees. Henry Ford is a 2011Malcolm Baldrige National Quality Award recipient. The
health system is led by President and CEO Wright Lassiter III. To learn more, 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.
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.