Data Warehouse Architect

About the role

The Data Warehouse Architect will shape Leidos' enterprise data landscape, enabling trusted insights and data‑driven decision‑making across the business. You will work with stakeholders, data professionals and technology teams to design and govern modern, scalable and secure data platforms.

Key responsibilities

• Lead design and evolution of enterprise data warehouse, lakehouse and analytics architectures across cloud, on‑premises and SaaS environments.
• Define and implement data models, architecture standards, integration patterns and governance frameworks to improve data quality, consistency and accessibility.
• Provide technical leadership for ETL/ELT development, data integration, platform modernisation and cloud transformation initiatives.
• Partner with engineers, analysts and business stakeholders to deliver high‑performing, secure and maintainable data solutions for reporting, analytics and operational decision‑making.

Required profile

• Significant experience in data warehousing, data architecture or data engineering within complex enterprise environments.
• Proven ability to translate business requirements into practical data solutions and to mentor technical teams.
• Strong communication skills to explain complex technical concepts to diverse audiences.

Required skills

• Advanced SQL and experience with relational databases and large‑scale data environments.
• Design of conceptual, logical, physical and dimensional data models (star schemas, fact and dimension tables).
• ETL/ELT tools such as Azure Data Factory, AWS Glue, Informatica, dbt, SSIS.
• Modern cloud data platforms: Snowflake, Databricks, Microsoft Fabric, Amazon Redshift, Google BigQuery, Azure Synapse.
• Data governance, metadata management, lineage, security, privacy and data quality frameworks.

What we offer

• Flexible work options including part‑time, job sharing and compressed hours.
• Wellbeing support with free access to Headspace, MeQuilibrium and dedicated wellness spaces.
• Learning opportunities with over 120,000 on‑demand courses and professional development programs.
• Opportunity to work on nationally significant projects that have real impact.