Top Benefits
Competitive Wages and Bonus Program
Comprehensive Benefits
Onsite Cafeteria
About the role
Who you are
- 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
What the job involves
- 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
- 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 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
Benefits
- Competitive Wages and Bonus Program
- Comprehensive Benefits
- Onsite Cafeteria
- Onsite Gym
- RRSP/401K program with employer matching
- Flexible Paid Time Off
- Work From Home Policy
- Maternity & Paternity Top Up
- Training and Development Programs
- Corporate Discounts Program
- Games Room and Employee Lounge
- Onsite Wellness Services (dental, massage, optometry, etc.)
About PointClickCare
Software Development
1001-5000
PointClickCare is a leading healthcare technology platform enabling meaningful collaboration and access to real‐time insights at every stage of the patient healthcare journey. More than 27,000 long‐term and post‐acute care providers, over 3,100 hospitals and health systems, over 3,600 ambulatory clinics, every major U.S. health plan, and over 70 state and government agencies use PointClickCare, enabling care collaboration and value‐based care delivery for millions across North America.
Top Benefits
Competitive Wages and Bonus Program
Comprehensive Benefits
Onsite Cafeteria
About the role
Who you are
- 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
What the job involves
- 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
- 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 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
Benefits
- Competitive Wages and Bonus Program
- Comprehensive Benefits
- Onsite Cafeteria
- Onsite Gym
- RRSP/401K program with employer matching
- Flexible Paid Time Off
- Work From Home Policy
- Maternity & Paternity Top Up
- Training and Development Programs
- Corporate Discounts Program
- Games Room and Employee Lounge
- Onsite Wellness Services (dental, massage, optometry, etc.)
About PointClickCare
Software Development
1001-5000
PointClickCare is a leading healthcare technology platform enabling meaningful collaboration and access to real‐time insights at every stage of the patient healthcare journey. More than 27,000 long‐term and post‐acute care providers, over 3,100 hospitals and health systems, over 3,600 ambulatory clinics, every major U.S. health plan, and over 70 state and government agencies use PointClickCare, enabling care collaboration and value‐based care delivery for millions across North America.