The IS Operations Date File Analyst 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 issueUnitrac 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 activitySetup client specific configurations in Allied systems to enable the import of data and review for conflicts and configuration issuesUser Acceptance Testing (10%)
Conduct user acceptance testing for ETL data transformations.Create test case documentation for the new integration data importIdentify and assist with errors related to data mapping and system configurationConduct user acceptance testing for backfeed and escrow billing files being created and deliveredCoordinate client tests for backfeed and escrow billing file functionalityQualifications (Education, Experience, Certifications & KSA) :
Bachelor's degree, or equivalent combination of education and experience, required. Field of Study : Technical FieldCertification in ETL Software Tool preferredExperience in SQL - reading, writing data transformation scripts / programs preferredAbility to handle multiple tasksStrong attention to detail and excellent organization skillsStrong ability to define and follow instructions with concise correspondence : oral / written instructions and memosAbility to troubleshoot problems and / or issues.Ability to understand logical coding / script statementsUnderstanding 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