Description

You will design and implement data models across various enterprise systems.

Responsibilities

• Build logical data models and translate them into physical databases.
• Analyze source databases, data, and referential integrity to profile data.
• Apply data modeling techniques suitable for data warehousing and analytical structures.
• Compare actual project procedures against specified standards and procedures.
• Collaborate with internal and external groups, including vendors, on data initiatives.

Required Skills

• 8+ years of experience in Data Modeling for databases including DB2, AWS’ Redshift, Dynamo DB, Postgres, SQL Server, and Pega Application.
• 6 years of experience with data modeling software.
• 8 years of experience analyzing source databases, source data, and profiling source data.
• AWS and other cloud systems experience is mandatory.
• Strong SQL and data profiling skills across various relational databases.
• Minimum 4 years of experience with database tuning techniques.
• 2 years of experience building Data Lakes for structured and unstructured data.
• Understanding of relational, dimensional, unstructured, and master data concepts.

Key Skills

Education

Bachelor's degree