Technical Analyst

Insight Global; Cincinnati (OH); On-site; USD 90,000 - 120,000; Full time

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

Job Description

Insight Global is seeking a Technical Analyst for a top insurance client in the Cincinnati, Ohio area. This candidate will join a Data Integration and Warehouse team supporting new front-end integrations and Production Support issues tied to Business Unit systems and the Enterprise Data Warehouse. The ideal individual will bring a strong blend of technical analysis, business analysis, data integration, and communication skills. They should be comfortable gathering requirements from business stakeholders, understanding backend data flows, troubleshooting technical issues, and creating clear documentation for development teams. This person should be proactive, curious, and confident asking questions, with the ability to connect the dots across business needs, data movement, technical solutions, and developer execution.

Day-to-Day:

• Partner with business units to understand requirements, data needs, and how information flows through systems
• Translate business requirements into concise technical documentation for developers
• Support integrations into the Enterprise Data Warehouse from Business Unit systems
• Troubleshoot Production Support issues tied to front-end integrations, ETL processes, and upstream or downstream data movement
• Read and trace code when needed to identify root causes, without necessarily being hands-on in development
• Collaborate with developers to resolve complex design, development, and data issues
• Work with the business to understand portal usage, policy data, billing data, and how agent or insured-facing UI data flows into backend systems
• Support data movement into Snowflake and upstream reporting or user-facing systems
• Assist with Power BI usage reporting and related data analysis efforts
• Lead or support ETL requirements, ETL design, and Informatica-based architecture discussions
• Conduct impact assessments and size level of effort for larger initiatives
• Help improve SDLC processes, including opportunities to automate deployments, testing, and impact analysis
• Work with product owners and IT sponsors to prioritize work and shape the backlog
• Identify process and technical improvements and help implement them according to team standards

Skills and Requirements

• 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
• Ability to read and understand code well enough to trace issues, troubleshoot, and partner with developers
• Excellent communication skills with the ability to work directly with business stakeholders, developers, and technical teams
• Insurance industry experience
• Informatica experience, especially Informatica PowerCenter
• Snowflake experience
• Azure cloud exposure
• Python experience
• Experience with AI or automation initiatives
• Experience with CXML integration, ETL, and mainframe ingestion

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.