What are the responsibilities and job description for the Solution Architect – Data Migration & Analytics (Insurance) position at Fourways Consulting Services?
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.
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.
Required Experience
- 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
Domain Expertise
- 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.