Solution Architect – Data Warehouse Migration

Cognizant; Województwo mazowieckie; Remote; PLN 180,000 - 300,000; Full time

Job summary

Cognizant Technology Solutions Corporation is seeking an experienced Solution Architect to lead the modernization of a large-scale data warehouse. You will define the target-state architecture, produce HLD and LLD, and drive architectural decisions across migration workstreams with business, data, and platform stakeholders.

Collaborating with governance boards and delivery teams, you will ensure scalability, security, and high performance of a cloud-native data platform while mentoring engineers

Qualifications

• 10+ years of experience in Data Warehousing and Analytics solutions.
• Hands-on with Snowflake, Teradata, Informatica PowerCenter, Informatica IDMC, and 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 and wave planning.
• 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

Cloud ELT architectures

Migration program experience

Leadership

Tools

Snowflake

Teradata

Informatica PowerCenter

Informatica IDMC

DBT

Job description

Location: Poland, Remote

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.

#LI-1_MS1