Posted in

Intermediate Database Analyst

Intermediate Database Analyst

CompanyPointClickCare
LocationMississauga, ON, Canada
Salary$35 – $50
TypeContract
DegreesBachelor’s
Experience LevelMid 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