Geographic Solutions, Inc. ยท 1 day ago
System Integration Analyst
Palm Harbor, FL
Full-time
Onsite
Senior Level
5+ years expGeographic Solutions, Inc. is a company that develops and supports policies for data integration. The System Integration Analyst role involves creating interfaces between client systems and Geographic Solutions systems, ensuring functionality and accuracy in data conversion processes.
GovernmentInformation TechnologySoftware
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
Qualification
Required
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
Preferred
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