Data Integration Lead: ETL & Transformation Architect

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

Benefits offered by this job

Medical, dental and vision insurance

401(k) with company match

Paid time off

Job summary

Allied Solutions LLC is seeking a Data Integration Analyst II to lead complex data transformation and configuration efforts for onboarding and production support. The role provides technical guidance to junior analysts and collaborates across Implementation, QA, and Support teams to ensure reliable, scalable client data integrations.

The ideal candidate brings 1–2 years in data integration or ETL, strong SQL skills, and experience with Informatica.

Qualifications

• Bachelor’s degree or equivalent combination of education and experience.
• Bachelor’s degree in a technical field is preferred.
• 1–2 years of experience in data integration, ETL development, or system configuration.
• Proficient in SQL and ETL platforms (Informatica preferred).
• Strong understanding of file formats (CSV, fixed-width, XML, JSON).
• Experience troubleshooting ingestion failures and system setup conflicts.
• Excellent documentation and communication skills across cross-functional partners.

Responsibilities

• Lead transformation design and execution for complex, high-volume data integrations.
• Translate business rules into executable data mappings and configurations.
• Optimize transformation parameters for accuracy and performance.
• Validate source-to-target logic and ensure downstream alignment.
• Document and enforce configuration consistency across profiles and lenders.
• Triage escalated ingestion and transformation issues across environments.
• Collaborate with ETL developers and QA to analyze performance and bugs.
• Mentor junior analysts and share knowledge with the team.
• Lead process improvements to reduce recurrence and improve data quality.
• Partner with stakeholders to ensure contracts and logic reflect requirements.

Skills

SQL

ETL concepts

Data integration

Mentoring peers

Cross-functional collaboration

Education

Bachelor’s degree or equivalent

Bachelor’s degree in technical field preferred

Tools

Informatica

Job description

Allied Solutions LLC is seeking a Data Integration Analyst II to lead complex data transformation and configuration efforts for onboarding and production support. The role provides technical guidance to junior analysts and collaborates across Implementation, QA, and Support teams to ensure reliable, scalable client data integrations.

The ideal candidate brings 1–2 years in data integration or ETL, strong SQL skills, and experience with Informatica.