Data Warehouse Architect

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

Benefits offered by this job

Health and Wellness programs

Paid Leave

Retirement benefits

Job summary

Leidos Australia is seeking a Data Warehouse Architect to shape the organisation's data landscape. You will design scalable, secure data platforms and govern data models across cloud, on‑prem, and SaaS environments, aligning with strategic objectives.

You will lead ETL/ELT pipelines and collaborate with engineers, analysts, and business stakeholders to deliver high‑quality analytics solutions that support decision‑making.

Qualifications

• Significant experience in data warehousing, data architecture, database design, or data engineering within complex enterprise environments.
• Experience designing conceptual, logical, physical, and dimensional data models including star schemas, fact and dimension tables.
• Advanced SQL capability and experience with relational data technologies and large-scale data environments.
• Experience designing and overseeing ETL/ELT pipelines using Azure Data Factory, AWS Glue, Informatica, dbt, SSIS, or similar tools.

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.
• Provide technical leadership across ETL/ELT development, data integration, platform modernisation, and cloud transformations.
• Partner with engineers, analysts, and stakeholders to deliver secure, scalable data solutions for reporting and analytics.

Skills

Data warehousing

SQL

Cloud platforms

Data governance

Stakeholder collaboration

Architectural leadership

Education

Degree in data engineering / computer science

Tools

Azure Data Factory

AWS Glue

Informatica

dbt

Snowflake

Databricks

Azure Synapse

Job description

About Leidos Australia

At Leidos Australia, our work goes beyond a job title. We design, build, operate and support the systems, services and capabilities that help protect and advance the Australian way of life. Backed by a global organisation of more than 40,000 people, our Australian team of around 2,000 has partnered with government, defence and national security customers for more than 30 years. We deliver mission-critical solutions where reliability, trust and purpose matter. Leidos is a destination for people who want their work to have purpose, their contribution to be recognised, and their career to grow without needing to fit a single mould.

Meaningful work is supported by benefits, flexibility and career pathways that help you grow while balancing life outside work. This includes:

• Flex Your Way - Tailor work to your life with options including Life Days (up to 12 extra days off per year), part-time arrangements, job sharing, and compressed hours.
• Wellbeing That Matters - Free access to Headspace and MeQuilibrium, plus dedicated wellness spaces to support your mental, physical, and emotional wellbeing.
• Learn Without Limits - Access over 120,000 on-demand courses, alongside technical, project management, leadership, and professional development opportunities.
• Work That Makes an Impact - Contribute to nationally significant projects that matter, solve complex challenges, and accelerate your career through unique growth opportunities.
• Build Your Future - Whether you're deepening technical expertise or preparing for leadership, we'll invest in your development every step of the way.
• And Much More - These are just a few of the ways we invest in our people and help them thrive.

About the Team

You’ll join a team where people work with integrity, inclusion, innovation, agility, collaboration and commitment. In practice, that means sharing ownership, solving complex problems together and staying connected to the customer context, the purpose behind the work and how each role contributes to meaningful outcomes.

The Civil Digital Modernisation business delivers IT services to Australian Federal and State Government departments and agencies to accelerate digital modernisation and ensure secure, resilient, and adaptive environments that meet evolving regulatory, compliance, and business needs. Our approach integrates advancing data, AI, cloud, and automation delivering agility, security, efficiency, and innovation at scale.

Opportunity

As a Data Warehouse Architect, you will play a key role in shaping the organisation’s enterprise data landscape, enabling trusted insights and data-driven decision-making across the business. Working with business stakeholders, data professionals, and technology teams, you will design and govern modern data platforms that are scalable, secure, and aligned to strategic objectives.

Lead the design and evolution of enterprise data warehouse, lakehouse, and analytics architectures across cloud, on-premises, and SaaS environments, ensuring solutions support current and future business needs.

Define and implement data models, architecture standards, integration patterns, and governance frameworks that improve data quality, consistency, accessibility, and usability across the organisation.

Provide technical leadership across ETL/ELT development, data integration, platform modernisation, and cloud transformation initiatives, guiding teams through complex architectural and delivery challenges.

Partner with engineers, analysts, architects, and business stakeholders to deliver high-performing, secure, and maintainable data solutions that support reporting, analytics, business intelligence, and operational decision-making.

About You

You are an experienced data professional who combines strategic thinking with hands‑on technical expertise. You enjoy translating business requirements into practical data solutions and are passionate about building data platforms that are reliable, scalable, and trusted by stakeholders across the organisation.

Essential

• Significant experience in data warehousing, data architecture, database design, or data engineering within complex enterprise environments.
• Experience designing conceptual, logical, physical, and dimensional data models, including star schemas, fact tables, and dimension tables.
• Advanced SQL capability and experience working with relational database technologies and large-scale data environments.
• Experience designing and overseeing ETL/ELT pipelines using technologies such as Azure Data Factory, AWS Glue, Informatica, dbt, SSIS, or similar platforms.
• Knowledge of modern cloud data platforms such as Snowflake, Databricks, Microsoft Fabric, Amazon Redshift, Google 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 while maintaining operational reliability.
• Experience working collaboratively with stakeholders across business and technology teams and providing technical leadership, mentoring, and architectural guidance.
• Well‑developed communication skills with the ability to explain complex technical concepts to a range of audiences.

Advantageous

• Experience with cloud‑native data architectures, data lakes, lakehouses, and modern analytics platforms.
• Knowledge of Databricks, Delta Lake, Spark, Kafka, or other modern data processing and streaming technologies.
• Experience with dbt and contemporary data transformation practices.
• Familiarity with Data Vault, Kimball, data mesh, or other enterprise data modelling and architecture approaches.
• Experience implementing CI/CD practices and Infrastructure as Code within data platforms.
• Exposure to data cataloguing, governance, or metadata management tools.
• Relevant qualifications or certifications in cloud architecture, data engineering, database technologies, or enterprise architecture.

Eligibility and Security Clearance

This role requires the successful applicant to be eligible to obtain and maintain a NV1 Security Clearance.

Pay Range

The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary.

Original Posting

For U.S. Positions: While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.

Pay and Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers.

• Competitive compensation
• Health and Wellness programs
• Income Protection
• Paid Leave
• Retirement

Securing Your Data

Leidos will never ask you to provide payment-related information at any part of the employment application process. And Leidos will communicate with you only through emails that are sent from a Leidos.com email address. If you receive an email purporting to be from Leidos that asks for payment-related information or any other personal information, please report the email to [e-mail].

Commitment and Diversity

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law.

Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.

Company Culture

At Leidos, we outthink, outbuild, and outpace the status quo - because the mission demands it. We're not hiring followers. We're recruiting the ones who disrupt, provoke, and refuse to fail. Step 10 is ancient history. We're already at step 30 - and moving faster than anyone else dares.