Cynosure Technologies LLC
Cynosure Technologies LLC

Data Modeler

Pittsburgh, PA, US • Posted 2 hours ago • Updated 2 hours ago
Contract Independent
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Agile
  • Analytical Skill
  • Analytics
  • Application Development
  • Cloud Computing
  • Data Architecture
  • Data Engineering
  • Data Governance
  • Data Integration
  • Data Management
  • Data Modeling
  • Data Quality
  • Data Structure
  • Data Warehouse
  • Dimensional Modeling
  • ELT
  • Enterprise Architecture
  • Extract, Transform, Load
  • Health Care
  • Life Sciences
  • Master Data Management
  • Meta-data Management
  • Microsoft
  • Microsoft Azure
  • Mobile Device Management
  • Modeling
  • Pharmaceutics
  • Privacy
  • RDBMS
  • Reference Data
  • SQL
  • Slowly Changing Dimensions
  • Snow Flake Schema
  • Warehouse

Summary

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.
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.
  • Dice Id: 10123013
  • Position Id: 9124989
  • Posted 2 hours ago
Contact the job poster
Viswanath Yerubandi

Viswanath Yerubandi

Cynosure Technologies LLC Recruiter @ Cynosure Technologies LLC

View Profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
More jobs at Cynosure Technologies LLC in Pittsburgh, PA