Data Integration & Transformation Analyst I

Allied Solutions, LLC; United States; On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

401k with company match

3 weeks PTO

Life and disability insurance

Job summary

Allied Solutions in the United States is seeking a Data Integration Analyst I to support transformation, configuration, and ingestion of client data within its insurance-tracking systems. You will translate client requirements into technical specs, build transformation logic, and help ensure production-ready data delivery.

Join a collaborative team to validate data mappings, assist with onboarding calls, document configurations, and troubleshoot ingestion issues post-go-live.

Qualifications

• Experience in data mapping and file structure analysis.
• Familiarity with ETL tools such as Informatica.
• Ability to edit SQL scripts and troubleshoot data ingestion.

Responsibilities

• Data Transformation and Configuration Setup – translate requirements into mapping logic and configure import profiles.
• File Validation and Testing – validate mappings and participate in UAT and testing.
• Client Communication and Onboarding Support – participate in onboarding calls and document decisions.
• Production Support and Issue Resolution – troubleshoot ingestion failures and monitor data health.

Skills

Data mapping

ETL knowledge

SQL scripting

Informatica

Problem solving

Education

Bachelor’s degree (or equivalent)

Tools

Informatica

Job description

Allied Solutions in the United States is seeking a Data Integration Analyst I to support transformation, configuration, and ingestion of client data within its insurance-tracking systems. You will translate client requirements into technical specs, build transformation logic, and help ensure production-ready data delivery.

Join a collaborative team to validate data mappings, assist with onboarding calls, document configurations, and troubleshoot ingestion issues post-go-live.