Data File Analyst 1 (On-Site, IN) at Allen Integrated Solutions LLC

Carmel, Indiana, United States

Apply Now

Not SpecifiedCompensation

Junior (1 to 2 years)Experience Level

Full TimeJob Type

UnknownVisa

InsuranceIndustries

Requirements

Bachelor’s degree, or equivalent combination of education and experience, required. Field of Study: Technical Field
Certification in ETL Software Tool preferred
Experience in SQL - reading, writing data transformation scripts / programs preferred
Ability to handle multiple tasks
Strong attention to detail and excellent organization skills
Strong ability to define and follow instructions with concise correspondence: oral/written instructions and memos
Ability to troubleshoot problems and/or issues
Ability to understand logical coding/script statements
Understanding of data file structures

Responsibilities

Maintains communication on data transformation projects and production issues with relevant staff and client representatives as needed
Works with management team to monitor SLAs and identify projects that are at-risk to help develop a plan of action to re-establish progress
Performs code / script creation, testing, implementation, debugging and documentation of data transformation processes that enable import of data into the insurance tracking system (50%)
Reads and translates data transformation requirements documents
Analyzes and directs necessary changes to production data transformation code/scripts that enable data import processes to complete accurately into insurance tracking system
Resolves problems associated with production programs/scripts/transformations and works with the Data Transformation Analyst for complex programming
Works with senior data transformation development staff, system administrators and technical support to ensure data transformations of client / vendor information is completed in accordance with established service level standards
Analyzes and resolves helpdesk tickets submitted by internal users in relation to data file processing / import issue (30%)
Works with Client Support / lender client staff / software vendors to analyze and direct data transformation projects; including new client implementations, client Data Processor conversion, client lender merger and support of daily production data transformation activity (10%)
Setups client specific configurations in Allied systems to enable the import of data and review for conflicts and configuration issues (10%)
Conducts user acceptance testing for ETL data transformations
Creates test case documentation for the new integration data import
Identifies and assists with errors related to data mapping and system configuration
Conducts user acceptance testing for backfeed and escrow billing files being created and delivered
Coordinates client tests for backfeed and escrow billing file functionality

Skills

ETL

Data Transformation

Scripting

Debugging

Technical Documentation

Help Desk Support

Configuration

User Acceptance Testing

Test Case Documentation

Allen Integrated Solutions LLC

Provides technical and management services for government security missions

About Allen Integrated Solutions LLC

Allen Integrated Solutions LLC specializes in a range of technical and management services aimed at enhancing performance in government and security sectors. With a focus on integration management, intelligence, cyber security, and more, the company expertly handles missions related to national security and defense. This firm stands out as a reliable provider of comprehensive systems engineering, technical assistance, and advisory services, making it a pivotal support system for complex federal operations.

Stafford, VA 22554, USAHeadquarters

2015Year Founded

VENTURE_UNKNOWNCompany Stage

Consulting, AerospaceIndustries

11-50Employees