Description

You design and implement modern data modeling solutions for relational, dimensional, and data lake environments.

This role is on-site.

Responsibilities

• Design and implement data modeling solutions using relational, dimensional, snowflake, star schemas, and data lake models.
• Collaborate with Application Development teams to build data strategies, data flows, and conceptual data models.
• Optimize and update data models to support data initiative projects throughout various implementation phases.
• Perform reverse engineering of physical data models and analyze variances across source systems.
• Evaluate system integration challenges and recommend appropriate solutions.

Required Skills

• 8+ years of experience in data modeling for databases like DB2, AWS Redshift, DynamoDB, Postgres, SQL Server, and PEGA Applications.
• 6+ years of experience with data modeling software.
• Proficiency in AWS and other cloud systems.
• Strong SQL and data profiling skills across various relational databases.
• Experience in building data lakes for structured and unstructured data.
• Expertise in relational data, dimensional data, unstructured data, and master data.
• Database tuning techniques.
• Ability to work independently with minimal supervision.

Key Skills

Education

Any Gradute