Vacancy expired!
- Gather business requirements and data realities
- Discriminate data modeling needs based on requirements and determine data modeling method
- Possess deep understanding of dimensional modelling methodology (Kimball, Inman)
- Understand and communicate data modelling process
- Organize data modelling workshops and guide data modeling process with business owners (and data architects and data engineers)
- Document conceptual, logical and physical data models with clearly defined grain, dimensions and facts
- Profile source system and create or reverse-engineer source data model
- Provide clear data specs and transformation logic for ETL developers
- Work with Data Engineers to implement physical data models
- Define data modelling standards and act as gatekeeper of enterprise data model, including but not limited to monitor data model integrity, setting up change management process, resolving data model conflicts and inconsistencies, etc.
- Validate and approve physical data models
- Create standards for creating and maintaining semantic layer
- Maintain data model integrity from source to Snowflake data platform, and from Snowflake to applications
- Act as data model domain expert to guide data model usage to and from Snowflake
- Bachelor's degree in computer science, information technology, or a similar field.
- Solid understanding of different data modeling frameworks and methodologies
- At least 3 years of working with relational databases
- At least 3 years of working with dimensional models
- At least 3 years of working with business owners and organizing efforts to define data models
- At least 3 years of documenting, visualizing, and communicating conceptual, logical to physical data models
- At least 3 years of working with both business and technical colleagues to get consensus on data models
- At least 3 years of hands-on experience in creating and implementing (physical) data models in data warehouse environment
- At least 2 years of experience maintaining enterprise-level data models
- At least 3 years of experience with data visualization tools
- Strong interpersonal skills.
- Experience with team management.
- Excellent communication and presentation skills.
- Advanced troubleshooting skills.
Vacancy expired!