PointClickCare is a leading North American healthcare technology platform enabling meaningful care collaboration and realtime 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 2200 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 Canadas Most Admired Corporate Cultures PointClickCare leads the way in creating cloudbased 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 youll 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 detailoriented 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:
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
Your Key Strengths:
Bachelors Degree in Computer Science Information Systems or a related field
35 years of handson 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 fastpaced environment with minimal supervision.
#MGLI1
#Remote
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 should you require any accommodations.
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.