Solution Architect – Data Warehouse Migration

Cognizant; Stockholms kommun; On-site; SEK 1,200,000 - 1,800,000; Full time

Job summary

Cognizant is seeking an experienced Solution Architect to lead architecture and design for a large-scale data warehouse modernization program in Sweden. You will define target-state architecture, prepare HLD/LLD, and drive decisions across migration workstreams while collaborating with business stakeholders and platform teams.

The role requires guiding teams from blueprint to delivery, ensuring scalable, secure, and high-performing cloud-native data platforms with minimal business disruption

Qualifications

• 10+ years of experience in Data Warehousing and Analytics solutions.
• Hands-on experience with Snowflake, Teradata, Informatica PowerCenter, Informatica IDMC, DBT.
• Experience in enterprise-scale migration and modernization programs.
• Strong understanding of cloud data platforms and modern ELT architectures.

Responsibilities

• Define end-to-end target architecture for data warehouse modernization.
• Develop and maintain architecture blueprints, standards, and design principles.
• Create and own High-Level Design (HLD) and Low-Level Design (LLD) documentation.
• Design migration strategies.
• Ensure architecture supports scalability, performance, security, reliability, and maintainability.
• Define data ingestion, transformation, storage, and consumption architecture.
• Assess current-state architecture and identify migration impacts.
• Define application, data, ETL, and reporting migration approaches.
• Perform migration wave planning and dependency analysis.
• Identify migration risks and propose mitigation strategies.
• Ensure minimal business disruption during migration activities.
• Establish coexistence, reconciliation, and cutover strategies.
• Present architecture designs and recommendations to governance boards and leadership.
• Provide technical leadership and mentoring across delivery teams.

Skills

Data Warehousing

Analytics Solutions

Migration & Modernization

Cloud Data Platforms

ELT Architectures

Tools

Snowflake

Teradata

Informatica PowerCenter

Informatica IDMC

DBT

Job description

Technology matters most when it changes what a business can achieve. Cognizant is a global technology services company helping organizations modernize their systems, reimagine processes and turn data and AI into practical business value. Bringing together expertise in cloud, software engineering, data and AI, Cognizant connects complex technology challenges with the needs of the businesses that rely on it.

For a Solution Architect, that means working where architectural decisions make a tangible difference. In this role, you will help shape a large-scale data warehouse modernization program—turning legacy complexity into a scalable, secure, cloud-native platform. If you enjoy connecting business priorities with technical design, collaborating across disciplines and guiding teams from blueprint to delivery, this is an opportunity to put that expertise to work.

About the role

We are seeking an experienced Solution Architect to lead the architecture and design of a large-scale data warehouse modernization program. The Solution Architect will be responsible for defining the target-state architecture, preparing High-Level Design (HLD) and Low-Level Design (LLD), ensuring alignment with business and technical requirements, and driving architectural decisions across all migration workstreams. The role requires close collaboration with business stakeholders, data architects, engineers, platform teams, and program leadership to deliver a scalable, secure, high-performing cloud-native data platform.

Responsibilities

• Define end-to-end target architecture for data warehouse modernization.
• Develop and maintain architecture blueprints, standards, and design principles.
• Create and own High-Level Design (HLD) and Low-Level Design (LLD) documentation.
• Design migration strategies
• Ensure architecture supports scalability, performance, security, reliability, and maintainability.
• Define data ingestion, transformation, storage, and consumption architecture.
• Assess current-state architecture and identify migration impacts.
• Define application, data, ETL, and reporting migration approaches.
• Perform migration wave planning and dependency analysis.
• Identify migration risks and propose mitigation strategies.
• Ensure minimal business disruption during migration activities.
• Establish coexistence, reconciliation, and cutover strategies.
• Present architecture designs and recommendations to governance boards and leadership.
• Provide technical leadership and mentoring across delivery teams.

Required Skills

• 10+ years of experience in Data Warehousing and Analytics solutions.
• Strong hands-on experience with:
  • Snowflake
  • Teradata
  • Informatica PowerCenter
  • Informatica IDMC
  • DBT
• Experience in enterprise-scale migration and modernization programs.
• Strong understanding of cloud data platforms and modern ELT architectures.