> Markdown version of [/jobs/ext/2156001-data-integration-analyst-ii-on-site-in](https://www.wearedevelopers.com/jobs/ext/2156001-data-integration-analyst-ii-on-site-in). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Integration Analyst II (On-Site, IN) - **Company:** Allied Llc - **Location:** Carmel, IN, United States (Remote available) - **Experience:** Expert - **Salary:** $101,400.0 - $152,100.0 - **Contract:** Permanent contract - **Skills:** Business Logic, System Configuration, Data Validation, Data Files, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Transformation, Human Resources Information System (HRIS), JSON, Standard Sql, DataOps, Simple Data Format, Extensible Markup Language (XML), Technical Debt, HR Software - **Published:** August 20, 2026 - **Apply:** https://www.careerjet.com/job/us2a62970fe8a4f36be995c337377b4e7e/eaa ## About the Role * Bachelor's degree or equivalent combination of education and experience required. * Bachelor's degree in technical field 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 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. ## Description The Data Integration Analyst II is responsible for leading complex data file transformation efforts, advanced configuration design, and systemic issue resolution for both onboarding and production support environments. This role provides technical guidance to Analyst I team members, supports escalation triage, and contributes to team-wide improvements in quality and process consistency. The position blends deep technical expertise with cross-functional collaboration to ensure reliable, accurate, and scalable client data integrations., Advanced Transformation and Configuration Oversight - 35% * 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. Technical Escalation and Root Cause Analysis - 20% * 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. Client Requirements and Stakeholder Alignment - 20% * 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. Documentation and Standards Leadership - 15% * 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. Process Optimization and Strategic Enablement - 10% * 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., The Senior HRIS Analyst plays a critical role in supporting and optimizing HR technology, serving as an experienced functional and technical resource within the HR Systems team. Th… + 25 days ago ## Related Videos - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Introduction to TXT](https://www.wearedevelopers.com/videos/30-introduction-to-txt) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Implementing continuous delivery in a data processing pipeline](https://www.wearedevelopers.com/videos/73-implementing-continuous-delivery-in-a-data-processing-pipeline) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)