Data Integration Analyst I

Responsibilities

• 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.
• Data Transformation and Configuration Setup
• File Validation and Testing
• Client Communication and Onboarding Support
• Production Support and Issue Resolution
• Documentation and Process Improvement

Skills

• 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

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