SQL Data Migration Specialist at PlotBox

We pride ourselves on delivering world class solutions to our clients and rely on our talented and experienced Data Migration team to successfully onboard our customers to ensure their experience of our product is world class. At PlotBox we deal with a huge amount of data, ranging from critical business data to precious genealogical information. Our customers expect their data to be accurate and safe during the on-boarding process and whilst operating on a cloud platform. We provide our customers with confidence from the beginning of our relationship.

To support recent growth, we are looking for a talented individual who is experienced in working with data to join our team. You will be working alongside other members of a small agile team to complete customer data migration projects from a variety of source systems. Although the Data Team is centred around customer projects, this is a non-customer facing role and the focus will be on the technical side of work.

This is an exciting opportunity for an experienced data specialist with strong SQL skills (or similar language/ technology) with a desire to further develop their skills in data acquisition, manipulation, cleansing, testing and migration. 

Responsibilities

As SQL Data Migration Specialist, you will be responsible for retrieving and manipulating data in databases from legacy systems while ensuring that data quality, integrity and completeness is maintained:

• Developing migration scripts from target databases to upgraded schema
• Working with various types of data ranging from personal ownership records through to complex financial data
• Executing customer data migration plans, ensuring all project data migration activities are delivered on-time, within scope and to budget
• Developing, testing and maintaining ETL scripts to load data into PlotBox database
• Developing, testing and maintaining data validation scripts to evaluate customer data prior to migration
• Developing alternative technical and functional approaches for data migration when necessary
• Assisting clients to map legacy data and identify source data quality issues
• Loading customer data into PlotBox using in-house tools and validate the data using both technical (scripts) and functional (PlotBox QA) mechanisms
• Communicating data anomalies to project and customer teams to ensure issues are identified and resolved in a timely manner
• Developing T-SQL queries to address data issues
• Estimating and completing tasks as part of a sprint team
• Contributing to project planning to ensure data migration activities and milestones are accurately represented and customers well informed of their responsibilities
• Analysing client data and draft data analysis reports
• Delivering Quality Assurance tests and checks on data migration scripts
• Working with the technical consultants to understand requirements and correct issues flagged in UAT
• Identifying and escalating risk and issues to project leadership as appropriate
• Contributing to the ongoing development/enhancement of data migration tools and framework

Who we think will be a great fit

ESSENTIAL:   

You will be focused on delivering high quality outputs and be flexible and adaptive to the needs of the business.  You will have the ability to work to project plans and manage your time effectively and will demonstrate a positive can-do attitude towards your work.

You will have:

• At least 3 years working with varied data formats (csv, MS SQL, Excel, MySQL
  Postgres etc) ideally for complex data migration from legacy systems to SaaS
• Developed over a period of time, you will have solid SQL skills, including query writing and stored procedures
• A good working knowledge of Microsoft Office and/or working knowledge of Google Drives (docs, sheets, slides etc.)
• Excellent written and verbal communication skills
• Demonstrable experience working effectively as part of a team and delighting the customer
• Relevant educational background, preferably in the fields of computer science or a relevant professional IT qualification (or equivalent work experience)

DESIRABLE:

• Basic knowledge of Python would be beneficial, but it’s not a dealbreaker.

Company Summary

PlotBox is the innovative cloud-based deathcare management solution that enables cemeteries, crematories and funeral homes to serve their families in the best way possible. We are very clear on our mission; to take away some of the pain for families dealing with death and those who serve them, provide our customers with more time for what matters. 

Headquartered in Northern Ireland, with offices in the United States and Australia, our growing, 80-strong multidisciplinary team of experts provides our partners with the same professional levels of service, support and satisfaction across the globe.  We live and breathe our core values – Tenacity, Teamwork and Trust.

We have a passion for tech and innovation, actively exploiting new and cutting-edge tools and technologies to enhance our product and skillset. We actively promote from within and our dynamic scale up culture ensures that proactivity and initiative are rewarded with excellent career opportunities, progression and mobility.

How would our team describe life at PlotBox? When asked to describe our company, they use words such as fun, respect, care, team spirit, family feel, trust, happy, listen, sense of accomplishment, flexibility, development.

We are proud that, for the third year running, we have received our Great Place to Work® Certification™. This follows our top ten ranking on the 2022 UK’s Best Workplaces™ in Tech list, as well as being named one of the 2022 UK’s Best Workplaces™ For Women, and one of the 2022 UK's Best Workplaces™ for Wellbeing. 

Our staff have told us loud and clear that they love working for PlotBox; from the relaxed working environment to feeling truly valued in their roles. In addition, our purpose-driven mission and the sense of pride in doing what we do - to ultimately lessen people’s pain at the most difficult time of their lives - means a lot to our team.

Benefits Offered by PlotBox

Our headquarters are ideally placed in the beautiful and scenic countryside location around Ballymena, along with other office locations in the USA and Australia.  We are constantly increasing our list of benefits which currently include:

• Investment in employee growth, and opportunity for development 
• Regular wellbeing initiatives and health cash plans
• Safe and supportive culture; we foster continuous improvement in all aspects of work
• Career mobility and progression 
• Regular travel opportunities 
• Flexible working hours
• Hybrid Working - between office and home locations
• Pension
• Life Insurance
• Active social and charity committee - lots of social events throughout the year
• Office perks: fridge and larder fully stocked with unlimited drinks and snacks
• Free Parking