Data Warehousing Analyst Intermediate
at Adventist Health System

Date Posted: 5/4/2017

Job Description

Job:  Information Technology

Organization:  Adventist IT

Shift:  Day

Job Posting:  May 3, 2017, 1:08:32 PM


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.


• 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.

Job Requirements


• 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.

• Exceptional interpersonal skills and a team player.

• Excellent written and verbal communication skills.


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

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


• Master’s Degree in Computer Science or 6-year professional development experience in data warehouse.


• Fluency with best practices for ETL design and development such as data profiling, data cleansing, change data capture, and performance optimization.

• Ability to evaluate and implement solutions balancing reuse, extensibility, reliability and performance.

• Flexible, open to suggestions, and eager to learn or share knowledge.

• Orientation toward self-motivation, organization and attention to detail.

Job Snapshot

About Us

About Adventist Health System

Who We Are

We are one of the largest faith-based health care providers in the United States. For 150 years, we have carried on a tradition of providing whole-person care that not only addresses patients' physical ailments, but also supports their emotional and spiritual well-being. We demonstrate the same level of compassion and care for our employees as well, doing all that we can to help them realize their full potential – both personally and professionally.

Who You Are

You are a compassionate, talented professional who wants to work in an environment where you can live out your faith and your values. You are excited about being part of a team that uses the latest technology and medical research to ensure patients receive quality care, but who also recognize that great care is always personal. You enjoy going out of your way to make each patient and their family feel special, and are passionate about guiding them toward optimal health.

Our Community

Our community is global and so is our reach. From coordinating medical mission trips in Ethiopia to planting school gardens in Florida, we are constantly seeking ways to go beyond hospital walls in improving the health of our communities. As a member of our team, you will be encouraged to use your talents in fun, meaningful ways that bring joy and healing to people around the world.

Our Mission

Part of this worldwide network, Adventist Health System was founded in 1973 to support and strengthen the Seventh-day Adventist health care organizations in the Southern and Southwestern regions of the United States. Today it is a national leader in quality, safety and patient satisfaction, comprised of 46 hospital campuses and nearly 77,000 employees.

Although separated by geography, each of our facilities is united by the mission of Extending the Healing Ministry of Christ. Today we continue the tradition of whole-person care by practicing and sharing CREATION Health, a blueprint for living a healthy, happy life based on the principles given in the Bible’s creation story: Choice, Rest, Environment, Activity, Trust, Interpersonal relationships, Outlook and Nutrition.

We provide comprehensive benefits, training and advancement opportunities. We care for our employees as well as we care for our patients.