Data Integration Analyst I - Transform & Validate Data

Allied Solutions, LLC; Carmel (IN); On-site; USD 55,000 - 75,000; Full time

Job summary

Allied Solutions, LLC in Carmel, IN seeks a Data Integration Analyst I to support transformation, configuration, and ingestion of client data files within our insurance tracking systems. You will translate client requirements into technical specifications and help implement and maintain lender data configurations for timely, production-ready data delivery.

The role involves validating mappings, collaborating with ETL developers, participating in onboarding calls with clients, and providing

Qualifications

• Bachelor’s degree or equivalent in a technical field.
• Experience in data mapping, file structure analysis, and transformation logic.
• Proficient with ETL tools (Informatica or similar) and SQL scripting.

Responsibilities

• Analyze client file formats to determine transformation needs.
• Translate business rules into source-to-target mappings.
• Configure import profiles and lender setup parameters.
• Validate and document transformation logic and mappings.
• Collaborate with Analysts and ETL developers on complex logic.
• Perform regression and revalidation after configuration changes.

Skills

Data mapping

File structure analysis

Transformation logic

ETL tools (Informatica)

SQL scripting

Communication skills

Project collaboration

Education

Bachelor’s degree in technical field

Tools

Informatica

SQL IDEs

Job description

Allied Solutions, LLC in Carmel, IN seeks a Data Integration Analyst I to support transformation, configuration, and ingestion of client data files within our insurance tracking systems. You will translate client requirements into technical specifications and help implement and maintain lender data configurations for timely, production-ready data delivery.

The role involves validating mappings, collaborating with ETL developers, participating in onboarding calls with clients, and providing