The Data Specialist will be responsible
for executing established data and file processes according to the schedule of
each process. Other responsibilities
include reconciliation and error reporting of assigned processes, management of
work in a CRM queue and general assistance to senior members of the Data
Solutions team related to setup, testing and execution as needed.
- Execute scheduled and adhoc SQL, SSIS
and EDI processes - Perform test and live system setup
- Execute predefined SQL queries
- Import data in multipe format into
Excel - Basic data analysis and reporting in
Excel - Assist with prioritization and
monitoring of team work queues - Capture file results and failures and
report to appropriate parties - Assist with resolution of data related
system issues
- Basic knowledge of flat files included
fixed length and delimited - Basic understanding SQL or relational
database structures - Ability to quickly learn new systems
and tools - Experience with FTP, SFTP and PGP
processes and tools such as Filezilla - Bachelor's degree in Business, technology,
related discipline or equivalent experience - Ability to work effectively with both
business & technology employees - Excellent communication and
interpersonal skills - Self-motivated, independent,
intellectually curious, with the ability learn by doing - Ability to multi-task in a fast paced
and dynamic operations environment - Problem-solving skills – identify
problem areas and provide solutions with strong attention to detail