user avatar
Posted today

Job Requirements

Fairfax, VA
Public Trust Polygraph Unspecified
Career Level not specified
$155,000 - $220,000

Job Description

Senior Data Modeler / Data Architect (CDM Program)

Location: Hybrid

Clearance: Ability to obtain Public Trust

Overview

We are seeking a Senior Data Modeler / Data Architect to support dashboard development for a large-scale federal cybersecurity program (CDM). This role will serve as the subject matter expert for data modeling and data design, partnering closely with stakeholders to design, evolve, and maintain data structures that support cybersecurity analytics and reporting.

This is a client-facing, senior-level role requiring strong communication skills and the ability to operate with minimal supervision in a fast-paced, evolving environment.

Key Responsibilities
  • Lead data modeling, data design, and database architecture efforts
  • Design and evolve data structures to support dashboards and analytics
  • Build and maintain data dictionaries, data catalogs, and clear data definitions
  • Perform impact analysis and manage change processes for data models
  • Serve as a trusted advisor to stakeholders and customers, translating requirements into technical solutions
  • Partner with governance teams to define and implement data quality standards and policies
  • Support requirements gathering and ensure alignment with data architecture
  • Collaborate with analysts and cross-functional teams to enable effective data usage
  • Evaluate code (e.g., Python) to understand data flows and model dependencies
  • Ensure data quality, consistency, and usability across systems

Required Qualifications
  • 7+ years of experience in data modeling, data architecture, or database design (flexible for strong candidates)
  • Strong expertise in:
    • Data modeling (conceptual, logical, physical)
    • ERDs, UML, entities/relationships
    • Relational and non-relational databases
    • Data normalization and data structure design
  • Experience creating and maintaining data dictionaries and data catalogs
  • Ability to work directly with clients and communicate technical concepts clearly
  • Experience managing data model changes and governance processes
  • Working knowledge of Python for data analysis or validation
  • Experience with tools such as Databricks, Alation, Jira, Confluence or similar
  • Strong problem-solving skills and ability to adapt to changing priorities

Preferred Qualifications
  • Experience with cybersecurity data or frameworks (e.g., CDM, SCAP, STIX, Elastic Common Schema, Splunk CIM)
  • Familiarity with Elasticsearch / Elastic dashboards
  • Experience in data warehousing environments
  • Exposure to data governance frameworks and policies
  • Ability to support automation or process improvements

Work Environment
  • ~60% data modeling and design
  • 20-30% stakeholder interaction and client meetings
  • Remaining time collaborating with internal teams (analysts, governance, requirements)
  • No direct reports; highly collaborative role across multiple teams

What Success Looks Like
  • Delivering scalable, well-documented data models
  • Acting as a trusted advisor to stakeholders
  • Enabling high-quality data for dashboarding and analytics
  • Adapting quickly as program priorities evolve

Compensation
  • Salary: $155,000 - $220,000
  • Benefits: Medical, Dental, Vision, 401 (k), PTO, Sick Leave, Holidays. (As required by law)
group id: 10430981
job ad image
Find Zachary Piper Solutions, LLC on Social Media
Network Employers
user avatar
About Us
Zachary Piper Solutions is a National Security focused technology services and consulting firm with a top-secret facility clearance. We support mission-critical initiatives on behalf of the Intelligence Community, Department of Defense, Department of Homeland Security, Department of Justice, Department of State, and a variety of Civilian Agencies. ZPS is dedicated to help protect government networks against cyber threats and to maximize the wide-spectrum of intelligence and security-related technologies. Our dedicated support and proven experience drive results in support of our client’s mission objectives.
job ad2 image

Zachary Piper Solutions, LLC Jobs


Clearance Level
Public Trust