Geographic Solutions, Inc. · 21 hours ago
Data Specialist/Systems Integration Analyst
Palm Harbor,FL,US
Full-time
Hybrid
Entry, Mid Level
2+ years expGeographic Solutions, Inc. is seeking a Data Specialist/Systems Integration Analyst responsible for performing heavy SQL data analysis and supporting Business Analysts and Project Managers. The role involves developing and maintaining policies for data interfaces, troubleshooting data issues, and collaborating with clients and internal teams to ensure data accuracy and quality.
GovernmentInformation TechnologySoftware
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
Qualification
Required
Performing heavy SQL data analysis in support of Business Analysts and Project Managers
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
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
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
Must possess strong MSSQL skills (including proficiency with data tables, merges, table changes)
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
Preferred
Workforce development experience highly desired, two or more years' experience with data analysis in a software/IT development setting strongly preferred
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)
Company
Geographic Solutions, Inc.
Established in 1992, Geographic Solutions, Inc.
201-500 employees
H1B Sponsorship
Geographic Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (2)
2023 (2)
2021 (1)
2020 (3)
Funding
Current Stage
Growth StageRecent News
Company data provided by crunchbase