100% Remote Contract Role of Data Modeler

Life in Pittsburgh; Pittsburgh (Allegheny County); Remote; USD 120,000 - 180,000; Full time

Job summary

Pittsburgh Tomorrow is seeking a highly experienced Data Modeler for a 12+ month contract. This remote role requires deep expertise in relational and dimensional data modeling, data warehousing concepts, and ETL/ELT processes.

You will design enterprise data structures that support analytics and reporting across large-scale systems. The candidate should have hands-on experience with modern cloud data platforms, metadata management, data lineage, and MD M.

Qualifications

• 12+ years in data management, architecture, warehousing or related disciplines with hands-on data-modeling
• Proven experience developing conceptual, logical and physical data models
• Strong knowledge of relational and dimensional data modeling concepts
• Experience with data governance, metadata, and lineage practices
• Ability to translate complex business requirements into enterprise data structures

Skills

Relational Modeling

Dimensional Modeling

Star/Snowflake Schemas

Normalization/Denormalization

ER Modeling

Data Warehousing

SQL

Cloud Data Platforms

ETL/ELT

Metadata Management

Data Lineage

MDM & Reference Data

Data Governance

Enterprise Data Architecture

Data Modeling Tools

Snowflake/BigQuery/AWS/Azure

Tools

SQL Server

Snowflake

ER/Studio

Informatica

PowerDesigner

Job description

Position: Data Modeler

Location: 100% remote(Pittsburgh, PA)

Duration: 12+ Months Contract W2/1099 Only

Experience - 12+ years Required

Required Skills & Experience

• 12+ years of experience in data management, data architecture, data warehousing, or related disciplines, with significant hands-on data-modeling experience.
• 7+ years of strong experience developing conceptual, logical, and physical data models.

Deep understanding of:

• Relational data modeling
• Dimensional modeling
• Star and snowflake schemas
• Normalization and denormalization
• Entity-relationship modeling
• Data warehousing concepts
• Strong understanding of facts, dimensions, hierarchies, grain, surrogate keys, business keys, and Slowly Changing Dimensions.
• Strong experience defining entities, attributes, relationships, cardinality, primary/foreign keys, and referential-integrity rules.
• Experience translating complex business requirements into enterprise data structures and models.
• Strong knowledge of SQL and relational database concepts.
• Experience with modern cloud data platforms, data lakes, data warehouses, or lakehouse architectures.
• Understanding of ETL/ELT processes and data-integration patterns.
• Experience with metadata management, data lineage, data dictionaries, and business glossaries.
• Good understanding of Master Data Management (MDM), reference data, data quality, and data governance.
• Experience working with enterprise architecture, Data Engineering, analytics, and application-development teams.
• Data Modeling Tools