Join to apply for the System Integration Analyst role at Geographic Solutions, Inc.
1 week ago Be among the first 25 applicants
Join to apply for the System Integration Analyst role at Geographic Solutions, Inc.
Get AI-powered advice on this job and more exclusive features.
Description
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
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
Requirements
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
Credentials And Experience
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)
Special Requirements
May also be assigned various projects and tasks as needed.
May be required to travel to client locations for data conversion planning sessions
Equal Opportunity Employer. M/F/D/V
Seniority level Seniority level Mid-Senior level
Employment type Employment type Full-time
Job function Job function Information Technology
Industries IT Services and IT Consulting
Referrals increase your chances of interviewing at Geographic Solutions, Inc. by 2x
Get notified about new System Integration Analyst jobs in Palm Harbor, FL .
Senior Information Technology Business Analyst St. Petersburg, FL $81.00-$82.00 11 hours ago
Tampa, FL $75,000.00-$125,000.00 1 week ago
Tampa, FL $50,000.00-$65,000.00 5 days ago
IT Business Analyst w/ ClaimsCenter Platform Clearwater, FL $90,000.00-$110,000.00 1 week ago
Tampa, FL $60,000.00-$85,000.00 5 days ago
Tampa, FL $84,177.60-$121,589.87 3 weeks ago
IT Business Analyst Power BI & eCommerce Strategy Hybrid Healthcare Business System Analyst - $105K REMOTE Systems Analyst - IS (Population Health) Technical Business Analyst - Solutions Analyst III Senior IT Business Analyst with Guidewire Clearwater, FL $80,000.00-$100,000.00 2 weeks ago
Assistant Vice President, IT Business Sr Analyst - C12 Tampa, FL $79,120.00-$118,680.00 1 week ago
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
See details and apply
System Integration Analyst