About the Role
As a Data Architect, you will architect and deliver modern cloud data platforms, focusing on Snowflake and/or Databricks. You will collaborate with customers to design, assess, optimize, and modernize enterprise data ecosystems, ensuring scalability, security, cost-effectiveness, and adherence to best practices. You will serve as a trusted technical advisor, leading the architecture of data platforms for advanced analytics, AI/ML, data sharing, and operational reporting, working across the full project lifecycle to define target-state architectures, data models, governance frameworks, and integration patterns.
Responsibilities
- Act as the lead architect for Snowflake and Databricks-based data platforms, defining architecture roadmaps and ensuring alignment to customer business objectives.
- Design and optimize Snowflake environments, including data sharing, secure data access, data warehouse design, performance tuning, governance, and cost optimization.
- Design and implement Databricks lakehouse architectures, supporting large-scale data engineering, streaming, analytics, AI, and machine learning workloads.
- Evaluate existing data estates and develop migration strategies to modern cloud data platforms, including Snowflake and Databricks.
- Develop enterprise data models, Lakehouse architectures, medallion data architectures, and data platform standards.
- Define scalable patterns for data ingestion, transformation, orchestration, and integration across cloud and hybrid environments.
- Partner with data engineers, analysts, cloud architects, security teams, and customer stakeholders to deliver high-quality data solutions.
- Establish and enforce governance frameworks covering data quality, lineage, metadata management, access controls, and regulatory compliance.
- Produce and maintain architecture artefacts, standards, patterns, and technical documentation.
- Guide customers on emerging technologies including AI, ML, GenAI, and advanced analytics leveraging Snowflake and Databricks capabilities.
- Proven experience in multi-cloud architecture across AWS and Azure, designing and integrating modern data solutions with cloud-native services to deliver scalable, secure, and business-aligned outcomes.
Requirements
- Strong understanding of modern data platform architecture, including Snowflake Data Cloud and/or Databricks Lakehouse Platform.
- Strong knowledge of cloud-native data architectures across Azure and AWS.
- Strong understanding of data governance, security, metadata management, and data lifecycle management.
- Understanding of AI/ML data requirements and modern analytics platforms.
- Knowledge of big data processing frameworks and distributed computing concepts.
- Awareness of emerging capabilities in data sharing, data products, and data mesh architectures.
- Proven experience as a Data Architect delivering enterprise-scale cloud data platforms.
- Significant hands-on experience designing and implementing solutions using Snowflake and/or Databricks.
- Experience architecting lakehouse, data warehouse, and hybrid analytical platforms.
- Experience defining migration strategies from legacy data platforms to Snowflake or Databricks.
- Proven expertise in data modelling, interoperability standards, and enterprise integration patterns.
- Experience implementing data governance, lineage, security, and compliance controls within modern data platforms.
- Experience leading architecture decisions across complex stakeholder environments.
- Strong understanding of data pipelines, ETL/ELT frameworks, orchestration tooling, and data engineering best practices.
- Familiarity with technologies such as Spark, Python, SQL, Delta Lake, Unity Catalog, dbt, Azure Data Factory, Airflow, Kafka, or equivalent tooling.
- Relevant certifications such as Snowflake SnowPro, Databricks Certified Data Engineer, or cloud platform certifications would be an advantage.
- Strong communication, consulting, and stakeholder management skills.
- Ability to influence senior technical and non-technical audiences on data platform strategy.
- Experienced in developing design documentation and option papers, guiding solutions through formal governance processes, and presenting proposals to architecture and governance boards (including TDAs) to secure approval and alignment.
- Strong analytical and problem-solving capabilities.
- Ability to translate business requirements into scalable Snowflake and Databricks architectural solutions.
- Passion for promoting data as a strategic asset and enabling data-driven decision making.
- Ability to mentor engineers and architects while contributing to technical leadership within delivery teams.
- Experience balancing performance, security, scalability, and cost optimisation within cloud data platforms.
- Eligible for security clearance.
- Must be a British Citizen.
- Must have lived permanently in the UK for the last 5 years.
Skills
- Snowflake
- Databricks
- AWS
- Azure
- Data Modelling
- Data Governance
- Data Security
- Metadata Management
- Data Lifecycle Management
- AI/ML
- Big Data Processing
- Distributed Computing
- Data Sharing
- Data Products
- Data Mesh Architectures
- Lakehouse Architecture
- Data Warehouse Architecture
- Hybrid Analytical Platforms
- Migration Strategies
- Enterprise Integration Patterns
- Data Pipelines
- ETL/ELT
- Orchestration Tooling
- Data Engineering
- Spark
- Python
- SQL
- Delta Lake
- Unity Catalog
- dbt
- Azure Data Factory
- Airflow
- Kafka
- Communication
- Consulting
- Stakeholder Management
- Influencing
- Problem-Solving
- Mentoring
- Technical Leadership
Location
- Client Site
Work Type
- Hybrid
- Full-time
Experience Level
- Senior
About the Company
- CACI Information Intelligence Group is a community of dedicated engineers delivering cutting-edge data solutions for public sector customers across Central Government, Defence, National Security, Critical National Infrastructure and Law Enforcement.
