Data Integration & Transformation Analyst I

Allied Solutions; Carmel (IN); On-site; USD 65,000 - 90,000; Full time

Job summary

Allied Solutions in Carmel, Indiana is seeking a Data Integration Analyst I to support transformation, configuration, and ingestion of client data in our insurance tracking systems. You will translate client requirements into technical specs, build transformation logic, and assist with validation to ensure timely, production-ready data delivery.

You will collaborate with Analysts II and ETL developers to review complex logic, document mappings, perform validations and UAT, and support onboarding

Qualifications

• Bachelor’s degree in a technical field or equivalent experience.
• Experience in data mapping, file structure analysis, and transformation logic.
• Familiarity with ETL tools (Informatica or similar).
• Ability to troubleshoot data file ingestion failures and configuration mismatches.
• Strong communication and cross-functional collaboration.
• Ability to understand and edit SQL scripts.
• Experience with CSV, XML, or JSON data transformations.

Responsibilities

• Analyze client file formats to extract data requirements and determine transformation needs.
• Configure import profiles and lender setup parameters in the system.
• Document transformation logic using standardized templates.
• Perform initial validation and assist with UAT and testing.
• Collaborate with Analysts II and ETL developers on complex logic.
• Maintain mapping documentation and version control.

Skills

Data mapping

File structure analysis

Transformation logic

ETL tools (Informatica)

SQL scripting

CSV/XML/JSON handling

Troubleshooting

Education

Bachelor’s degree or equivalent

Tools

Informatica

Job description

Allied Solutions in Carmel, Indiana is seeking a Data Integration Analyst I to support transformation, configuration, and ingestion of client data in our insurance tracking systems. You will translate client requirements into technical specs, build transformation logic, and assist with validation to ensure timely, production-ready data delivery.

You will collaborate with Analysts II and ETL developers to review complex logic, document mappings, perform validations and UAT, and support onboarding