Enterprise Data Warehouse Architect – Cloud & Analytics

Leidos; Canberra; On-site; AUD 120,000 - 180,000; Full time

Job summary

Leidos Australia seeks a Data Warehouse Architect to shape the enterprise data landscape within the Civil Digital Modernisation team in Australia. You will design and govern data platforms that scale securely to support reporting, BI, and operational insights, working with stakeholders and engineers.

You bring deep experience in data warehousing, architecture, and cloud platforms, with strong SQL, ETL pipelines, and data governance capabilities, enabling trusted, high-quality analytics across

Qualifications

• Significant experience in data warehousing and data engineering within complex enterprise environments.
• Experience designing conceptual, logical, physical, and dimensional data models including star schemas.
• Advanced SQL capabilities and working with relational databases and large-scale data environments.
• Experience designing and overseeing ETL/ELT pipelines using Azure Data Factory, AWS Glue, Informatica, dbt, SSIS, or similar.
• Knowledge of modern cloud data platforms such as Snowflake, Databricks, MS Fabric, Redshift, BigQuery, or Azure Synapse.
• Experience with data governance, metadata management, lineage, security, privacy, and data quality frameworks.
• Ability to optimise data platform performance, scalability, storage, and workload management.
• Experience collaborating with stakeholders across business and technology teams and providing architectural guidance.
• Strong communication skills to explain complex concepts to diverse audiences.

Responsibilities

• Lead the 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 for data quality and accessibility.
• Provide technical leadership across ETL/ELT development, data integration, platform modernisation, and cloud transformation initiatives.
• Partner with engineers, analysts, architects, and business stakeholders to deliver secure, high-performing data solutions for reporting and analytics.

Skills

Data warehousing

Data architecture

SQL

ETL/ELT

Cloud data platforms

Data governance

Stakeholder communication

Performance optimization

Technical leadership

Education

Cloud architecture certification

Tools

Azure Data Factory

AWS Glue

Informatica

dbt

Snowflake

Databricks

Azure Synapse

Job description

Leidos Australia seeks a Data Warehouse Architect to shape the enterprise data landscape within the Civil Digital Modernisation team in Australia. You will design and govern data platforms that scale securely to support reporting, BI, and operational insights, working with stakeholders and engineers.

You bring deep experience in data warehousing, architecture, and cloud platforms, with strong SQL, ETL pipelines, and data governance capabilities, enabling trusted, high-quality analytics across