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

Key technologies and capabilities for this role

ETLData TransformationScriptingDebuggingTechnical DocumentationHelp Desk SupportConfigurationUser Acceptance TestingTest Case Documentation

Questions & Answers

Common questions about this position

What is the work arrangement for this position?

This is an on-site position located in IN.

What salary or compensation is offered for this role?

This information is not specified in the job description.

What key skills and qualifications are required for this position?

A Bachelor’s degree in a technical field or equivalent is required, along with preferred experience in SQL for reading and writing data transformation scripts, certification in ETL software tools, strong attention to detail, organizational skills, and troubleshooting abilities.

What are the main responsibilities in this role?

Key duties include writing and reviewing technical requirements documentation (50%), providing help desk support (30%), Unitrac configuration (10%), and user acceptance testing (10%) for data transformations and imports into the insurance tracking system.

What makes a strong candidate for this Data File Analyst role?

Strong candidates will have a technical degree or equivalent, SQL experience with data scripts, ETL certification, and demonstrate attention to detail, multitasking, troubleshooting, and clear communication skills.

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