Data Migration Specialist

Summary

Join Granicus as an ETL – Data Migration Specialist and contribute to our mission of transforming the Govtech industry. This full-time, permanent, remote position, based in Costa Rica, requires expertise in data migration and database management. You will use various tools and processes to migrate data, develop procedures, coordinate database changes, and validate data sets. The role involves collaborating with technical and project teams, producing client reports, and resolving production issues. Successful candidates will possess strong problem-solving skills, experience with diverse databases, and excellent communication abilities. Granicus offers a remote-first work environment and a commitment to diversity and inclusion.

Requirements

• Strong problem-solving skills, including the ability to analyze complex problems and create well documented solutions
• Strong focus on automating repeatable tasks
• Excellent written and verbal communication skills, interpersonal skills, and multitasking capabilities
• Ability to work under pressure both independently and within a team, in a fast-paced environment
• Experience working with a variety of diverse types of databases such as MS SQL Server, MySQL, Access and PostgreSQL
• Experience migrating, loading and validating data sets into production environments
• Background migrating between different data sources
• Bachelor’s Degree in Technology related field or equivalent combination of education and work experience

Responsibilities

• Use various tools and processes to complete data migrations from other software packages into our products in a timely and accurate manner
• Develop procedures and scripts for continuous improvement and repeatable processes
• Coordinate database changes and migrations with technical team, projects team and management
• Validate and analyze data sets to ensure data consistency and internal requirements are met
• Assist in technical direction for internal data models by coordinating with internal groups
• Produce client focused reports and logs of operations performed
• Participate in detailed design and product test execution as required
• Facilitate resolution of production database issues
• Provision, monitor, and maintain database replication across WAN links for multiple database platforms including Microsoft SQL Server and MySQL
• Support efforts to move to a PaaS compliant database architecture
• Other projects and duties as required
• Responsible for Granicus information security by appropriately preserving the Confidentiality, Integrity, and Availability (CIA) of Granicus information assets in accordance with the company's information security program
• Responsible for ensuring the data privacy of our employees and customers, their data, as well as taking all required privacy training in a timely manner, in accordance with company policies

Preferred Qualifications

Don’t have all the skills/experience mentioned above? At Granicus, we are trying to build diverse, inclusive teams. We do not have degree requirements for most of our roles. If you don’t meet every requirement above but are excited to learn more, we encourage you to apply. We might just be able to find another role that could be a perfect fit!

Benefits

This full time, permanent, remote position based in Costa Rica