Zensar logo
Zensar

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Solution Architect - Data Migration & Analytics

Location

India

Posted

3 days ago

Salary

0

Seniority

Mid Level

Job Description

Solution Architect - Data Migration & Analytics

Zensar

Role Description We are hiring a Solution Architect to lead a strategic data modernization program involving migration from 14+ source systems (including Guidewire InsuranceNow) into a Snowflake-based Data Warehouse leveraging dbt. The role also includes driving a report rationalization initiative, consolidating legacy reports into a streamlined Power BI analytics layer. This is a high-impact role requiring strong expertise in data architecture, large-scale migration, and insurance domain transformation. Key Responsibilities - Architecture & Design - Define end-to-end data architecture for ingesting structured and unstructured data into Snowflake. - Architect layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold) using dbt-based ELT frameworks. - Establish scalable, secure, and performance-optimized data models. - Data Migration Leadership - Design migration strategy for 14+ systems including InsuranceNow. - Define data mapping, transformation logic, and reconciliation frameworks. - Implement data quality controls, auditability, and parallel validation mechanisms. - Analytics & Reporting Modernization - Lead report rationalization and consolidation initiative. - Design Power BI semantic layer and standardize KPIs. - Eliminate redundant reports and enable unified, business-friendly dashboards. - Governance & Quality - Establish data governance, lineage, and metadata standards. - Ensure compliance with insurance regulatory and audit requirements. - Define quality KPIs and monitoring frameworks. - Stakeholder Leadership - Act as technical SME and advisor for business, data, and leadership teams. - Drive architecture governance, design reviews, and delivery alignment. - Identify and mitigate risks in a complex multi-source migration program. Qualifications - 10+ years in data engineering / data architecture, with enterprise-scale programs. - Proven expertise in: - Snowflake & dbt - Multi-source data migration (10+ systems) - Data modeling (dimensional / data vault) - Hands-on experience in Power BI and report consolidation - Strong understanding of structured + unstructured data integration - Experience with cloud platforms (Azure / AWS / GCP) - Knowledge of Cortex AI is a plus - Insurance domain experience (P&C preferred). - Understanding of policy, claims, billing, and customer data models. Ideal Candidate Profile A hands-on architect and strategic thinker who can balance technical depth with business alignment, and has delivered large-scale data transformation programs in the insurance domain. Benefits - Inclusive workplace culture. - Equal employment opportunity (EEO) and affirmative action employer. - Commitment to creating an inclusive workplace.

Related Categories

Related Job Pages

More Data Analyst Jobs

Hollis Cobb Associates logo

Customer Service Data Analyst

Hollis Cobb Associates

Healthcare Revenue Cycle Management - Front End to Back End

Data Analyst3 days ago
Part TimeRemoteTeam 501-1,000Since 1977H1B No Sponsor

• Extensive knowledge of inventory tracking and other methods of resolving accounts discrepancies • Resolves billing or service problems by clarifying the clients dispute; determining the cause of the service problem, selecting and explaining the best solution to solve the service problem, expediting dispute correction or adjustment, and following up to ensure resolution • Audit and investigate to identify discrepancies between accounts and resolve them • Research payment and dispute documentation within company and client’s billing/payment systems • Provide backup documentation as justification of bill cancellations and adjustments • Maintains financial accounts by following up on payment promises and adjustments

United States
Job Closed
Gainwell Technologies logo

Senior ETL Data Analyst

Gainwell Technologies

Gainwell Technologies is an award-winning digital health technology company that supports the administration of healthcare and human services programs. In past

Data Analyst3 days ago

• Perform requirements gathering and data analysis to support ETL development and healthcare data transformation initiatives • Create detailed mapping documents and technical specifications based on business and system requirements • Partner with ETL developers, DBAs, and configuration teams to ensure accurate implementation of data solutions • Analyze data using SQL and data models to identify transformation logic, trends, and business insights • Develop test cases and support testing (unit, integration, system, and UAT) to validate that solutions meet design and business expectations

Illinois
$69.4K - $99.2K / year
Gainwell Technologies logo

Data Analyst

Gainwell Technologies

Gainwell Technologies is an award-winning digital health technology company that supports the administration of healthcare and human services programs. In past

Data Analyst3 days ago

• Lead data analysis efforts by gathering requirements, designing mapping documents, and developing technical specifications to support ETL, reporting, conversion, and interface solutions • Mentor, direct, and support data analysts while coordinating work assignments with development leads and project teams to ensure timely delivery • Analyze healthcare data and transformation requirements using SQL, schemas, data models, and data dictionaries to support accurate solution design • Partner with ETL, reporting, conversion, configuration, and DBA teams to ensure mappings, code, and technical solutions align with documented business requirements • Develop test cases and support testing and validation activities across units, system integration, system, and user acceptance testing to ensure solutions meet design and business expectations

Illinois
$86.8K - $124K / year
Bavarian Nordic logo

Salesforce & Omnichannel Data Analytics Lead

Bavarian Nordic

Bavarian Nordic is a global vaccine company with a mission to improve health and save lives through innovative vaccines. We are a preferred supplier of mpox and smallpox vaccines to governments to enhance public health preparedness and have a leading portfolio of travel vaccines. We are headquartered in Denmark and have manufacturing, research, and sales offices across Europe and North America. Bavarian Nordic is an Equal Opportunity Employer. All qualified applications will receive consideration for employment and will not be discriminated against based on race, color, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. For more information, visit www.bavarian-nordic.com

Data Analyst3 days ago
Full TimeRemoteTeam 1,001-5,000H1B No Sponsor

Role Description Are you ready to take on a challenge where your expertise in data analytics, omnichannel performance, CRM, and digital campaigns can make a real impact? Great! We are looking for a Salesforce & Omnichannel Data Analytics Lead (m/f/d) to join our commercial team and help turn data into actionable insights. This position offers a fully remote setup for candidates located in the UK. - Integrate, validate and analyze data from CRM, digital platforms and other sources to create a unified and actionable view of customer activities. - Define, standardize and monitor KPIs across CRM and digital platforms to ensure transparency, alignment and action. - Develop, automate and maintain omnichannel and sales force effectiveness dashboards, and deliver campaign and engagement performance metrics across brands and geographies to assess performance and identify improvement areas. - Conduct ad-hoc deep dives and root cause analyses to support tactical decision-making and strategic planning across markets and products. - Ensure data quality, consistency and structure across internal and external sources. - Act as the senior point of contact for all analytics topics related to field force, digital and omnichannel performance. Qualifications - Master’s degree in Data Science, Business Analytics or a related field. - Proven experience in omnichannel engagement analytics, digital campaigns, CRM metrics, field force performance and social media data analysis. - Experience in the pharmaceutical, biotech or medical device industry is an advantage. - Proficiency in reporting and visualization tools such as Power BI and working knowledge of Python for data analysis, automation and advanced analytics. - Advanced knowledge of CRM systems such as Veeva and Salesforce as well as marketing platforms (Marketing Cloud) and Google Analytics. - Strong understanding of database structures with the ability to integrate, extract, analyze and interpret data, build dashboards from scratch and automate scalable reporting. - Fluency in English, German is a plus. Benefits - Join a passionate, mission-driven global biotech committed to protecting lives. - Collaborative culture and flexible work environment. - Opportunities for ongoing professional development and growth. Company Description Bavarian Nordic is a global vaccine company with a mission to improve health and save lives through innovative vaccines. We are a preferred supplier of mpox and smallpox vaccines to governments to enhance public health preparedness and have a leading portfolio of travel vaccines. We are headquartered in Denmark and have manufacturing, research, and sales offices across Europe and North America. Bavarian Nordic is an Equal Opportunity Employer. All qualified applications will receive consideration for employment and will not be discriminated against based on race, color, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. For more information, visit www.bavarian-nordic.com

United Kingdom