PointClickCare

Canada- Intermediate Database Analyst (6-Month Contract)

Remote

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

Requirements

Candidates should possess a Bachelor’s degree in Computer Science, Information Systems, or a related field, and 3-5 years of hands-on experience in data migration and ETL. They must be proficient in SQL (MySQL, SQL Server), ETL tools (ADF, SSIS), and scripting (Python, PowerShell, Bash), along with the ability to troubleshoot migration issues and collaborate effectively with stakeholders.

Responsibilities

The Intermediate Database Analyst will be responsible for analyzing and assessing data structures in source and target systems to develop migration strategies, migrating data from legacy systems to new platforms ensuring data integrity, accuracy, and consistency, handling multiple data migration projects in parallel, managing priorities and troubleshooting issues efficiently, developing, testing, and optimizing scripts and processes to enhance migration performance, writing and optimizing SQL queries for data extraction, transformation, and validation, identifying data quality issues, performing data cleansing, and applying necessary information, collaborating with stakeholders to define data mapping, business rules, and validation checks, monitoring and troubleshooting migration processes, ensuring timely and accurate data transfer, automating repetitive data migration tasks, documenting data migration processes, transformation rules, and troubleshooting steps, and ensuring compliance with data security, data governance, and regulatory standards. Availability to provide data migration support during off-business hours and on weekends is also required.

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