What are the responsibilities and job description for the Data File Analyst (Onsite, IN) position at Allied Solutions LLC?
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%)
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
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
- 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
- Setup client specific configurations in Allied systems to enable the import of data and review for conflicts and configuration issues
- 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
- 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
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
