Data Integration Analyst for Insurance & Data Warehouse

Insight Global

Cincinnati (OH)

On-site

USD 90,000 - 120,000

Full time

14 days+
Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Insight Global is seeking a Technical Analyst to join our Data Integration and Warehouse team in the Cincinnati, Ohio area. The role focuses on gathering requirements from business stakeholders, translating them into technical specs for developers, and supporting ETL and data movement into Snowflake and related reporting systems.

The ideal candidate brings experience in data integration, data warehousing, and Informatica PowerCenter, with strong SQL skills and comfortable collaborating with

Qualifications

  • 5+ years of experience as a Systems Analyst, Technical Analyst, or similar role within data.
  • Experience gathering business requirements and translating them into clear technical requirements for development teams.
  • Strong experience with Data Warehousing, Data Integration, and Data Mapping.
  • Proficiency with SQL and relational database tools, including SSMS.

Responsibilities

  • Partner with business units to understand requirements and data needs.
  • Translate business requirements into technical documentation for developers.
  • Support integrations into the Enterprise Data Warehouse from Business Unit systems.
  • Troubleshoot Production Support issues tied to front-end integrations and ETL processes.
  • Read and trace code to identify root causes and work with developers.

Skills

SQL
Python
Informatica PowerCenter
Snowflake
Azure Cloud
Data Integration
Data Warehousing
Communication

Tools

SSMS
Power BI
ETL Tools
CXML integration

Job description

Insight Global is seeking a Technical Analyst to join our Data Integration and Warehouse team in the Cincinnati, Ohio area. The role focuses on gathering requirements from business stakeholders, translating them into technical specs for developers, and supporting ETL and data movement into Snowflake and related reporting systems.

The ideal candidate brings experience in data integration, data warehousing, and Informatica PowerCenter, with strong SQL skills and comfortable collaborating with

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Technical Analyst
Technical Analyst

Insight Global • Cincinnati (OH)

On-site
USD 90,000 - 120,000
Data Integration & Transformation Analyst I
Data Integration & Transformation Analyst I

Allied Solutions • Carmel (IN)

On-site
USD 65,000 - 90,000
Senior Data Integration Engineer
Senior Data Integration Engineer

Insight Global • Cincinnati (OH)

On-site
USD 110,000 - 150,000
Senior Data Validation & Quality Engineer
Senior Data Validation & Quality Engineer

Insight Global • Cincinnati (OH)

On-site
USD 110,000 - 150,000
Data Integration & Transformation Analyst I
Data Integration & Transformation Analyst I

Allied Solutions, LLC • United States

On-site
USD 65,000 - 95,000
Medical, dental and vision insurance
401k with company match
3 weeks PTO
+1
Data Warehouse & IDMC Engineer - Snowflake & ETL
Data Warehouse & IDMC Engineer - Snowflake & ETL

Pointwest-North America • Town of Florida (NY)

On-site
USD 100,000 - 130,000
Data Integration Analyst I: Transform & Validate Client Data
Data Integration Analyst I: Transform & Validate Client Data

Allied Solutions LLC • Carmel (IN)

On-site
USD 60,000 - 80,000
Medical, dental and vision insurance
Company-paid life and disability
401k with company match
+2
Data Integration Architect: Scalable ETL & Data Flows
Data Integration Architect: Scalable ETL & Data Flows

Insight Global • Milwaukee (WI)

On-site
USD 90,000 - 100,000
Senior Data Engineer: Snowflake & Informatica Expert
Senior Data Engineer: Snowflake & Informatica Expert

Digerati Systems Inc. • Austin (TX)

On-site
USD 120,000 - 180,000
Data Warehouse Analyst
Data Warehouse Analyst

Pointwest-North America • Town of Florida (NY)

On-site
USD 100,000 - 130,000