Data Integration Analyst 1
No salary listed
Entry
Bachelor's
Carmel, IN, USA
In Person
Data & AnalyticsData Engineering
About the job
Requirements
- A bachelor's degree or an equivalent combination of education and experience is required.
- Experience in data mapping, file structure analysis, and transformation logic.
- Familiarity with ETL tools such as Informatica or similar tools.
- Ability to troubleshoot data file ingestion failures and system configuration mismatches.
- Proficiency in written and verbal communication, especially when working with cross-functional teams.
- Ability to understand and edit SQL scripts.
- Experience completing technical projects in a collaborative team setting.
- Experience retrieving and transforming data from CSV, XML, or JSON files.
Responsibilities
- Analyze client file formats to extract data requirements and determine transformation needs.
- Translate business rules and client specifications into detailed source-to-target mapping logic.
- Configure import profiles and lender setup parameters in the system to ensure compatibility.
- Document transformation logic using standardized templates for handoff and reference.
- Perform initial transformation validations to identify formatting or logic inconsistencies.
- Collaborate with Analyst II and ETL developers to review and finalize complex logic components.
- Maintain configuration standards and contribute to improving reusable transformation logic.
- Update and version control mapping documentation as files evolve or rules change.
- Conduct field-level validation of test files to ensure mappings, formats, and values align with system expectations.
- Participate in user acceptance testing and assist with managing test cases and issue tracking.
- Review ingestion results and perform root cause analysis on failures or unexpected outcomes.
- Document validation steps, transformation checks, and test results for future reference.
- Coordinate with QA Analysts to ensure proper sequencing of test scenarios and confirm expected behavior.
- Validate backfeed generation and ensure record integrity across inbound and outbound transformations.
- Track validation progress and escalate blockers to ensure delivery timelines are maintained.
- Participate in post-testing review meetings to document lessons learned and process improvements.
- Perform regression testing after configuration changes to ensure no impact to previous logic.
- Collaborate with Analyst II to validate transformation logic under complex scenarios or overrides.
- Participate in technical onboarding calls to clarify file structures and system mapping requirements.
- Confirm understanding of client data structures and document assumptions or open questions.
- Provide professional, client-facing responses to data questions and transformation status updates.
- Collaborate with Implementation Managers to align onboarding timelines and expectations.
- Clarify system behaviors for custom or complex logic fields and offer alternatives when necessary.
- Help clients interpret system validation feedback and revise file formatting as needed.
- Track communication history and ensure all client logic decisions are documented.
- Maintain technically accurate communication with client and internal teams.
- Review file content with client contacts and confirm transformation design aligns with their expectations.
- Communicate risks or edge cases early in onboarding to manage expectations.
- Troubleshoot ingestion failures by reviewing file content, mapping rules, and transformation logs.
- Respond to helpdesk tickets involving configuration mismatches, invalid data formats, or field logic gaps.
- Coordinate with Production Support to hand off background on non-standard transformation behavior.
- Review system monitoring reports and error queues to detect trends in recurring data problems.
- Update known issues in lender profiles and documentation sites for reference by support teams.
- Validate post-deployment data imports to confirm production alignment with test results.
- Assist with file modifications or transformations as client files evolve post-go-live.
- Escalate persistent issues to Analyst II or QA with documented troubleshooting history.
- Monitor ingestion health and performance post-launch to detect degradation or latency.
- Document resolution steps and lessons learned from post-implementation support events.
- Maintain lender-specific documentation for mapping logic, transformation details, and exception handling.
- Ensure consistency and completeness in internal documentation repositories.
- Contribute to internal process documents including configuration walkthroughs and intake guides.
- Share newly discovered issues and edge cases through team channels or update logs.
- Participate in team review of standard procedures and propose updates when gaps are identified.
- Assist in developing and maintaining standardized templates and review checklists.
- Provide documentation feedback based on implementation experience to improve clarity and usability.
- Support onboarding of new team members by sharing reference documents and leading walkthroughs.
- Document variations in configuration for lenders with custom logic to ensure long-term clarity.
- Collaborate with QA and other analysts to ensure documentation accurately reflects validated behavior.
Desired Qualifications
- A bachelor's degree in a technical field is preferred.
About the company
Allied Solutions provides insurance, lending, risk management, and data-driven products to financial institutions across North America. It delivers turnkey, tech-enabled solutions such as collateral insurance tracking, lender-placed insurance, credit insurance, debt protection, and portfolio management, supported by data integration to streamline service delivery. The company differentiates itself as an independent subsidiary of Securian with a focus on customized, industry-specific support for more than 6,000 banks and credit unions. Its goal is to help financial institutions manage risk, grow lending, and protect consumers through integrated, data-driven insurance and lending solutions.
Company Size
1,001-5,000
Company Stage
N/A
Total Funding
N/A
Headquarters
Carmel, Indiana
Founded
1978
Get referred to Allied Solutions
See people who can refer or advise you
Simplify's Take
What believers are saying
- March 26, 2026 Loquat partnership expands digital onboarding and lending across Allied's network.
- October 20, 2025 TecAssured investment deepens Allied's auto, RV, and powersports ecosystem.
- September 1, 2026 leadership promotions signal continued growth and internal execution momentum.
What critics are saying
- Loan origination platforms and core processors can bundle Allied's workflow by 2027.
- LPI and collateral tracking face price pressure from embedded fintech competitors like Loquat.
- Any servicing-system migration failure could disrupt 6,000 clients and damage renewals immediately.
What makes Allied Solutions unique
- Allied Solutions serves 6,000+ financial institutions with insurance, lending, and risk products.
- Unitrac gives lenders real-time insurance tracking, EDI workflows, and compliant portfolio dashboards.
- Securian Financial ownership supplies capital, distribution stability, and credibility with conservative banks.
Help us improve and share your feedback! Did you find this helpful?
Benefits
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Disability Insurance
- 401(k) Retirement Plan
- 401(k) Company Match
- Paid Vacation
- Paid Sick Leave
- Paid Holidays
- PTO/vacation
- Flexible Work Hours