Data Modeler

PlanIT Group

Richmond, VA

JOB DETAILS
SKILLS
Architectural Analysis, Banking Services, Business Intelligence, Business Skills, Centers for Disease Control and Prevention (CDC), Cloud Computing, Cost Control, Cryptography, Data Lake, Data Modeling, Data Processing, Detail Oriented, Embarcadero ER/Studio, Information/Data Security (InfoSec), Metadata, Microsoft Office, Microsoft SQL Server, Microsoft Windows Azure, Mortgage Lending, OLAP (OnLine Analytical Processing), Oracle Database, Performance Metrics, Performance Tuning/Optimization, PostgreSQL, Power BI, Privacy Controls, Privacy Impact Assessment (PIA), Property Rentals, Query Optimization, SQL (Structured Query Language), SQL Databases, Snowflake Schema, Star Schema, Stewardship, Strategic Planning, Transaction Processing/Management, erwin Data Modeler
LOCATION
Richmond, VA
POSTED
3 days ago
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

About the Company

P

PlanIT Group

PLANIT Group is a fast-growing global technology consulting firm dedicated to delivering innovative solutions to our clients that drive results. We collaborate with our partners and customers to help them improve performance, efficiency, and quality. Our team delivers innovative solutions and services - including management consulting, systems integration, ERP solutions, enterprise architecture, communications, and infrastructure services. We focus on delivering value and driving increased productivity and efficiencies for our clients’ mission. Our extensive experience in the Federal, Defense, Intelligence, State, Local, Healthcare and Commercial industries delivers proven results and accelerated benefits.

Clients engage PLANIT for our expertise, innovative approach, and our exceptional team. We promote a creative, client-centric work environment and culture, striving to provide challenging and rewarding opportunities for our company’s employees and partners. Integrity and innovation are the core principles of our company philosophy. Our customers engage us to create solutions to complex mission challenges, and PLANIT delivers. For more information, visit http://www.planitgroup.com/. Innovation. Integration. Integrity.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Government and Military
WEBSITE
https://www.planitgroup.com/