Data Architect - Cyber Data Intelligence Platform

The Data Architect will design, build, and govern enterprise-scale data architectures that power a Cyber Data Intelligence Platform. This role is responsible for modeling, integrating, and optimizing security and telemetry data across data lakes, warehouses, and reporting layers to enable advanced analytics, exposure management, and executive reporting.

The ideal candidate has strong hands-on experience with Amazon Redshift, SQL databases and staging schemas, SSIS-based ETL, data lake architectures, Power BI, and data modeling in high-volume, multi-source environments., Data Architecture & Design

• Design and maintain scalable end-to-end data architecture supporting cyber and security analytics use cases.
• Define logical, physical, and semantic data models optimized for analytics and reporting.
• Establish standardized SQL staging schemas for raw, curated, and consumable data layers.
• Architect data flows between data lake, staging, and Amazon Redshift environments.

Data Engineering & Integration

• Lead the design and implementation of ETL/ELT pipelines using SSIS and SQL-based transformations.
• Integrate structured and semi-structured data from security platforms (e.g., vulnerability, cloud, endpoint, IAM, DLP tools).
• Optimize Redshift performance using:

• Distribution styles and keys
• Sort keys
• Partitioning strategies
• Query optimization and cost control

Data Lake & Warehouse Management

• Architect and govern data lake ingestion, storage, and lifecycle management.
• Ensure data quality, consistency, lineage, and metadata management across platforms.
• Implement scalable patterns for incremental loads, CDC, and historical tracking.

Analytics & Reporting Enablement

• Design reporting-ready datasets optimized for Power BI semantic models.
• Partner with BI developers and analysts to ensure efficient data consumption.
• Enable executive-level dashboards, operational reporting, and risk analytics.

Governance, Security & Compliance

• Define data standards, naming conventions, and modeling best practices.
• Implement data security controls consistent with cyber and compliance requirements.
• Support audit readiness through documentation, lineage, and data validation.

Stakeholder Collaboration

• Work closely with Cyber Security teams, Product Owners, Engineers, and BI teams.
• Translate business and security requirements into scalable data solutions.
• Provide architectural guidance and design reviews across delivery teams.

• Amazon Redshift architecture, performance tuning, and optimization
• Strong expertise in SQL databases, complex queries, and data transformations
• Hands-on experience designing SQL staging schemas and layered data models
• SSIS for ETL development and orchestration
• Data lake architectures (raw, curated, analytics layers)
• Power BI data modeling and optimization for analytics
• Advanced data modeling (dimensional, relational, analytical models)

Experience

• 7+ years in data architecture, data engineering, or analytics platforms
• Proven experience supporting large-scale, enterprise data platforms
• Experience designing data solutions for cyber, risk, compliance, or telemetry data preferred

Soft Skills

• Strong analytical and problem-solving skills
• Ability to communicate complex data concepts to technical and non-technical stakeholders
• Comfortable operating in a matrixed, fast-paced enterprise environment
• Experience balancing speed, scalability, and governance, * Cloud experience (AWS ecosystem beyond Redshift)
• Familiarity with security or cyber data domains (vulnerability management, DLP, IAM, exposure management)
• Experience with data governance or metadata tools
• Exposure to CI/CD and automated data pipelines

Success Metrics

• Scalable, performant data models adopted by analytics and BI users
• Reduced data latency and improved reporting reliability
• Clear, documented architecture supporting audit and compliance needs
• Trusted Power BI datasets enabling executive decision-making