Data Modeler

D ata Modeler Hybrid Richmond, VA Long term contract Design enterprise data models (conceptual, logical, and physical) that enable trusted, reusable, and secure data across the organization. " Partners effectively with governance, engineering, architecture, analytics, security, and development teams. " Understands and proliferates modeling standards and patterns aligned to EDM, Data Governance, and industry practices. " Ensures data models support quality, lineage, privacy, and performance requirements. " Ensures models are implementable and optimize cost/performance in target platforms. " Ability to translate complex data concepts into clear business language; produce high-quality documentation and diagrams. " Keen Business Acumen: Quickly understands domain processes and how data supports decisions. " Critical/System Thinking: Able to see cross-domain dependencies and design for reuse and extensibility. " Has a keen attention to detail. " Intermediate/Advanced Microsoft Office Suite of Tools " Intermediate/Advanced Data Modeling Skills -- Conceptual, Logical, Physical; Relational (3NF), Dimensional (star/snowflake), Data Vault 2.0, wide tables for lake/ELT, and canonical models for integration. " Patterns & Techniques: Normalization/denormalization, SCD Type 1/2/3, surrogate keys, conformed dimensions, bridge/junk/helper tables, CDC handling, late/early arriving facts. " Metadata & Catalog: Business glossary, data dictionary, lineage; catalog tools integration. " Modeling Standards: Naming conventions, data types, constraints, keys, relationships, and versioning. " Reference & Master Data: Hierarchies, code sets, golden records; stewardship workflows. " Modeling Tools: Lucid Chart primary or ER/Studio/ERwin secondary " Databases (OLTP/OLAP): SQL Server, Oracle, PostgreSQL, Snowflake, Azure Synapse, BigQuery, Redshift. " Data Lake & Files: Parquet, ORC, Delta Lake; partitioning, Z-ordering, clustering. " Cloud & Integration: Azure (Synapse, Fabric, SQL DB, Data Factory, Purview) " BI/Semantic Layer: Power BI, semantic models, measures, and calculation groups (alignment to the logical model). " Profiling & Quality: DQ; profiling and rule authoring. " Security/Privacy: Row-/column-level security, dynamic masking, tokenization/encryption, privacy impact assessment alignment. " SQL (intermediate): Window functions, CTEs, query optimization, index strategies, execution plans. " Minimum 3-5 years of Data Modeling experience with enterprise scale systems " Minimum 1-2 years working in MS Azure environments and SQL databases (jSynapse, SQL DB, Data Lake) " Minimum 1-2 years of working with Power BI semantic modeling and KPI alignment " Minimum 3-5 years of working with SQL " Experience in banking, mortgage lending and rental housing preferred