Data Specialist/Systems Integration Analyst

GEOGRAPHIC SOLUTIONS INC•Palm Harbor, FL

About The Position

Job Summary: This individual will be responsible for performing heavy SQL data analysis in support of Business Analysts and Project Managers. In addition, 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. Relies on direction and good judgment to plan and accomplish goals. Works under general supervision.

Requirements

Must possess strong MSSQL skills (including proficiency with data tables, merges, table changes)
Workforce development experience highly desired, two or more years’ experience with data analysis in a software/IT development setting strongly preferred
High attention to detail and accuracy
Ability to write simple and/or complex SQL queries as needed
Excellent interpersonal and time management skills essential
Strong analytical skills
Ability to document database designs and conversion maps
Familiarity with data corruption and database recoverability methods
Ability to learn and master the business rules associated with our applications and how they interact with the data and data structure
Ability to monitor and resolve database performance issues
Excellent written and oral communication skills
Ability to interface with wide range of individuals, both internally (Project Managers, Business Analysts, Programmers) as well as external clients

Nice To Haves

Understanding of the Virtual OneStop system
Understanding of the OPC/Intranet
Understanding of UI System Concepts
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)

Responsibilities

Handling table changes in SQL as it relates to specific client configured data
Merging records and/or other client requested data change requests in SQL and GUI with recommendations on how to resolve
Testing data in various environments, including but not limited to: automated interfaces, Virtual OneStop GUI, nightly batch processes; verification of converted legacy data
Troubleshoot Federal reporting issues as identified by clients
Resolving issues identified by clients or internal staff where GUI may have caused inaccurate data to be recorded
Work directly with clients to discuss issues, propose solutions to correct data issues, implement the resolution and follow up on the resolutions
Make recommendations (written and verbal) on how changes could be implemented to improve the overall data quality
Designs advanced 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 closely 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
May also be assigned various projects and tasks as needed.