Apply on Employer Site

Allied Solutions LLC · 3 weeks ago

Data Integration Analyst II (On-Site, IN)

Carmel, IN

Full-time

Onsite

Entry, Mid Level

1+ years exp

Allied Solutions LLC is a company focused on providing data integration services. The Data Integration Analyst II is responsible for leading complex data file transformation efforts, providing technical guidance, and ensuring reliable client data integrations through collaboration and problem-solving.

Financial ServicesInformation Technology

H1B Sponsor Likely

Responsibilities

Lead the design and execution of transformation logic for complex and high-volume client data integrations

Translate contractual requirements and business rules into executable data mapping specifications

Optimize transformation parameters for accuracy, performance, and long-term maintainability

Validate source-to-target logic against field-level expectations and downstream workflows

Create and enforce configuration consistency across import profiles and lender setups

Resolve complex field dependencies and cross-file transformation conditions

Ensure mapping scalability for clients with dynamic structures or multi-branch delivery

Serve as a point of contact for internal reviews of logic decisions and data transformation strategy

Conduct detailed mapping audits to identify inconsistencies or potential configuration gaps

Maintain transformation documentation that reflects current standards and applied logic

Triage escalated technical issues involving ingestion failures, transformation mismatches, and system behavior gaps

Lead multi-layer investigation efforts that cross system configuration, transformation, and compliance logic

Partner with ETL developers and QA to analyze performance anomalies or transformation bugs

Document root causes, contributing conditions, and recommended solutions for team reference

Communicate findings and fixes with affected stakeholders and ensure downstream alignment

Identify patterns in escalated issues and propose structural improvements to reduce recurrence

Review logs, system behavior, and transformation rules for high-impact data discrepancies

Coordinate escalation resolution across Implementation, QA, Development, and Support teams

Lead retrospectives on recurring support themes to surface proactive fixes

Track escalation frequency and response metrics to recommend prioritization of fixes

Lead conversations with clients to confirm technical expectations, logic plans, and configuration assumptions

Gather input from internal stakeholders and translate into aligned data requirements and execution steps

Review service agreements and ensure logic reflects contract-specific language and compliance terms

Manage documentation of exceptions, overrides, and client-specific logic into intake records and configs

Serve as the primary analyst interface for client data validation and business logic clarification

Ensure stakeholders are aware of key constraints or special conditions that affect configuration design

Maintain alignment with Coordinators, Implementation Managers, and QA to ensure clarity on technical deliverables

Confirm configuration intent with Production Support and Data Operations for long-term viability

Participate in approval cycles for requirements and mapping validation

Escalate misaligned business expectations early in the implementation process

Own creation of reusable documentation templates and technical reference guides

Maintain configuration records that track field mappings, overrides, and transformation rules

Create troubleshooting and root cause analysis templates for issue documentation

Drive improvements in the clarity, accuracy, and completeness of internal documentation

Participate in peer review cycles for logic documentation and mapping alignment

Create team-facing material on complex configuration use cases and system limitations

Ensure documentation supports both implementation accuracy and production support visibility

Collaborate with QA and Compliance to align documentation with review checkpoints and validation processes

Manage documentation updates in response to system changes or new client onboarding workflows

Contribute technical content to team training resources and onboarding programs

Identify inefficiencies in transformation workflows and propose process automation opportunities

Partner with cross-functional teams to align on standardization of configuration rules and mapping templates

Support internal training efforts by documenting newly developed configuration techniques or lessons learned

Recommend updates to intake process, testing cadence, and peer review approaches

Participate in strategic planning initiatives for tooling, transformation platform improvements, or release process enhancements

Contribute to retrospectives and pilot projects to refine the analyst experience and increase delivery accuracy

Lead discussion of system design constraints during high-impact transformation projects

Help prioritize technical debt and tooling limitations based on analyst perspective and configuration feedback

Support development and QA in the rollout of new tools or enhancements to transformation components

Collaborate on metrics tracking and reporting related to configuration accuracy, rework reduction, and team efficiency

Qualification

SQLETL platformsData integrationFile formatsTransformation logicAnalytical skillsDocumentation skillsCommunication skillsMentoring

Required

Bachelor's degree or equivalent combination of education and experience required

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 and transformation logic (CSV, fixed-width, XML, JSON)

Experience troubleshooting ingestion failures and system setup conflicts

Excellent documentation and communication skills, especially with cross-functional partners

Highly analytical, adaptable, and able to manage multiple high-impact issues concurrently

Ability to mentor peers and explain technical concepts and procedures to new team members

Preferred

Bachelor's degree in technical field preferred

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

Company

Allied Solutions LLC

Allied Solutions uses technology based products and services to meet the insurance, lending and marketing needs of more than 6,000 financial institutions in North America.

Founded in 2000

Carmel, Indiana, USA

1001-5000 employees

http://www.alliedsolutions.net/

H1B Sponsorship

Allied Solutions LLC has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2)

2023 (2)

2022 (1)

2021 (1)