Job Information

AdventHealth Data Warehouse Analyst -Sr in Altamonte Springs, Florida

Description

Data Warehouse Analyst - Senior

AdventHealth Information Technology

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

  • Benefits from Day One

  • Paid Days Off from Day One

  • Student Loan Repayment Program

  • Career Development

  • Whole Person Wellbeing Resources

  • Mental Health Resources and Support

Our promise to you:

Joining AdventHealth is about being part of something bigger. It’s about belonging to a community that believes in the wholeness of each person, and serves to uplift others in body, mind and spirit. AdventHealth is a place where you can thrive professionally, and grow spiritually, by Extending the Healing Ministry of Christ. Where you will be valued for who you are and the unique experiences you bring to our purpose-minded team. All while understanding that together we are even better.

Schedule: Full Time

You Will Be Responsible For:

  • 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

KNOWLEDGE AND SKILLS REQUIRED :

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

  • Ability to demonstrate mentorship and provide guidance to peers.

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 :

  • Master’s Degree in Computer Science or related field, or Bachelor’s Degree in Computer Science or related filed with 5 years’ experience

  • Foreign equivalent is acceptable in lieu of a US degree.

Summary:

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.

This facility is an equal opportunity employer and complies with federal, state and local anti-discrimination laws, regulations and ordinances.

Category: Information Systems

Organization: AdventHealth Information Technology

Schedule: 1 - Day

Shift: AdventHealth Information Tech

Req ID: 21038029

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.