Children's Healthcare Of Atlanta - Brookhaven, GA
posted about 2 months ago
Full-time
Brookhaven, GA
Ambulatory Health Care Services
About the position
The Data Warehouse Engineer is responsible for defining, documenting, and building the technical architecture of the data warehouse, data marts, and operational data stores. This role involves creating scripts for data extraction, transformation, and loading, ensuring that data is clean and accessible for analysis. The engineer will work closely with various teams to support data management and business intelligence initiatives, contributing to the overall mission of Children's Healthcare of Atlanta.
Responsibilities
- Defines and documents the technical architecture of the data warehouse, data marts, and operational data stores.
- Creates scripts required to extract, transform, clean, and move data and metadata for loading into data systems.
- Demonstrates data modeling skills, including denormalization, normalization, and star schema.
- Provides performance tuning and query tuning capabilities for data processes.
- Develops master and metadata management capabilities.
- Creates a multidimensional semantic layer and business intelligence query objects for end users.
Requirements
- Bachelor's degree in a related field and 5 years of experience in database or data warehousing technologies, or a Master's degree and 1 year of experience.
- Experience in SQL and/or Oracle database platforms.
- Experience in common ETL tools such as Talend, Informatica, or SSIS.
- Strong organizational, written communication, and analytical skills.
- Interpersonal skills to interact positively with teams across organizational lines.
