Data Modeler

Overview

On Site
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

PostgreSQL.
Amazon Redshift
SQL
ETL
Python
AWS

Job Details

Required Qualifications:
5+ years of experience in data modeling for enterprise-scale analytical environments.
Proven expertise in dimensional modeling, including Star Schema, Snowflake Schema, and slowly changing dimensions (SCDs).
Strong SQL development skills in Amazon Redshift and PostgreSQL.
Proficiency in Erwin Data Modeler or a similar enterprise data modeling tool.
Hands-on experience in data profiling, data lineage analysis, and source-to-target mapping.
Deep understanding of the differences between OLTP and OLAP systems and the transformation required to convert between them.
Familiarity with ETL design principles and data integration strategies.
Experience in Python for data transformation, scripting, or pipeline automation.
Exposure to AWS data ecosystem (e.g., Glue, S3, Redshift Spectrum).
Experience working in an Agile/Scrum team setting.
Understanding of data warehouse performance tuning and cost optimization in cloud environments.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.