Skip to content

Intermediate Database Analyst
Company | PointClickCare |
---|
Location | Mississauga, ON, Canada |
---|
Salary | $35 – $50 |
---|
Type | Contract |
---|
Degrees | Bachelor’s |
---|
Experience Level | Mid Level, Senior |
---|
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
- 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
Preferred Qualifications
- Exposure to AI tools and a desire to leverage them to enhance your work content and user experience