Data Migration Solution Architect

Solution IT Inc. is looking for Data Migration Solution Architect for one of its clients Raleigh, NC

Job Title: Data Migration Solution Architect

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.

Required Skills:

• 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

Work Site: Raleigh, NC

Duration: 6 Months

Expected Start Date: Immediate - 2 weeks

Number of Positions: 01

Please send your responses back to

Thanks

Recruiting Team

SOLUTION IT INC

Work: / Extn 139 / 145 / 155

URL:
Confidentiality Notice: The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient(s), be advised that the unauthorized use, disclosure, copying, distribution, or the taking of any action in reliance on this information is strictly prohibited. If you have received this e-mail in error, please immediately contact the sender by reply email and destroy all copies of the original message. Thank you.

Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered as "spam" as long as we include contact information and a remove link for removal from our mailing list. In order to not be in the recipients-list for this mail, please reply to us with "REMOVE" either in the subject or in the mail body. Please include all pertinent email addresses. Our apologies for any inconveniences caused by this mail.

to remove from our mailing list.
Solution IT, Inc, 60E Concord St, Wilmington, MA 01887 Phone: Fax: