Posted on
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