Intermediate Database Analyst

Summary

Join PointClickCare as an Intermediate Database Analyst and contribute to multiple data migration projects. You will be responsible for migrating data, ensuring accuracy and efficiency. This role demands strong SQL, ETL, and scripting expertise. The ideal candidate possesses a Bachelor's degree and 3-5 years of relevant experience. PointClickCare offers a competitive salary, performance-based bonuses, and a comprehensive benefits package including retirement plan matching, flexible paid time off, wellness programs, parental leave, and more. This is a remote position.

Requirements

• 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

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

Benefits

• 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
• Benefits starting from Day 1!