Description
You will design and implement scalable data models to support business requirements and data consistency.
Responsibilities
- Develop dimensional data models using star and snowflake schema designs.
- Create logical and physical data models using Erwin.
- Collaborate with developers, analysts, and stakeholders to gather requirements and communicate design changes.
- Develop and maintain SQL scripts to support model implementation and optimize queries for performance.
- Maintain data dictionaries and metadata to ensure consistency across systems.
- Document data model designs, implementation plans, and participate in design reviews.
Required Skills
- 5+ years of experience in data modeling.
- Expertise in Dimensional Data Modeling, including star and snowflake schemas.
- Proficiency with Erwin or similar data modeling tools.
- Advanced SQL development and maintenance skills.
- Ability to optimize SQL queries for performance and scalability.
- Experience designing both logical and physical data models.
- Proven ability to identify and resolve data quality issues.
- Any Graduate degree.