Other

Data Modeler

Cynosure Technologies LLCPittsburgh, PA🇺🇸United StatesPosted Oct 26, 2026

Quick overview

SeniorityMid Senior

Work modeOn Site

LocationPittsburgh, PA, United States

Posted18 hours ago

OracleSQLAWSETLSnowflakeBigQueryData PrivacyDatabricksGoogle CloudSAPAzurePostgreSQLSQL ServerAgile

Job description

Title : Data Modeler

location : Pittsburgh PA (Onsite Job)

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

Hands-on experience with one or more enterprise data-modeling tools such as:
ER/Studio
ERwin Data Modeler
SAP PowerDesigner
Visio
Lucidchart
Or equivalent enterprise modeling platforms
Cloud & Technology Experience
Experience with one or more modern data platforms is preferred, including:
Snowflake
Databricks
Microsoft Azure / Azure Synapse
AWS data services
Google Cloud Platform / BigQuery
SQL Server
Oracle
PostgreSQL or other enterprise relational databases
Exposure to modern architectures such as data lakehouse, data mesh, domain-oriented data architecture, and cloud-native analytics platforms is an advantage.
Preferred Qualifications
Experience supporting large-scale enterprise data-transformation or modernization programs.
Experience modeling data across multiple business domains and source systems.
Experience working in complex environments involving both operational and analytical data.
Knowledge of data cataloging and governance platforms such as Collibra, Alation, Microsoft Purview, or equivalent tools.
Understanding of data privacy, security, retention, and regulatory requirements.
Experience working in Healthcare, Life Sciences, Pharmaceutical, or other regulated industries is preferred.
Familiarity with Agile delivery methodologies and enterprise architecture frameworks.