Data File Analyst I (Onsite)

The IS Operations Date File Coordinator maintains communication on data transformation projects and production issues with relevant staff and client representatives as needed. This individual will work with their management team to monitor SLAs and identify projects that are at-risk to help develop a plan of action to re-establish progress.

Job Duties and Responsibilities:

Writing & Reviewing Technical Requirements Documentation (50%)

• Performs code / script creation, testing, implementation, debugging and documentation of data transformation processes that enable import of data into the insurance tracking system
• Read and translate data transformation requirements documents
• Analyze and direct 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

Help Desk Support (30%)

• Analyzes and resolves helpdesk tickets submitted by internal users in relation to data file processing / import issue

Unitrac Configuration (10%)

• 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
• Setup client specific configurations in Allied systems to enable the import of data and review for conflicts and configuration issues

User Acceptance Testing (10%)

• Conduct user acceptance testing for ETL data transformations.
• Create test case documentation for the new integration data import
• Identify and assist with errors related to data mapping and system configuration
• Conduct user acceptance testing for backfeed and escrow billing files being created and delivered
• Coordinate client tests for backfeed and escrow billing file functionality

Qualifications (Education, Experience, Certifications & KSA):

• 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

#LI-ID1

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.

We offer our employees a robust compensation package! Our comprehensive benefits include: medical, dental and vision insurance coverage; 100% company-paid life and disability coverage, 401k options with company match, three weeks PTO by the end of the first year and much more. Allied proudly promotes from within as part of a strong commitment to providing career growth opportunities for employees of all levels. Our diverse business portfolio allows employees broad career options with the advantage of staying with the same organization.

All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

To view our privacy statement click here

To view our terms and conditions click here