Solution Architect – Data Migration & Analytics (Insurance)
Fourways Consulting Services
Dice Job Match Score™
🤯 Applying directly to the forehead...
Job Details
Skills
- Business Data
- Good Clinical Practice
- Google Cloud Platform
- Guidewire
- Insurance
- Data Modeling
- Data Quality
- Data Warehouse
- Design Review
- Leadership
- Data Engineering
- Data Governance
- Data Mapping
- Data Migration
- Business-IT Alignment
- Cloud Computing
- Dashboard
- Data Architecture
- Amazon Web Services
- Analytics
- Artificial Intelligence
- Microsoft Azure
- Auditing
- ELT
- KPI
- Meta-data Management
- Microsoft Power BI
- Billing
- Migration
- Recruiting
- Regulatory Compliance
- Reporting
- Semantics
- Snow Flake Schema
- Unstructured Data
Summary
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.
- Dice Id: 91170808
- Position Id: 9006802
- Posted 1 day ago
Company Info
At Fourways Consulting LLC, we are more than just a recruitment and consulting firm — we are a trusted partner in transformation, dedicated to empowering organizations across industries to achieve operational excellence and build high-performing teams.
Founded by a group of seasoned professionals and visionary leaders, Fourways brings a wealth of industry insight, strategic foresight, and deep domain expertise in IT, healthcare recruitment, and software consulting services. With years of hands-on experience in global talent acquisition and business process optimization, we understand what it takes to drive meaningful and measurable results.
Our mission is rooted in a clear vision: to support organizations in identifying the right talent, aligning operations with strategic goals, and adapting to evolving market demands. By integrating advanced tools, data-driven strategies, and a human-centered approach, we help clients overcome complex challenges and stay ahead in today’s competitive landscape.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs