What are the responsibilities and job description for the Solution Architect - Data Migration & Analytics (Insurance domain) position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Acunor Infotech, is seeking the following. Apply via Dice today!
Job Title: Solution Architect Data Migration & Analytics (Insurance)
Location: Raleigh, NC (Locals preferred as they need to go to office when required)
Job Description :
Role Summary
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
Job Title: Solution Architect Data Migration & Analytics (Insurance)
Location: Raleigh, NC (Locals preferred as they need to go to office when required)
Job Description :
Role Summary
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.
- 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.
- Lead report rationalization and consolidation initiative.
- Design Power BI semantic layer and standardize KPIs.
- Eliminate redundant reports and enable unified, business-friendly dashboards.
- Establish data governance, lineage, and metadata standards.
- Ensure compliance with insurance regulatory and audit requirements.
- Define quality KPIs and monitoring frameworks.
- 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.
- 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 / Google Cloud Platform)
- Knowledge of Cortex AI is a plus
- Insurance domain experience (P&C preferred)
- Understanding of policy, claims, billing, and customer data models