Core Responsibilities:
Review current state data models (e.g. used by S3 files) & data sources to understand the as-is environment
Review data consumption requirements & use cases to understand where data model structures can address requirements
Work with key business representatives, data owners, end users, application designers and data architect to model the current data for the to-be system
Create logical and physical data models for as is and proposed or to be system
Create entity-relationship diagrams for relational systems and dimensional diagrams for consumption layer
Review, update and validate data model with key business representatives and end users
Work with the data architect and database administrator to understand current data storage constraints and define to be needs with growth allocation
Work with data architect to define and capture required metadata
Maintain data models continuously as modifications and enhancements are made
Create data model structures to enhance performance of the application by creating aggregation and summarization structures.
Cooperating with various application teams across businesses to understand the data architecture needs and provide solutions
Data modeling, data warehousing, dimensional modeling, data modeling for big data and metadata management.
Data Lake and Big Data modeling experience.
Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read, irregular dimensions, and surrogate, compound and intelligent keys.
Ability to present design of the solution to various stakeholders.
Collaborating and participating in discussions with business analysts, technical architects and technical leads to develop data models and data architecture flows
Facilitating and conduct design reviews internally and to other teams to present data strategy and the vision for data architecture