Data Integration Analyst I

Allied Solutions, LLC

Carmel, IN

# Data Integration Analyst IApply: Onsite: Carmel, IN: Full time: Posted Yesterday: R-011112The Data Integration Analyst I is responsible for supporting the transformation, configuration, and ingestion of client data files within Allied's insurance tracking systems. This includes translating client requirements into technical specifications, building and maintaining transformation logic, and assisting with validation and troubleshooting. The role contributes to both the initial implementation and ongoing maintenance of lender data configurations and helps ensure accurate, timely, and production-ready data delivery.## Job Duties and Responsibilities:Data Transformation and Configuration Setup – 30%* 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 catch 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.File Validation and Testing – 25%* Conduct field-level validation of test files to ensure mappings, formats, and values align with system expectations.* Participate in user acceptance testing (UAT) 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.Client Communication and Onboarding Support – 20%* 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 consistent, technically accurate communication with both 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 ensure expectations are managed.Production Support and Issue Resolution – 15%* 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.Documentation and Process Improvement – 10%* 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 the development and maintenance of 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.## Qualifications (Education, Experience, Certifications & KSA):* Bachelor’s degree or equivalent combination of education and experience required.* Bachelor’s degree in technical field preferred.* Experience in data mapping, file structure analysis, and transformation logic.* Familiarity with ETL tools (Informatica or similar).* Ability to troubleshoot data file ingestion failures and system configuration mismatches.* Proficient in written and verbal communication, especially when working with cross-functional teams.* Organized, detail-oriented, and able to manage multiple tasks independently.* Ability to understand and edit SQL scripts.* Experience in completing technical projects in a collaborative team setting.* Experience with retrieving and transforming data from CSV, XML, or JSON files.*The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with a job.*
J-18808-Ljbffr Allied Solutions, LLC

Apply

Vacancy posted 11 hours ago

Similar jobs that could be interesting for youBased on the Data Integration Analyst I in Carmel, IN vacancy

Data Integration Analyst I
The Data Integration Analyst I is responsible for supporting the transformation, configuration, and ingestion of client data files within Allied's insurance tracking systems. This includes translating client requirements into technical specifications, building and maintaining...
Suggested
Full time
Allied Solutions
Carmel, IN
1 day ago
Facility Coding Quality Integrity Analyst - Inpatient
$35.5 - $53.25 per hour
Department: 13244 Enterprise Revenue Cycle - Integrity Operations: Facility Coding Quality Status: Full time Benefits Eligible: Yes... ...and supporting corrective actions. Analyze coding quality data and audit results to identify trends, risks, and opportunities...
Suggested
Daily paid
Full time
Temporary work
Part time
Work at office
Remote work
Monday to Friday
Flexible hours
Shift work
Day shift
Advocate Health
Indianapolis, IN
1 day ago
Business Data Analyst - Transact system(GL)
...Req ID: 378891 NTT DATA strives to hire exceptional, innovative and passionate individuals... ...are currently seeking a Business Data Analyst - Transact system(GL) to join our team... ..., etc for a Core Banking System and its integration with the Data Warehouse Shall be able...
Suggested
Work at office
Remote work
Flexible hours
NTT DATA, Inc.
Indianapolis, IN
3 days ago
Data Analyst III, MedEcon
...Position Purpose: Analyze integrated and extensive datasets to extract value, which directly... ...to independently write queries, pull data, and work through complex analytical requests... ...Provide technical guidance to junior analysts. Education/Experience: ~ Bachelor...
Suggested
Full time
Part time
H1b
Work at office
Remote work
Flexible hours
Centene Corporation
Indianapolis, IN
1 day ago
Data & Reporting Analyst II
...GLOBAL SOLUTIONS, LLC in Indianapolis is looking for an Analyst II to provide mid-level analytical, data management, and operational support. The ideal... ..., supporting program evaluations, and ensuring data integrity. A Bachelor's degree and 3-5 years of analytical experience...
Suggested
CLEAR GLOBAL SOLUTIONS, LLC
Indianapolis, IN
2 days ago
Data Analyst
$30 - $35 per hour
...INDIANAPOLIS, IN) CANDIDATE MUST LIVE IN INDIANA Job Summary: The Data Analyst is responsible for collecting, processing, and analyzing data... ...teams and other analysts and stakeholders to ensure data integrity. Perform data analysis to identify trends, patterns, and...
Contract work
Live in
Ventures Unlimited Inc
Indianapolis, IN
2 days ago
Data Analyst
Job Title: Data Analyst Location: Indianapolis, Indiana (4 days/week required) Industry: Energy / Utilities JOB DESCRIPTION Theoris is assisting our client with a search for a Data Analyst to support implementation of newly approved capacity market reform impacting generation...
Hourly pay
Local area
Relocation
neteffects
Carmel, IN
2 days ago
Data Analyst
...Indianapolis office. Responsibilities Lead or be a member of a team of analysts that apply process improvement, reengineering, modernization,... ...between multiple project teams to ensure enterprise‑wide integration of reengineering efforts. Facilitate meetings to assist...
Full time
Work at office
Vetrics Group
Indianapolis, IN
1 day ago
Data Analyst
$70k
Contract-to-hire Data Analyst position in Indianapolis, IN (onsite) focused on preparing large datasets and building reliable reporting... ...datasets into internal systems while maintaining accuracy and data integrity Write and maintain scripts that streamline recurring data...
Contract work
Beacon Hill Staffing Group
Indianapolis, IN
2 days ago
Junior Data Analyst
...client of ours out of the Midwest is looking to add a Junior Data Analyst / SQL Developer to their team to support database operations,... ..., understanding data relationships, and troubleshooting data integrity issues. This individual will play an important role in reviewing...
Contract work
Remote work
Lucid Services Group
Indianapolis, IN
6 days ago
Data Operations Analyst
$53.22k
...citizens to our communities and inspire a culture of accountability, integrity, and professionalism. To learn more about Indiana Department of Correction, click here. Role Overview As the Data Operations Analyst, you will be an integral part in implementing and developing...
Full time
Work experience placement
Work at office
IN Auditor of State
Indianapolis, IN
4 days ago
Sr. Data Governance Analyst
...Bellevue, PA0738 Processing CenterJob DescriptionA Senior Data Governance Analyst is a key member of the Data Governance Program at Northwest... ...Analyst will manage the flow of data for Northwest, ensuring its integrity, efficiency, and availability, and that appropriate...
Full time
Work experience placement
Casual work
Work at office
Shift work
Northwest Bank
Fishers, IN
1 day ago
Cyber Data Privacy Specialist - Senior Consultant
$105.4k - $207.8k
...technology solutions that help organizations address regulatory requirements, strengthen data governance, and enable trusted business outcomes. You will contribute across configuration, integration, testing, and deployment activities while working with client, vendor, and cross...
Local area
Deloitte
Indianapolis, IN
3 days ago
HB Coding Strategic Data Analyst (Remote - Must reside in IL, IN, IA, MO, or WI)
...what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportunity to join our... ...quest for better? Job Description The HB Coding Strategic Data Analyst role exists to transform complex coding into actionable insights...
Hourly pay
Work at office
Local area
Remote work
Relocation package
Shift work
Northwestern Memorial Healthcare
Indianapolis, IN
3 days ago
Data Engineer
...Data Engineer Our business technology team is enhancing its data engineering capabilities with focus in financial services data... ...who will design, build, and maintain scalable data pipelines, integrations, and Lakehouse architectures utilizing Python, Microsoft Fabric...
Merchants Bancorp
Carmel, IN
3 days ago
Data Analyst
$28 per hour
...Associate Data Analyst (Elevate Program) Location: Indianapolis, IN Pay: $28/hr. (starting pay) Employment Type: Long-Term Contract Work Arrangement: Hybrid (Onsite 3 Days per Week) About Brooksource Elevate Brooksource Elevate is an early-career development...
Long term contract
Permanent employment
Contract work
Internship
Local area
3 days per week
Brooksource
Indianapolis, IN
1 day ago
Data Engineer
...Data Engineer CleanSlate Technology Group (CSTG) is a modern technology consulting firm transforming how organizations use Data... ...analytics, machine learning, and AI workloads. Implement data integration, transformation, and orchestration solutions using established...
CleanSlate Technology Group
Carmel, IN
20 hours ago
Data Analyst - State Healthcare Programs
...At CSpring, we believe in the power of data to drive decisions and real-world impact.... ...consistently, and guide wisely. We partner with integrity, curiosity, and heart. What You’ll Do You’ll work with business users, analysts and data engineers to design and deliver...
CSpring
Indianapolis, IN
13 days ago
Senior QA/QC Data Analyst with AI/ML testing
...Req ID: 381528 NTT DATA strives to hire exceptional, innovative and passionate individuals... ...currently seeking a Senior QA/QC Data Analyst with AI/ML testing to join our team in... ...consistency, validity, timeliness, uniqueness, and integrity. • Establish quality criteria for data...
Work experience placement
Work at office
Remote work
Flexible hours
NTT DATA, Inc.
Indianapolis, IN
3 days ago
Data Analyst-Healthcare Practice
...Job Description Job Description Data Analyst Blue & Co., LLC is an independent advisory and accounting firm providing tax,... ...understanding of dimensional modeling , ETL/ELT concepts, and data integration. Data Platforms: Exposure to Microsoft Fabric and/or...
Contract work
Blue and Company
Indianapolis, IN
7 days ago
Data Quality Analyst
$50 - $55 per hour
...- $55.00/hr Direct message the job poster from Acro Service Corp **** Local Candidate in Indianapolis only****** Senior Data Quality Analyst The Senior Data Quality Analyst supports the accuracy, completeness, and timeliness of immunization information systems (IIS...
Contract work
Local area
Acro Service Corp
Indianapolis, IN
2 days ago
Co-Op, Research Engineering and AI Integration
$20 - $60 per hour
...will be a key contributor to the Research team, focusing on the integration and application of novel technologies that enhance our... ...Control Notice This position may involve access to technology or data that is subject to U.S. export control laws, including the Export...
Permanent employment
Full time
Summer work
Internship
Work at office
Moderna
Indianapolis, IN
11 hours ago
Data Engineer
...This is an exciting opportunity to build and enhance cloud-based data platforms, backend services, and AI-enabled applications that... ...expertise to create reliable data pipelines, scalable APIs, and integrated analytics capabilities using modern Azure technologies. \n...
Agility Partners
Carmel, IN
9 days ago
Senior Data Quality Analyst
...Senior Data Quality Analyst The Senior Data Quality Analyst supports the accuracy, completeness, and timeliness of immunization information systems (IIS). This role ensures that data submitted by healthcare providers is validated, standardized, and transformed into...
GlobalPoint
Indianapolis, IN
3 days ago
Senior Healthcare Data Analyst
$106.52k - $157.27k
...First (Days) Overview: Sentara is hiring a Senior Healthcare Data Analyst! This position is fully remote. Overview The Senior... ...and technical teams, this role helps ensure data is properly integrated, transformed, validated, and delivered within the enterprise...
Full time
Temporary work
Remote work
Shift work
Sentara Health
Indianapolis, IN
4 days ago
Senior Robotics Integration Engineer
...Job Description Senior Robotics Integration Engineer \n Robotics & Autonomous Systems \n Carmel, Indiana (Relocation support for suitable, US based, out of area candidates) \n \n Airbotics Talent are partnered with a global technology company developing robots...
Immediate start
Visa sponsorship
Relocation package
Airbotics Talent
Carmel, IN
24 days ago
Data Analyst
$42.93k - $48.96k
Job Title: Data Analyst Status: Full-time Department: Administration and Finance Division: Technology Salary Range: $42,926-$48,957 Job Description: See below Job Category: Administrative Job Code No.: IT-07 Department: Administration and Finance Pay Grade: A1...
Full time
Work at office
Generation West Virginia
Indianapolis, IN
4 days ago
Senior Data Quality Analyst
...therapeutic procedures, hospital operations, and life sciences in more than 160 countries and regions. Position Summary The Senior Data Analyst is responsible to deliver insightful metrics, reports, and dashboards to support our business. The role requires collaboration...
Flexible hours
OrganOx
Indianapolis, IN
1 day ago
Operations Data Analyst
$59.69 - $70.22 per hour
...Job Description Job Description Job Title: Operations Data Analyst Location: Indianapolis, IN (Hybrid) Type: 17 month contract Compensation: $59.69-70.22/hour, depending on qualifications Work Model: Hybrid – 3 days onsite Hours: 40.0 Overview Supports pharmacy...
Contract work
Local area
System One
Indianapolis, IN
4 days ago
junior data scientist/Data Analyst / java devops developer
$100k
...Synergisticit at Oracle Cloudworld 2023 Synergisticit at Gartner Data & Analytics summit Why do Tech Companies not Hire recent... ..., Kubernates and REST API's experience For data Science/Data Analyst/AI/Machine learning Positions Preferred SKILLS Associate or Bachelors...
H1b
SynergisticIT
Indianapolis, IN
4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Integration Analyst I. Be the first to apply!