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.
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.
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.
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.
At AdventHealth, Extending the Healing Ministry of Christ is our mission. It calls us to be His hands and feet in helping people feel whole. Our story is one of hope — one that strives to heal and restore the body, mind and spirit. Our more than 80,000 skilled and compassionate caregivers in hospitals, physician practices, outpatient clinics, urgent care centers, skilled nursing facilities, home health agencies and hospice centers are committed to providing individualized, wholistic care.