Data Warehouse Architect
Core
Design and govern enterprise data warehouse, lakehouse, and analytics architectures to enable trusted insights and data-driven decision-making across the business.
Role type
Senior Data Warehouse Architect
Builds
Scalable, secure, and maintainable data platforms supporting reporting, analytics, and operational decision-making
Domain
Government IT services, Data Engineering, Cloud Data Platforms
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Enterprise data architecture, Data modeling (star schemas, dimensional), Advanced SQL, ETL/ELT pipeline design, Cloud data platforms, Data governance, Performance optimization
Preferred skills
Cloud-native architectures, Data lakes/lakehouses, Streaming technologies (Kafka, Spark), dbt, Data Vault/Kimball/Mesh, CI/CD, Infrastructure as Code
Technologies
Azure Data Factory, AWS Glue, Informatica, dbt, SSIS, Snowflake, Databricks, Microsoft Fabric, Amazon Redshift, Google BigQuery, Azure Synapse
Responsibilities
Lead design of enterprise data warehouse and lakehouse architectures; Define data models, standards, and governance frameworks; Provide technical leadership for ETL/ELT and cloud transformation; Partner with stakeholders to deliver high-performing data solutions
Seniority
Senior, hands-on IC with strategic leadership
