Cyber Data Architect / Modeler

Job Title: Cyber Data Architect / Modeler
Remote

Role Overview

The Cyber Data Architect / Modeler is responsible for designing, governing, and evolving the enterprise cybersecurity data model that supports reporting, analytics, and AI/ML initiatives.

This role ensures that cyber data is well-modeled, secure, lineage-enabled, high-performing, and compliant, from ingestion through semantic presentation.

The ideal candidate brings strong expertise in enterprise data modeling, Power BI semantic layers, SQL optimization, and cloud data platforms, along with experience in cybersecurity or regulated environments.

This role collaborates closely with data engineering, BI, security, and governance teams to ensure data assets are enterprise-ready and audit-compliant.

Key Responsibilities

1. Semantic Modeling & Enterprise Reporting Architecture

• Design, develop, and maintain Power BI semantic models, datasets, and dataflows for enterprise cybersecurity reporting.
• Ensure consistent and certified metrics and dimensions across reporting layers.
• Align semantic models with business definitions, cybersecurity KPIs, and governance standards.

2. Power BI Governance & Standards

• Define and enforce best practices, including:
• Dataset versioning and lifecycle management
• Workspace structure and separation of duties
• Row-Level Security (RLS) and access control
• Data refresh strategies and scheduling
• Certified datasets and shared semantic models
• Ensure BI architecture supports scalability, security, and controlled self-service analytics.

3. Data Modeling & SQL Optimization

• Develop and optimize SQL views, stored procedures, and transformation logic.
• Apply dimensional, relational, and hybrid data modeling techniques.
• Collaborate with data engineering teams to align upstream and downstream data processes.

4. Data Lineage, Documentation & Metadata

• Maintain end-to-end data lineage documentation across all data layers.
• Define standards for metadata, documentation, and traceability.
• Support audit readiness, impact analysis, and change management.
• Act as a steward for semantic and analytical data assets.

5. Enterprise Data Platform (EDP) Architecture

• Design and manage data pipelines within platforms such as:
• Azure Data Lake
• Databricks
• Internal enterprise data platforms
• Define data storage strategies (raw, curated, gold layers).
• Ensure curated datasets meet cybersecurity reporting requirements.

6. Asset Design & Reporting Readiness

• Develop data assets to support:
• Cybersecurity KPIs and metrics
• Operational dashboards
• Risk and compliance reporting
• Validate that data models meet performance, usability, and governance standards before release.

7. Security, Compliance & Audit Support

• Support audits and compliance initiatives by:
• Ensuring accurate data classification
• Enforcing access management and least-privilege principles
• Providing lineage, documentation, and usage evidence
• Align data architecture with frameworks such as NIST, ISO, SOC 2, or industry regulations.

Required Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Architecture, Cybersecurity, or related field.
• 8+ years of experience in data architecture, data modeling, or analytics engineering.
• Strong hands-on experience with:
• Power BI semantic models and governance
• SQL and analytical data modeling
• Enterprise/cloud data platforms
• Strong documentation, communication, and collaboration skills.

Cybersecurity & Regulated Environment Experience (Critical)

• Experience supporting cybersecurity, risk, or compliance analytics.
• Familiarity with security telemetry and cyber reporting.
• Understanding of:
• Data classification
• Access control
• Auditability
• Secure reporting practices
• Experience working within frameworks such as NIST, ISO, SOC.

Preferred / Nice-to-Have Qualifications

• Experience with Azure Data Lake, Databricks, or similar platforms.
• Familiarity with metadata management and lineage tools.
• Experience supporting SOC, GRC, or cyber risk reporting platforms.
• Certifications in Power BI or Data Architecture.
• Experience defining enterprise data standards or reference architectures.