Intermediate Database Analyst (Canada)

PointClickCare; United States; Remote; USD 89,000 - 100,000; Full time

Job summary

An established industry player in healthcare technology is on the lookout for an Intermediate Database Analyst to join their dynamic team. This role is pivotal in executing multiple data migration projects, ensuring accuracy and efficiency in transferring data between systems. The ideal candidate will possess strong SQL and ETL skills, along with a knack for process optimization and stakeholder collaboration. With a vibrant culture that fosters career growth and meaningful work, this opportunity allows you to make a significant impact on healthcare across North America. If you're ready to take on challenges in a fast-paced environment, this role is perfect for you.

Benefits

Benefits starting from Day 1

Retirement Plan Matching

Flexible Paid Time Off

Wellness Support Programs

Parental & Caregiver Leaves

Fertility & Adoption Support

Continuous Development Support Program

Employee Assistance Program

Allyship and Inclusion Communities

Employee Recognition

Qualifications

• 3-5 years of experience in data migration and ETL processes.
• Proficient in SQL and scripting for process optimization.

Responsibilities

• Analyze and migrate data ensuring accuracy and integrity.
• Develop and optimize scripts to enhance migration performance.

Skills

SQL

ETL processes

Scripting (Python, PowerShell, Bash)

Data migration

Data quality assessment

Stakeholder collaboration

Education

Bachelor's Degree in Computer Science

Bachelor's Degree in Information Systems

Tools

MySQL

SQL Server

ADF

SSIS

Job description

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:

1. Analyze and assess data structures in source and target systems to develop effective migration strategies.
2. Migrate data from legacy systems to new platforms, ensuring data integrity, accuracy, and consistency throughout the process.
3. Handle multiple data migration projects in parallel, managing priorities and troubleshooting issues efficiently.
4. Develop, test and optimize scripts and processes to enhance migration performance and minimize downtime.
5. Write and optimize SQL queries for data extraction, transformation, and validation.
6. Identify data quality issues, perform data cleansing, and apply necessary information.
7. Collaborate with stakeholders to define data mapping, business rules, and validation checks.
8. Monitor and troubleshoot migration processes, ensuring timely and accurate data transfer.
9. Automate repetitive data migration tasks to improve efficiency and reduce manual effort.
10. Document data migration process, transformation rules, and troubleshooting steps for future reference.
11. Ensure compliance with data security, data governance, and regulatory standards.

Your Key Strengths:

1. Bachelor's Degree in Computer Science, Information Systems, or a related field.
2. 3-5 years of hands-on experience in data migration and ETL.
3. Proficient in SQL (MySQL, SQL Server), ETL tools (ADF, SSIS), and scripting (Python, PowerShell, Bash).
4. Experienced in automating data migration workflows.
5. Able to troubleshoot migration issues.
6. Strong in stakeholder collaboration.
7. Able to handle multiple projects in a fast-paced environment with minimal supervision.

Compensation: $89,000 - $100,000 a year. At PointClickCare, base salary is one of the many components that make up our total rewards package. The Canada base salary range for this position is $89,000 to $100,000 +10% performance-based bonus and full-time benefits. Our salary ranges are determined by job and level. The range displayed on each job posting reflects the target for new hire salaries for the position across all Canada locations. Within the range, individual compensation is determined by job-related skills and knowledge, relevant experience including professional and lived experience, and/or work location. Your recruiter can share more information about our total rewards package during the hiring process.

PointClickCare Benefits & Perks:

• Benefits starting from Day 1!
• Retirement Plan Matching.
• Flexible Paid Time Off.
• Wellness Support Programs and Resources.
• Parental & Caregiver Leaves.
• Fertility & Adoption Support.
• Continuous Development Support Program.
• Employee Assistance Program.
• Allyship and Inclusion Communities.
• Employee Recognition … and more!

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 [e-mail] 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. 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: [e-mail].

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.