What are the responsibilities and job description for the Data Integration Specialist position at Geographic Solutions?
Job Summary:
At Geographic Solutions, we are seeking a highly skilled Data Integration Specialist to join our team. In this role, you will be responsible for developing, administering, and maintaining policies and procedures for creating interfaces between client existing and legacy systems and our Geographic Solutions systems.
Duties and Responsibilities:
• Participate in data conversion and migration projects
• Design advanced SQL queries, scripts, cursors, stored procedures, triggers
• Optimize and improve SQL code for better performance
• Collaborate with business analysts and end-users to meet reporting needs
• Work closely with the Team Lead and Analysts throughout the change request process to deliver accurate solutions
• Process change requests through OPC ticket system, including application-wide data changes
• Estimate the level of effort required to complete a project or change request
• Prepare and update technical documentation
• Utilize knowledge of Full Development Life Cycle & RDBMS
Requirements:
• Advanced knowledge of SQL 2012 or higher database design standards, including indexes and triggers
• Strong understanding of SQL Server Integration Services (SSIS) programming
• Excellent command of software languages/platforms, specifically SQL
• Ability to code programs under ODBC and stored procedures
• 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
• Bachelor's degree in Computer Science, Information Systems, or related field
• Minimum 5-7 years of database administration experience in an appropriate technical environment
• Experience in the labor market, Unemployment Insurance, or regulatory occupation industries preferred
Benefits:
We offer a competitive salary and benefits package, as well as opportunities for professional growth and development.
About Us:
Geographic Solutions is a leading provider of geographic information systems (GIS) and data integration solutions.
At Geographic Solutions, we are seeking a highly skilled Data Integration Specialist to join our team. In this role, you will be responsible for developing, administering, and maintaining policies and procedures for creating interfaces between client existing and legacy systems and our Geographic Solutions systems.
Duties and Responsibilities:
• Participate in data conversion and migration projects
• Design advanced SQL queries, scripts, cursors, stored procedures, triggers
• Optimize and improve SQL code for better performance
• Collaborate with business analysts and end-users to meet reporting needs
• Work closely with the Team Lead and Analysts throughout the change request process to deliver accurate solutions
• Process change requests through OPC ticket system, including application-wide data changes
• Estimate the level of effort required to complete a project or change request
• Prepare and update technical documentation
• Utilize knowledge of Full Development Life Cycle & RDBMS
Requirements:
• Advanced knowledge of SQL 2012 or higher database design standards, including indexes and triggers
• Strong understanding of SQL Server Integration Services (SSIS) programming
• Excellent command of software languages/platforms, specifically SQL
• Ability to code programs under ODBC and stored procedures
• 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
• Bachelor's degree in Computer Science, Information Systems, or related field
• Minimum 5-7 years of database administration experience in an appropriate technical environment
• Experience in the labor market, Unemployment Insurance, or regulatory occupation industries preferred
Benefits:
We offer a competitive salary and benefits package, as well as opportunities for professional growth and development.
About Us:
Geographic Solutions is a leading provider of geographic information systems (GIS) and data integration solutions.
