Data Integration Analyst I: Transform & Validate Client Data

Alliedsolutions; Town of Carmel (NY); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

100% company-paid life and disability

401k with company match

Three weeks PTO

Job summary

Alliedsolutions is seeking a data transformation analyst to support ETL development and client onboarding. You will analyze client file formats, translate business rules into mapping logic, and configure import profiles and lender setup parameters.

You will document transformation steps, collaborate with analysts and developers, and maintain versioned documentation to ensure accuracy across evolving datasets.

Qualifications

• Experience in data mapping, file structure analysis, and transformation logic.
• Ability to troubleshoot data file ingestion failures and system configuration mismatches.
• Proficient in written and verbal communication, especially with cross-functional teams.
• Organized, detail-oriented, and able to manage multiple tasks independently.
• Experience retrieving and transforming data from CSV, XML, or JSON files.

Responsibilities

• Analyze client file formats to determine transformation needs.
• Translate business rules into source-to-target mapping logic.
• Configure import profiles and lender setup parameters.
• Document transformation logic using standardized templates.
• Collaborate with Analyst II and ETL developers on complex logic components.
• Maintain configuration standards and mapping documentation.
• Version control mapping documentation as files evolve.

Skills

Data mapping

Transformation logic

SQL scripting

Written and verbal communication

Attention to detail

CSV/XML/JSON data handling

Education

Bachelor’s degree or equivalent

Bachelor’s degree in technical field preferred

Tools

Informatica or similar ETL tools

Job description

Alliedsolutions is seeking a data transformation analyst to support ETL development and client onboarding. You will analyze client file formats, translate business rules into mapping logic, and configure import profiles and lender setup parameters.

You will document transformation steps, collaborate with analysts and developers, and maintain versioned documentation to ensure accuracy across evolving datasets.