100% Remote Contract Role of Data Modeler

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