Data Migration Specialist

The Company 

Serving the People Who Serve the People 

Granicus is driven by the excitement of building, implementing, and maintaining technology that is transforming the Govtech industry by bringing governments and their constituents together. We are on a mission to support our customers by meeting the needs of their communities and implementing our technology in ways that are equitable and inclusive. Granicus has consistently appeared on the GovTech 100 list over the past 5 years and has been recognized as the best companies to work on BuiltIn.  

Over the last 25 years, we have served 5,500 federal, state, and local government agencies and more than 300 million citizen subscribers powering an unmatched Subscriber Network that uses our digital solutions to make the world a better place. With comprehensive cloud-based solutions for communications, government website design, meeting and agenda management software, records management, and digital services, Granicus empowers stronger relationships between government and residents across the U.S., U.K., Australia, New Zealand, and Canada. By simplifying interactions with residents, while disseminating critical information, Granicus brings governments closer to the people they serve—driving meaningful change for communities around the globe. 

Want to know more? See more of what we do here.  

Are you passionate about data and databases?  We are seeking an ETL – Data Migration Specialist to join our Services and Dev-Ops Teams to support both internal and external clients. 

We are looking for a motivated, skilled and energetic person who works well in a fast-paced, dynamic small-team environment.  You will need to learn quickly and be passionate about helping others. 

As the leader in government technology based in the heart of downtown Denver, we’re looking for talented, hard-working individuals to join the team. We have a casual, open office environment within walking distance of the Light Rail, and we’re seeking individuals who can work collaboratively with both our Development and Operations teams.  We look forward to hearing from you. 

This full time, permanent, remote position based in Costa Rica and does not offer relocation benefits. Job applicants must be located and legally authorized to work in Costa Rica in order to be eligible for consideration.

#PuertoRicoCostaRica

• 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 

• 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 

Security and Privacy Requirements

·        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. 

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! 

The Team

- We are a remote-first company with a globally distributed workforce across the United States, Canada, United Kingdom, India, Armenia, Australia, and New Zealand.

The Culture

- At Granicus, we are building a transparent, inclusive, and safe space for everyone who wants to be

a part of our journey.

- A few culture highlights include – Employee Resource Groups to encourage diverse voices

- Coffee with Mark sessions – Our employees get to interact with our CEO on very important and

sometimes difficult issues ranging from mental health to work-life balance and current affairs. 

- Microsoft Teams communities focused on wellness, art, furbabies, family, parenting, and more.-=- - We bring in special guests from time to time to discuss issues that impact our employee

population 

The Impact

- We are proud to serve dynamic organizations around the globe that use our digital solutions to make the world a better place — quite literally. We have so many powerful success stories that illustrate how our solutions are impacting the world. See more of our impact here.

Granicus is committed to providing equal employment opportunities. All qualified applicants and employees will be considered for employment and advancement without regard to race, color, religion, creed, national origin, ancestry, sex, gender, gender identity, gender expression, physical or mental disability, age, genetic information, sexual or affectional orientation, marital status, status regarding public assistance, familial status, military or veteran status or any other status protected by applicable law.