At PointClickCare our mission is simple: to help providers deliver exceptional
care. And that starts with our people. As a leading health tech company that’s
founder-led and privately held, we empower our employees to push boundaries,
innovate, and shape the future of healthcare.
With the largest long-term and post-acute care dataset and a Marketplace of 400+
integrated partners, our platform serves over 30,000 provider organizations,
making a real difference in millions of lives. We also reinvest a significant
percentage of our revenue back into research and development, ensuring our
employees have the resources to innovate and make a lasting impact. Recognized
by Forbes as a top private cloud company and honored as one of Canada’s Most
Admired Corporate Cultures, we offer flexibility, growth opportunities, and
meaningful work.
At PointClickCare, we empower our people to be the architects of a smarter
healthcare future; one that is human-first and accelerated by AI to create
meaningful and lasting change. Employees harness AI as a catalyst for
creativity, productivity, and thoughtful decision-making. By integrating AI
tools into our daily workflows, collaboration is enhanced, outcomes are
improved, and every team member has the proficiency to maximize their impact. It
all starts with our hiring practices where we uncover AI expertise that
complements our mission, and we continue to invest in training and development
to nurture innovation throughout the employee journey.
Join us in redefining healthcare — so it doesn’t just survive, it thrives. To
learn more about PointClickCare, check out Life at PointClickCare
[https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpointclickcare.com%2Flife-at-pointclickcare%2F&data=05%7C02%7CSandeep.Dhillon%40pointclickcare.com%7Ce9353db140a24fd980f808ddb00013f1%7Cafd0249eca3d42058bf4ac2b6abd0fec%7C0%7C0%7C638860236586947941%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=dIKtrMG7L0sb%2FfLrFRvhcZAmfqfNXTXDTvMsoJkwGvM%3D&reserved=0] and
connect with us on Glassdoor
[https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.glassdoor.ca%2FOverview%2FWorking-at-PointClickCare-EI_IE452666.11%2C25.htm&data=05%7C02%7CSandeep.Dhillon%40pointclickcare.com%7Ce9353db140a24fd980f808ddb00013f1%7Cafd0249eca3d42058bf4ac2b6abd0fec%7C0%7C0%7C638860236586978442%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=KVgSiL%2ByFmnpxTc5PmuErMwRNwDmTGqUzJIUSIm5fY0%3D&reserved=0]and LinkedIn
[https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fpointclickcare%2F&data=05%7C02%7CSandeep.Dhillon%40pointclickcare.com%7Ce9353db140a24fd980f808ddb00013f1%7Cafd0249eca3d42058bf4ac2b6abd0fec%7C0%7C0%7C638860236586994867%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=AFNWMltUX65iQ5E5LFYOrA9bKP10SzKQ7jwcti57q2E%3D&reserved=0].
Travel to Office expectations
For Remote Roles: As this role is remote, there will be in-office events that
will require travel to and from the Mississauga and/or Salt Lake City office.
These will include, but not limited to, onboarding, team events, semi-annual and
annual team meetings.
For Hybrid Roles: As this role is Hybrid, there will be an expectation to reside
within commutable distance to the office/location specified in the job listing.
This will include, but not limited to, weekly/bi-weekly/monthly events in the
office with your specific team. This is a requirement for this role.
About the Role:
We are seeking a detail-oriented and highly analytical Intermediate Database
Analyst to support and execute multiple data migration projects in parallel. The
ideal candidate will be responsible for migrating data from source to target
systems ensuring accuracy, consistency, and efficiency throughout the process.
This role requires strong expertise in SQL, ETL processes, scripting and process
optimization to enhance the performance and streamline data migration workflows
Key Responsibilities:
• Availability to provide data migration support during off-business hours and
on weekends is required.
• Analyze and assess data structures in source and target systems to develop
effective migration strategies
• Migrate data from legacy systems to new platforms, ensuring data integrity,
accuracy, and consistency throughout the process.
• Handle multiple data migration projects in parallel, managing priorities and
troubleshooting issues efficiently
• Develop, test and optimize scripts and processes to enhance migration
performance and minimize downtime
• Write and optimize SQL queries for data extraction, transformation, and
validation.
• Identify data quality issue, perform data cleansing, and apply necessary
information
• Collaborate with stakeholders to define data mapping, business rules and,
validation checks
• Monitor and troubleshoot migration processes, ensuring timely and accurate
data transfer
• Automate repetitive data migration tasks to improve efficiency and reduce
manual effort
• Document data migration process, transformation rules, and troubleshooting
steps for future reference
• Ensure compliance with data security, data governance, and regulatory
standards
Your Key Strengths:
•Exposure to AI tools and a desire to leverage them to enhance your work content
and user experience
• Bachelor's Degree in Computer Science, Information Systems, or a related field
• 3-5 years of hands-on experience in data migration and ETL.
• Proficient in SQL (MySQL, SQL Server), ETL tools (ADF, SSIS), and scripting
(Python, PowerShell, Bash).
• Experienced in automating data migration workflows
• Able to troubleshoot migration issues
• Strong in stakeholder collaboration
• Able to handle multiple projects in a fast-paced environment with minimal
supervision.
\n
\n
$35 - $50 an hour
\n
MG-LI1
Remote
Contract
It is the policy of PointClickCare to ensure equal employment opportunity
without discrimination or harassment on the basis of race, religion, national
origin, status, age, sex, sexual orientation, gender identity or expression,
marital or domestic/civil partnership status, disability, veteran status,
genetic information, or any other basis protected by law. PointClickCare
welcomes and encourages applications from people with disabilities.
Accommodations are available upon request for candidates taking part in all
aspects of the selection process. Please contact recruitment@pointclickcare.com
should you require any accommodations.
When you apply for a position, your information is processed and stored with
Lever, in accordance with Lever’s Privacy Policy
[https://www.lever.co/privacy-policy]. We use this information to evaluate your
candidacy for the posted position. We also store this information, and may use
it in relation to future positions to which you apply, or which we believe may
be relevant to you given your background. When we have no ongoing legitimate
business need to process your information, we will either delete or anonymize
it. If you have any questions about how PointClickCare uses or processes your
information, or if you would like to ask to access, correct, or delete your
information, please contact PointClickCare’s human resources
team: recruitment@pointclickcare.com [recruitment@pointclickcare.com]
PointClickCare is committed to Information Security. By applying to this
position, if hired, you commit to following our information security policies
and procedures and making every effort to secure confidential and/or sensitive
information.
