EMR & Warehouse Analyst

All the benefits and perks you need for you and your family:

· Benefits from Day One

· Career Development

· Whole Person Wellbeing Resources

· Mental Health Resources and Support

Our promise to you:

Centrus Health

Centrus Health is a clinically integrated, physician-led network, including North Kansas City Hospital, Advent Health and The University of Kansas Health System, and independent primary care and specialist physicians including members of the Kansas City Metropolitan Physician Association (KCMPA). Centrus Health is a high-quality value-based network for government and commercial payers and employers since 2018.

Centrus Health began with a simple question: What if we could make health care better for the people of Kansas City? Today, we’re turning what-ifs into why-nots by placing more value on patient satisfaction, improved outcomes, and healthy living—all while lowering the cost of care. Our network represents a group of Kansas City’s leading providers joining together to transform our community’s health care.

Centrus Health at a Glance

1. 4,000 providers (and counting)

2. 400 physician/provider practices

3. Locations throughout the Kansas City Metropolitan area

4. 200,000 patients in value-based arrangements

Job Location: Greater Kansas City Metropolitan Area

Shift : Monday-Friday

Job Location : Hybrid- 2330 Shawnee Mission Pkwy, Suite 300 Westwood, KS 66205

The role you’ll contribute:

EMR & Warehouse Analyst works as a member of the Data Warehousing and Business Intelligence team.

Relies on experience and judgment to plan and accomplish goals. Performs additional tasks as

assigned. Provides direction and guidance to less experienced team members.

The value you’ll bring to the team:

• Responsible for the development, maintenance and support of data extraction (ETL) processes from source systems to targets.

• Translates business intelligence metrics into data mart business requirements.

• Identifies data sources, assists in the design of dimensional data models and designs/develops processes that ensure data accuracy.

• Develops code to summarize data and calculate metrics for executive dashboards and Business Intelligence (BI) applications.

• Troubleshoots, tunes and supports existing data warehouses and BI applications.

Qualifications

The expertise and experiences you’ll need to succeed:

• Proficiency in database design concepts and techniques for OLAP versus OLTP.

• Understanding of entity relationship diagrams and resulting physical database objects.

• Advanced database development knowledge including performance tuning in Oracle environments.

• Strong extraction, transformation and loading (ETL) skills using Informatica and PL/SQL.

• Strong analytical and problem solving skills with ability to clearly articulate solution alternatives.

KNOWLEDGE AND SKILLS PREFERRED:

• Performance tuning experience in SQL Server and/or Big Data environments.

• ETL experience in SQL Server Integration Services (SSIS).

EDUCATION AND EXPERIENCE REQUIRED :

· Bachelor’s Degree in Computer Science, Business, Engineering or similar.

This facility is an equal opportunity employer and complies with federal, state and local anti-discrimination laws, regulations and ordinances. The salary range reflects the anticipated base pay range for this position. Individual compensation is determined based on skills, experience and other relevant factors within this pay range. The minimums and maximums for each position may vary based on geographical location.

Category: Information Systems

Organization: AdventHealth PHSO Resources

Schedule: Full-time

Shift: 1 - Day

Req ID: 24015941

We are an equal opportunity employer and do not tolerate discrimination based on race, color, creed, religion, national origin, sex, marital status, age or disability/handicap with respect to recruitment, selection, placement, promotion, wages, benefits and other terms and conditions of employment.