Job details

Data File Analyst

The IS Ops Data File Analyst is involved in the process of evaluating, transforming and loading data into Allied insurance applications and databases that meet system specifications and client requirements. Evaluates data source for completeness, prepares coding scripts and completes data transformation processes in accordance with established design methodologies. Address and resolve issues associated with successful data transformation to maintain accuracy and meet service level standards. Maintains communication on data transformation projects and production issues with relevant staff and client representatives as needed.

Job Duties and Responsibilities:

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
Analyzes and resolves helpdesk tickets submitted by internal users in relation to data file processing / import issue
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

Qualifications (Education, Experience, Certifications & KSA):

Bachelor’s Degree in a technical field or equivalent work experience with ETL software and data transformation software
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

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.

#LI-ID1

#LI-HYBRID

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

Allied Solutions Glassdoor Company Review

3.5