• Develop and refine management reports and tools to support decision-making across business areas; • Facilitate interpretation of available market data by developing critical analyses of the information, thereby adding value to the insights provided; • Maintain and improve area processes by updating procedures and pursuing continuous improvement; • Conduct studies to identify sales growth opportunities among customers participating in the sales distribution chain; • Ensure the business rules applied to company KPIs overseen by the area; • Respond to ad‑hoc requests from internal stakeholders in a critical manner, deepening understanding of the need and proposing value-added solutions to the requester

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).

• Develop analyses of financial, operational and corporate indicators; • Build, enhance and maintain dashboards, reports and management panels; • Create, validate and monitor indicators (KPIs), ensuring consistency and adherence to business rules; • Structure and monitor metrics such as EBITDA, Working Capital, Opex, Capex, Headcount, Turnover, Attrition and other strategic indicators; • Perform SQL queries for data investigation, validation and analysis; • Identify inconsistencies in databases, investigate root causes and propose analytical solutions; • Partner with business areas to support decision-making through data; • Document queries, indicators, metrics and business rules; • Collaborate with the CRM Analyst to respond to analytical requests; • Identify needs for database evolution and route them to Data Engineering; • Participate in AI initiatives, predictive analyses and analytical modeling to generate insights; • Drive continuous improvements in indicators, dashboards and analytical processes.

• Collaborate with Product Managers, Business Stakeholders, and Engineering teams to gather, analyze, and document business requirements • Translate business requirements into detailed functional and technical specifications • Define product features, acceptance criteria, user stories, and business workflows • Analyze large datasets to identify trends, business insights, and optimization opportunities • Work with GCP Data Engineering teams to deliver scalable analytics solutions • Develop business dashboards and executive reports