Note: The job is a remote job and is open to candidates in USA. Zensar Technologies is seeking a Solution Architect – Data Migration & Analytics to lead a strategic data modernization and report rationalization program for a leading insurance client. The role involves designing and implementing a scalable enterprise-wide data platform while ensuring advanced analytics and self-service reporting capabilities.
Responsibilities
- 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
- 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
- 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
- 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
- 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
- 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
- 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
Skills
- 10 – 15+ years experience in data and analytics
- Strong experience in Snowflake (Data Warehousing & Optimization)
- Strong experience in DBT (Data Transformation Framework)
- Strong experience in AWS (S3, Kinesis, Cloud Architecture)
- Proven experience with Medallion Architecture (Bronze/Raw, Silver, Gold layers)
- Proven experience with real-time & batch data ingestion patterns
- Deep knowledge of Power BI (self-service, paginated reporting, semantic layers)
- Deep knowledge of 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
- Strong background in report rationalization programs
- Strong background in performance and cost optimization
Benefits
- Flexible work arrangements
- A competitive benefits package, including medical, dental, vision, 401(k), among other benefits
Company Overview
Company H1B Sponsorship