Primary City/State:
Phoenix, Arizona

Department Name:
IT Bus Apps Insurance Division

Work Shift:
Day

Job Category:
Information Technology

Primary Location Salary Range:

In accordance with Colorado's EPEWA Equal Pay Transparency Rules.

Health care is constantly changing, and at Banner Health, we are at the front of that change. We are leading health care to make the experience the best it can be. We want to change the lives of those in our care - and the people who choose to take on this challenge. If changing health care for the better sounds like something you want to be part of, we want to hear from you.

Your pay and benefits (Total Rewards) are important components of your Journey at Banner Health. Banner Health offers a variety of benefit plans to help you and your family. We provide health and financial security options, so you can focus on being the best at what you do and enjoying your life.

Within Banner Health Corporate, you will have the opportunity to apply your unique experience and expertise in support of a nationally-recognized healthcare leader. We offer stimulating and rewarding careers in a wide array of disciplines. Whether your background is in Human Resources, Finance, Information Technology, Legal, Managed Care Programs or Public Relations, you'll find many options for contributing to our award-winning patient care.

POSITION SUMMARY
This position provides expertise and leadership in the design, integration and maintenance of a system wide enterprise technical environment. Leads a team in the data design, direction and coordination of the hardware and software system configurations. Provides advanced knowledge, guidance, research and fact-finding expertise to resolve multipart system problems and issues ensuring solution is timely and of acceptable quality.

CORE FUNCTIONS
1. Serves as a lead in the analysis of business requirements associated with the design and implementation of highly complex, highly scalable enterprise data processes. Designs and develops robust and efficient processes for extracting, loading and transforming data to meet the needs of enterprise scale projects.

2. Provides guidance and participates in activities involved in the analysis, design, development, troubleshooting, debugging and maintenance of an enterprise data management and data ecosystem.

3. Identifies, investigates, tracks, and resolves the most complex technical errors ensuring the solution is timely and of acceptable quality.

4. Establishes and enforces database standards, guidelines, procedures and quality assurance for database deliverables such as conceptual design, logical data model capacity planning, external data interface specs, data loading, data maintenance plan and security.

5. Reviews and analyzes data objects and models to improve data management and data access.

6. Designs, constructs, tests and implements extraction and transformation programs, processes and cycles for historical and current source data.

7. Creates technical specification for supporting enterprise data transformation processes and supplementing system documentation for ETL processes.

8. Performs data profiling, source-target mappings, data transformation development, optimization, testing and implementation. Identifies required tasks and accurately determines needed resources and timeframes to ensure delivery of business needs.

9. This position participates and serves as a lead in maintaining the ETL environment for the company's system-wide enterprise data warehouse. Work is performed in a fast paced multi-tasked environment where there may be conflicting priorities or tight deadlines. The incumbent has mid level decision-making authority and works at peer level with management across diverse areas and multiple states. The incumbent participates in meetings, presentations, visioning sessions, strategic and planning sessions, implementation activities, and supports functions system wide.

Performs all functions according to established policies, procedures, regulatory and accreditation requirements, as well as applicable professional standards. Provides all customers of Banner Health with an excellent service experience by consistently demonstrating our core and leader behaviors each and every day.

NOTE: The core functions are intended to describe the general content of and requirements of this position and are not intended to be an exhaustive statement of duties. Specific tasks or responsibilities will be documented as outlined by the incumbent's immediate manager.

Banner Health Leadership will strive to uphold the mission, values, and purpose of the organization. They will serve as role models for staff and act in a people-centered, service excellence-focused, and results-oriented manner.

MINIMUM QUALIFICATIONS

Equivalent to a Bachelor's Degree in a related field or equivalent combination of relevant education, technical, business and healthcare experience and a minimum of eight years increasingly responsible ETL work.

Expert knowledge of data warehouse concepts, dimensional data modeling and complex interdependent SQL processes. Advanced knowledge and skills in ETL concept, design and development using data integration tools. Experience working in a large data warehouse environment with complex data models. Strong problem solving and data analysis skills. Skilled in managing multiple projects simultaneously. Experience in large scale project planning and reporting either individual or team. Requires communication and presentation skills to engage technical and non-technical audiences. Requires ability to communicate and interact across facilities and at various levels. Incumbent will have skills to mentor less experienced team members. As is typical in this industry, variable shifts and hours and carrying/responding to a pager may be required.

PREFERRED QUALIFICATIONS

Additional related education and/or experience preferred.