Sign upLog in
Data Modeler Jobs in Virginia

Data Modeler

PlanIT Group LLC

  • Richmond, VA
  • 6 days ago

    Highlights

    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.

    Numbers & Facts

    LocationRichmond, VA

    Description

    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

    Similar Jobs