Description

Work with business SME s to understand analytical and reporting requirements
Translate business and reporting needs into conceptual, logical, and physical data models
Define data standards, relationships, and data pipeline transformation requirements for data engineering implementation
Design and implement and Redshift data models, including tables, views/materialized view to ensure optimal performance and scalability
Transformation of business requirements into optimal data model
Dimensional modeling (Star and Snowflake schemas)
Design and document conceptual, logical, and physical models for analytical use cases in AWS Redshift
AWS Redshift performance optimization
AWS Glue, Redshift, Step Functions for data architecture
AWS DataZone for data lineage and governance

Key Skills

Education

Bachelor's degree