PointClickCare

Canada- Intermediate Database Analyst (6-Month Contract)

Remote

Not SpecifiedCompensation
Junior (1 to 2 years)Experience Level
Full TimeJob Type
UnknownVisa
Healthcare TechnologyIndustries

Position Overview

  • Location Type: Remote
  • Job Type: Full-Time, Contract
  • Salary: $35 - $50 an hour

PointClickCare is a leading North American healthcare technology platform enabling meaningful care collaboration and real‐time patient insights. For over 20 years, the company has been focused on realizing its vision: to help create a world in which providers and plans can confidently deliver frictionless care. Since its inception, PointClickCare has grown exponentially, with over 2,200 employees working to impact millions across North America. Recognized by Forbes as one of the top 100 private cloud companies and acknowledged by Waterstone Human Capital as Canada’s Most Admired Corporate Cultures, PointClickCare leads the way in creating cloud-based healthcare software.

At PointClickCare, we offer a wealth of opportunities and a vibrant culture that empowers our employees. Our dynamic environment is the perfect place to advance your career while engaging in meaningful work alongside incredible colleagues. Here, you’ll discover a space where your talents can thrive, your career can grow, and your work will have a lasting impact on healthcare across North America. We believe that work becomes profoundly fulfilling when driven by a higher purpose. Join us and be part of a team that is making a real impact.

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 issues, 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

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

Company Information

PointClickCare is committed to ensuring 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, or genetic information.

To learn more about us, check out Life at PointClickCare and connect with us on Glassdoor and LinkedIn.

Skills

SQL
ETL processes
Scripting
Process optimization
Data migration

PointClickCare

Cloud-based EHR solutions for senior care

About PointClickCare

PointClickCare provides cloud-based software solutions specifically designed for the senior care sector, including skilled nursing facilities, senior living communities, and home health agencies. Its main product, Harmony, is an integrated care coordination platform that helps manage patient transitions from hospitals to post-acute care facilities. Harmony allows healthcare providers to exchange clinical data, which improves care coordination and patient outcomes by offering real-time insights and analytics. Unlike many competitors, PointClickCare's platform integrates with other healthcare systems, enhancing data exchange and interoperability. The company's goal is to improve operational efficiency and quality of care for senior care providers through its subscription-based model, which also includes training, support, and consulting services.

Mississauga, CanadaHeadquarters
2000Year Founded
$220MTotal Funding
GRANTCompany Stage
Enterprise Software, HealthcareIndustries
1,001-5,000Employees

Benefits

Competitive financial rewards & equity potential
Comprehensive benefits available from day 1
Midweek mingles with free lunch
Wellness spending account
Retirement savings plan with employer match
Flexible PTO
Hybrid work models
Parental leave
Family planning support
Training & development programs
Corporate discounts program
Summer half-day Fridays
Health & wellness programs

Risks

Integration with Angel Care Medical may face inventory and billing challenges.
Real-time lab result integration with Sensiva Health raises data privacy concerns.
California network expansion may lead to increased regulatory scrutiny and compliance needs.

Differentiation

PointClickCare offers a comprehensive EHR platform for post-acute care providers.
Harmony platform improves patient transitions between acute and post-acute care facilities.
Largest post-acute care data cloud provides real-time insights for informed decision-making.

Upsides

Partnership with Kno2 enhances nationwide data exchange and interoperability.
Integration with FeelBetter optimizes workflows and increases efficiencies in medication management.
Mealtime Solutions streamlines dietary management, improving resident satisfaction and efficiency.

Land your dream remote job 3x faster with AI