Intermediate Database Analyst, Pointclickcare
CA$89-100k
+ 10% Performance-Based Bonus
Technology for long-term care providers
Open for applications
Technology for long-term care providers
1001+ employees
Open for applications
CA$89-100k
+ 10% Performance-Based Bonus
1001+ employees
Company mission
To advance healthcare technology and make a meaningful impact on the lives of millions.
Role
Who you are
- This role requires strong expertise in SQL, ETL processes, scripting and process optimization to enhance the performance and streamline data migration workflows
- 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
What the job involves
- 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
- 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
Our take
The demand for long-term support for the elderly is growing, putting pressure on the already overstretched age care industry. PointClickCare aims to solve this problem by providing care providers with a suite of cutting-edge software tools.
PointClickCare's software gives caregivers access to immediate, point-of-care data insights into their patients. This is proven to improve patient outcomes, ease care transitions and improve efficiency. Having been founded in 2000, PointClickCare is now one of the biggest names in care tech and its software is used by over 26,000 care facilities.
PointClickCare has made a series of partnerships - such as with pharmaceutical corporation Pfizer, and ChartPath, a leading EHR solution for care practices - alongside acquiring the connected care platform Audacious Inquiry. These partnerships and acquisitions aim to improve its adaptability in the market. The company has demonstrated strong ambition and performance, showcased by its being named the top long-term care software provider by KLAS four times in a row.
Steph
Company Specialist at Welcome to the Jungle
Insights
0% employee growth in 12 months
Company
Funding (last 2 of 3 rounds)
Feb 2024
$0.1m
GRANT
Feb 2018
$141.6m
LATE VC
Total funding: $226.2m
Company benefits
- Competitive Wages and Bonus Program
- Comprehensive Benefits
- Onsite Cafeteria
- Onsite Gym
- RRSP/401K program with employer matching
- Flexible Paid Time Off
- Work From Home Policy
- Maternity & Paternity Top Up
- Training and Development Programs
- Corporate Discounts Program
- Games Room and Employee Lounge
- Onsite Wellness Services (dental, massage, optometry, etc.)
Company HQ
Mississauga, ON
Leadership
Mike Wessinger
(Executive Chair)Board Member at C100. Was appointed by the Ministry of Health to the Ontario Health Data Council.
Dave Wessinger
(CEO)Previously served as PointClickCare's COO.
Share this job
View 30 more jobs at Pointclickcare