Title: Systems Integration Analyst
Company: Geographic Solutions, Inc.
Must have the following in order to apply:
Bachelor’s degree in Computer Science, Information Systems or related field
Minimum five years of database administration experience in appropriate technical environment.
Experience in the labor market, Unemployment Insurance or regulatory occupation industries preferred
Advanced Microsoft SQL Server knowledge (to include advanced querying in T-SQL, stored procedures, indexes, triggers, SSIS, import and export capabilities)
May be required to travel to client locations for data conversion planning sessions
Valid Florida driver’s license
Develops, administers, maintains, and supports policies and procedures for creating interfaces between and/or converting data from client existing and legacy systems to Geographic Solutions systems. Designs programming specifications through interaction with business owners and subject matter experts. Ensures correct functionality and accuracy of the interface or conversion scripts. Familiar with the standard concepts, practices, and procedures within the labor market industry as well as job services concepts.
Duties and Responsibilities
Designs SQL queries, stored procedures, triggers, scripts, cursors
Leads/assists in data conversion and data migration projects
Assists business analysts and end-users with reporting needs
Collaborates with applications developers to ensure correct data and data structure to support evolving development
Understands Full Development Life Cycle & RDBMS
Develops processes for nightly builds, and deployment
Optimizes and improves SQL code for better performance
Develops programming specifications through interaction with business unit subject matter experts
Works with the Team Lead and Analysts throughout the change request process to insure the delivery of an accurate solution
Processes change requests through OPC ticket system, including application wide data changes
Estimates the level of effort required to complete a project or change request
Prepares and update technical documentation
Criminal Background and Reference Check.
Fast paced, team-oriented environment with a casual dress code.
Days & Hours:
Monday through Friday; full time position.
See full details and apply at https://recruiting.paylocity.com/recruiting/jobs/Details/257428/GEOGRAPHIC-SOLUTIONS-INC/Systems-Integration-Analyst