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