Simplify Logo

Full-Time

Intermediate Database Analyst

Posted on 6/6/2024

PointClickCare

PointClickCare

1,001-5,000 employees

Cloud-based healthcare software platform

Hardware
Enterprise Software
Healthcare

Mid

Mississauga, ON, Canada

Category
Data Management
Data Engineering Management
Data & Analytics
Required Skills
MySQL
SQL
Requirements
  • At least 3 years of experience in Transact SQL/SQL Server/MySQL
  • At least 3 years of experience in database analysis, ETL development, and data migration
  • At least 3 years of experience working in a production environment
  • Experience with cloud-based data services is desirable
  • Strong Technical and Business Process Engineering and Management
  • Strong leadership and relationship-building capabilities
  • Experience in software automation practices
  • Excellent interpersonal and communication skills
  • Detail-oriented with a strong focus on data accuracy and quality
  • Quick learner with strong technical analytical and problem-solving skills
  • Ability to self-manage and work under minimal supervision
  • Must possess the ability to prioritize and multitask in a fast-paced environment
Responsibilities
  • Design, develop, and maintain ETL processes to efficiently extract, transform, and load data
  • Plan and execute data migration projects, including mapping data from source to target systems
  • Troubleshoot and resolve issues related to ETL jobs, ensuring timely data availability
  • Perform data validation and verification to ensure data integrity and consistency during migrations
  • Collaborate with stakeholders to define data migration requirements and ensure successful data transition
  • Optimize database performance through query optimization
  • Provide technical support and training to team members and stakeholders on ETL and data migration processes
  • Act as an escalation contact for other team members in Technical Services during the project execution process
  • Provide off-hour support approximately 10% of the time. This includes overnight and weekends where necessary

PointClickCare, a leader in cloud-based healthcare software, offers a work environment focused on integrating essential patient data and boosting care outcomes. Employees can take pride in contributing to a system that enhances care coordination and optimizes financial processes for healthcare providers, fostering a significant impact on the industry. This commitment to improving healthcare efficiency and outcomes makes it an appealing place for professionals passionate about making a meaningful difference in the sector.

Company Stage

Private

Total Funding

$231M

Headquarters

Mississauga, Canada

Founded

2000

Growth & Insights
Headcount

6 month growth

5%

1 year growth

5%

2 year growth

5%

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

INACTIVE