Data Integration Advisor

Job Title: Data Integration Advisor
Type: Contract to hire
Industry: Insurance
Location: Remote USA (28 pre-approved states). Raleigh, NC preferred


Overview
Our client is seeking a Data Integration Advisor to join a collaborative, cross-functional team responsible for translating business needs into data-driven solutions. This role blends technical data expertise with business analysis, requiring strong analytical thinking, stakeholder engagement, and data profiling capabilities.
The ideal candidate will be comfortable working across teams—including business stakeholders, product support, and data engineering—to ensure accurate, efficient, and actionable data solutions.

Key Responsibilities

• Gather, analyze, and document business and data requirements from stakeholders across multiple functional areas
• Perform data analysis and data profiling to ensure data quality, integrity, and usability
• Translate business requirements into detailed specifications for data engineers and technical teams
• Write and optimize complex SQL queries (Snowflake environment) to support analysis and validation
• Collaborate with cross-functional teams including:
  • Business stakeholders with varying technical expertise
  • Data engineers responsible for coding and integration
  • Product support teams
• Coordinate across multiple initiatives, effectively managing and prioritizing concurrent projects
• Identify and troubleshoot data issues, working through problems at both a high-level and granular level
• Communicate findings, insights, and solutions clearly through strong written and verbal communication
• Work with internal teams and external vendors, adapting to different systems and processes

• 3+ years of experience in data analysis, data integration, or similar analytical role
• Strong proficiency in SQL (experience with Snowflake preferred; Teradata experience a plus)
• Proven ability to perform data analysis, profiling, and validation
• Experience translating business requirements into technical solutions
• Ability to manage multiple tasks/projects and balance competing priorities
• Strong communication skills with the ability to interact with both technical and non-technical stakeholders
• Demonstrated problem-solving mindset with attention to detail

• Experience in healthcare, insurance, or financial services environments
• Actuarial experience is a major plus
• Prior experience working with data integration or data engineering teams
• Experience working with external vendors or third-party partners
• Background as a programmer analyst or hybrid technical/analytical role