Data Architect

The Data Architect will design, build, and govern enterprisescale 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 handson experience with Amazon Redshift, SQL databases and staging schemas, SSISbased ETL, data lake architectures, Power BI, and data modeling in highvolume, multisource environments., Data Architecture & Design

• Design and maintain scalable endtoend 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

Data Engineering & Integration

• Lead the design and implementation of ETL/ELT pipelines using SSIS and SQLbased transformations.
• Integrate structured and semistructured 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 reportingready datasets optimized for Power BI semantic models.
• Partner with BI developers and analysts to ensure efficient data consumption.
• Enable executivelevel 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.

Technical Skills

• Amazon Redshift architecture, performance tuning, and optimization
• Strong expertise in SQL databases, complex queries, and data transformations
• Handson 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 largescale, enterprise data platforms
• Experience designing data solutions for cyber, risk, compliance, or telemetry data preferred

Soft Skills

• Strong analytical and problemsolving skills
• Ability to communicate complex data concepts to technical and nontechnical stakeholders
• Comfortable operating in a matrixed, fastpaced 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 decisionmaking