Data Integration Analyst I (On-Site, IN)

Allied Solutions LLC • Carmel, IN

23h • Onsite

About The Position

The Data Integration Analyst I is responsible for supporting the transformation, configuration, and ingestion of client data files within Allied's insurance tracking systems. This includes translating client requirements into technical specifications, building and maintaining transformation logic, and assisting with validation and troubleshooting. The role contributes to both the initial implementation and ongoing maintenance of lender data configurations and helps ensure accurate, timely, and production-ready data delivery.

Requirements

• Bachelor’s degree or equivalent combination of education and experience required.
• 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 system configuration mismatches.
• Proficient in written and verbal communication, especially when working with cross-functional teams.
• Organized, detail-oriented, and able to manage multiple tasks independently.
• Ability to understand and edit SQL scripts.
• Experience in completing technical projects in a collaborative team setting.
• Experience with retrieving and transforming data from CSV, XML, or JSON files.

Nice To Haves

• Bachelor’s degree in technical field preferred.

Responsibilities

• Data Transformation and Configuration Setup – 30%
• File Validation and Testing – 25%
• Client Communication and Onboarding Support – 20%
• Production Support and Issue Resolution – 15%
• Documentation and Process Improvement – 10%

Benefits

• medical, dental and vision insurance coverage
• 100% company-paid life and disability coverage
• 401k options with company match
• three weeks PTO by the end of the first year

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Number of Employees: 1,001-5,000 employees