[Hiring] Solution Architect – Data Migration & Analytics @Zensar

Role Description

Zensar is looking for a Solution Architect – Data Migration & Analytics in North Carolina. This position is open for Full Time with excellent benefits and professional growth opportunities.

We are seeking a seasoned Solution Architect to lead a strategic data modernization and report rationalization program for a leading insurance client. The role will drive the design and implementation of a scalable, enterprise-wide data platform leveraging Snowflake, DBT, AWS, and Power BI, supporting both batch and real-time data ingestion while enabling advanced analytics and self-service reporting.

Key Responsibilities

• Enterprise Architecture & Strategy
  • Define and implement the target-state data architecture aligned with business goals for data modernization and reporting transformation.
  • Establish architecture principles, governance models, and design standards across data ingestion, transformation, and consumption layers.
  • Lead the adoption of Medallion Architecture (Raw, Silver, Gold layers) within Snowflake + DBT ecosystem.
• Data Platform Design & Modernization
  • Architect ingestion of data from 14+ source systems including InsuranceNow, ensuring scalability and reliability.
  • Design hybrid ingestion patterns:
    • Batch ingestion from enterprise sources
    • Real-time streaming via Amazon Kinesis
    • Data lake storage in AWS S3
  • Define data modelling strategies:
    • Canonical models and domain-driven design (aligned with insurance datasets)
    • Optimized analytical data models for reporting
• Data Engineering & Pipeline Optimization
  • Oversee implementation of efficient, reusable data pipelines using DBT and Snowflake.
  • Drive performance tuning across:
    • Data ingestion pipelines
    • Transformations across raw → silver → gold layers
  • Establish cost optimization strategies in Snowflake and AWS.
• Reporting & Analytics Transformation
  • Lead report rationalization initiatives:
    • Consolidation and optimization of legacy reports
    • Elimination of redundancy and duplication
  • Architect Power BI ecosystem:
    • Semantic data models for self-service BI
    • Support for paginated reporting and advanced slicing/dicing
    • Enable business-friendly data access and analytics democratization
• AI-driven Governance & Data Quality
  • Introduce AI-enabled frameworks for:
    • Data audit and reconciliation
    • Balancing and anomaly detection
  • Define enterprise-wide data quality, lineage, and governance standards.
  • Ensure compliance with regulatory requirements in the insurance domain.
• Integration & Cloud Architecture
  • Define integration patterns across:
    • Snowflake, DBT, S3, Kinesis, and enterprise applications
  • Ensure secure, scalable, and fault-tolerant architecture in AWS cloud environment.
  • Establish data security, encryption, and access control mechanisms.
• Leadership & Stakeholder Management
  • Collaborate with business, data engineering, BI, and governance teams.
  • Act as a trusted advisor to CXO stakeholders on data strategy and investments.
  • Drive architecture reviews, design approvals, and roadmap alignment.

Qualifications

• 10 – 15+ years experience in data and analytics.
• Strong experience in:
  • Snowflake (Data Warehousing & Optimization)
  • DBT (Data Transformation Framework)
  • AWS (S3, Kinesis, Cloud Architecture)
• Proven experience with:
  • Medallion Architecture (Bronze/Raw, Silver, Gold layers)
  • Real-time & batch data ingestion patterns
• Deep knowledge of:
  • Power BI (self-service, paginated reporting, semantic layers)
  • Data modeling (Dimensional & Data Vault)
• Strong experience in Insurance domain, particularly:
  • Policy, Claims, Billing, Customer data
• Familiarity with InsuranceNow or similar core systems.
• Experience designing enterprise-scale data platforms.
• Strong background in:
  • Data governance
  • Report rationalization programs
  • Performance and cost optimization

Benefits

• Flexible work arrangements.
• Competitive benefits package, including medical, dental, vision, and 401(k).