Position: Data Integration Analyst
Company: Alcor
Category: Data Science
Experience required: 3y
English level: upper

Your technical data migration, scripting and organizational skills will ensure the customer’s data is converted and integrated efficiently and accurately on to the InsightSoftware platform. Position reports into the Manager, Integration Services.

What You’ll Do: 

Data mapping Integration/Migration scripting work

·         Create mappings from legacy system to InsightSoftware import templates

·         Work with various types of data formats such as Excel spreadsheets, .csv files, Access databases as well as extracts from SQL Server or other relational databases.

·         Write SQL scripts to update data and convert and/or integrate provided data to InsightSoftware software formats

·         Utilize Dell Boomi and other data mapping tools to transform data and optimize transaction flows (Will need junior to intermediate programming skills)

·         Successfully works to automate manual integration and/or migration processes

·         Manage multiple projects and establish priorities

Communication

·         Communicate with clients and/or InsightSoftware Project Manager to scope, develop, test and implement conversion/integration

·         Effectively communicate with InsightSoftware Project Managers to keep project on target

·         Continually drive improvements in the integration process

·         Collaborate via phone and email with clients and/or InsightSoftware Project Manager throughout the conversion/integration process

 Data Reconciliation

·         Ensure client’s data is converted/integrated accurately and within deadlines established by InsightSoftware Project Manager.

 

What You’ll Need:  

·         Data management/integration/analyst experience

·         Junior to Intermediate level Javascript, Groovy or other programming language equivalent experience highly desired

·         Strong SQL knowledge

·         BA or BS degree required

·         Excellent written, oral and presentation skills

·         Solutions focused approach to creative problem solving

·         Strong organizational and multi-tasking skills required to successfully lead in a fast-paced work environment

·         Ability to determine priorities on a daily basis to achieve business objectives

·         Equity compensation or financial data experience a plus but not required

·         Experience with Dell Boomi or other technologies such as (Informatica, SSIS, Mulesoft) a plus but not required