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.

• 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

• 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

• 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