What are the responsibilities and job description for the System Integration Analyst position at Geographic Solutions, Inc.?
Description
Job Summary: 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.
Viable candidates must be willing to work onsite at GSI's headquarters in Palm Harbor, Florida daily.
Duties And Responsibilities
Knowledge, Skills and Abilities:
Job Summary: 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.
Viable candidates must be willing to work onsite at GSI's headquarters in Palm Harbor, Florida daily.
Duties And Responsibilities
- Fully participates in data conversion and data migration projects
- Designs advanced SQL queries, scripts, cursors, stored procedures, triggers
- Optimizes and improves SQL code for better performance
- Understands Full Development Life Cycle & RDBMS
- Assists business analysts and end-users with reporting needs
- Collaborates with applications developers to ensure correct data and data structure to support evolving development
- 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 updates technical documentation
Knowledge, Skills and Abilities:
- Advanced knowledge of SQL 2012 or higher database design standards, including the use of Indexes and triggers
- Good understanding of SQL Server Integration Services (SSIS) programming
- Has excellent command of software languages/platforms (specifically SQL)
- Ability to code programs under ODBC and stored procedures
- Ability to resolve complex data problems by applying technical solutions
- Strong analytical skills
- Ability to monitor and resolve database performance issues
- 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
- Excellent communications skills, both written and verbal
- Bachelor's degree in Computer Science, Information Systems or related field
- Minimum 5- 7 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 also be assigned various projects and tasks as needed.
- May be required to travel to client locations for data conversion planning sessions