Need Local Candidate - Snowflake Architect – P&C Insurance domain -Raleigh, NC (Local)

Raleigh, NC, US • Posted 4 days ago • Updated 4 days ago
Contract Independent
Contract Corp To Corp
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

  • Snowflake Architect
  • P&C

Summary

My name is Gopal Gupta, and I am a Staffing Specialist at Galactic Minds. I am reaching out to you on an exciting job opportunity with one of our clients.


Job Title: Snowflake Architect – P&C Insurance domain

Location: Raleigh, NC (Locals preferred )

Type: Fulltime and H1B-T

 

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

  • 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

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91140487
  • Position Id: 2225-26920-
  • Posted 4 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Raleigh, North Carolina

Today

Easy Apply

Full-time, Third Party

Depends on Experience

Raleigh, North Carolina

Today

Easy Apply

Third Party, Contract

Morrisville, North Carolina

Today

Full-time

Remote

10d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs