ETL & Data Migration Agent (work-from-home)



Ready to make a substantial impact on data migration and our ETL processes?

Join our team today!

Power Diary is a fast-growing, values-driven company with all the right ingredients to put you on your path!

Join a great team, work remotely, AND contribute to the provision of healthcare!


What is the role?

Join our team as an ETL & Data Migration Agent, where you'll ensure the smooth onboarding of new customers migrating from different sources including competing Practice Management Software (PMS) and custom built systems. Your role involves collaborative management of daily data imports using our existing processes (Excel and SQL based), as well as supporting our transition of these processes to AWS Glue.

Your strong communication skills and customer-centric approach will be essential as you engage with customers to ensure their data is migrated as needed. In our team, teamwork is paramount, with shared responsibilities among members.

This role requires team collaboration with the Power Diary team in Eastern Australia.

What will you do? 

On a day-to-day basis, your responsibilities and activities will include:

1. AWS Glue Specific Responsibilities

Transition existing in-house ETL processes to AWS Glue. 

Create, implement and maintain ETL workflows for new source systems

Create user-friendly workflows to support other team members to efficiently utilise the AWS ETL processes.

Create and maintain internal user documentation 

Help team members understand and manage the ETL processes including to fix issues and make on-the-spot adjustments as required.

Continuous Improvement: work with the team to perform QA on these processes and remedy / improve where apt

2.  Customer Data Migration

Attend to client migrations and enquiries, including queue management, customer collaboration for migration requirements, expectation management, and resolution of data anomalies.

Cleanse,, transform, and import customers' data into their new Power Diary account,using AWS Glue, our existing ETL processes or manually with Excel. Analyse incoming data import requests and provide proactive advice and guidance to customers 

Provide troubleshooting and support to Customers for post-import enquiries and issues

Contribute to data migration process development, define new source system requirements, and establish best practices for efficient data migration.

Collaboration with the team on daily tasks, challenges, and projects

Weekend work on a rostered basis where required based on customer need

Who are we looking for?

AWS Glue Experience: Hands-on experience with AWS Glue: transitioning and creating ETL processes for multi-relational databases

Excel: Possess advanced skills in Excel, including the use of functions, statements, and vlookup, enabling effective data manipulation and analysis.

SQL: Ability to write SQL statements is preferred, as it facilitates data extraction, transformation, and loading operations, as well as remedies and updates.

Python / Scala: Sufficient capability with related programming languages: Python and/ or Scala to develop custom ETL scripts for AWS Glue where the visual tools won’t suffice.

Data Acumen: Demonstrate a solid acumen for data and database systems, applying knowledge to effectively work with data in various contexts.

Attention to detail: Exhibit strong attention to detail, carefully evaluating data for accuracy and detecting any errors or anomalies.

Customer Focus: Be customer centric and have the ability to communicate clearly and effectively with customers through email, virtual meetings and phone calls

Collaborative Approach: Possess a collaborative mindset, actively engaging with team members to troubleshoot, update, and ensure process continuity, as well as identify and discuss opportunities for improvement

Why you’ll LOVE working at Power diary…

When you join Power Diary, you’ll benefit from perks like;

✅ Work from Anywhere

There are no offices at Power Diary as we’ve been a distributed team long before everyone else caught on. We look for the best people around the world – not just those who live within a 1 hour commute. If you like working from home, or really from anywhere, you’ll find a bunch of like-minded people here.

✅ Paid Time Off

There’s no sense in working all the time – we believe everyone needs balance and we want you to have enough time to do other things that enrich your life. We offer all of our permanent team members 30 days of paid time off and we expect you to take it.

✅ Flexibility

Need to get the kids to school or want to do a gym class in the middle of the day? No problem. We need you to be available for some agreed core hours to work with your colleagues and cover our service requirements, but other than that your time is yours.

✅ Competitive Pay

We aim to work with the best people – wherever and whoever they are. We know this comes at a business cost, but we consider this an investment in the company’s future. We offer competitive pay and we want all team members to feel well-rewarded for their contribution.

✅ Results Driven

At Power Diary, we detest bureaucracy and we strive to keep the focus on building and supporting great software that will help our customers (and in turn, help more of their clients). There are no pointless meetings, forms, or other impediments in your way. As we grow, we aim to stay agile – in every way.

✅ Learning & Growth

We’re big supporters of personal growth and development and our team is constantly learning and upskilling themselves in many different areas. Innovation is a big part of our culture and we welcome new ideas from everyone.

✅ Inspiring Team

We truly love our team at Power Diary and we hope you will too. We’re a bunch of unique individuals from all kinds of backgrounds with a vast array of specialist skills and interests. Although we work remotely, the team works closely together and we also make time to know and support each other. 

✅ Meaningful Work

We’re constantly getting feedback from customers that are relieved to have found Power Diary. In many cases, they refer to us as a ‘life saver’ or a ‘game changer’, and it feels great to be part of something that helps people get the healthcare support they need. See our customer feedback here.

About Power Diary

Power Diary is a leading healthcare practice management system used in Australia, New Zealand, the United Kingdom, the United States and Canada.

Our mission is simple: To provide health practitioners with the ultimate Practice Management Software that makes running a health practice easier and more rewarding.

Power Diary’s customer base is growing and we need smart, passionate people to join our team and help take us to the next level. We’re looking for people who are genuinely excited to help health practitioners do their work, and be part of a globally distributed team

As a healthcare company, we care about our workforce just as much as our clients and their patients. You will enter a fun, inclusive workplace with a dedicated and driven team.

We are still a relatively small business, but self-funded and growing strongly. This is an exciting time to be at Power Diary – we have some great plans for the future and many challenging things to work on. We hope you’ll consider joining our team and being part of our story!

See more information about Careers at Power Diary here.

(*) Power Diary collects and processes your personal data for the purposes of managing employment candidate application and recruitment-related activities as well as for organisational planning purposes, for further detail, please refer to the Power Diary Privacy Policy.

Drop files (or click) here to upload.

(200MB file size limit)