Database Analyst
PointClickCare
Mississauga, Ontario
5d ago

PointClickCare is the leading cloud-based software provider for the senior care market in North America. Driven by a passion for innovation and technology, we’re building solutions that have a true impact on people’s lives.

Recently named one of Deloitte’s fastest growing technology companies and Canada’s best managed companies, PointClickCare provides vast opportunities and a great culture for our employees.

PointClickCare is a dynamic environment to advance your career while performing meaningful work with great people.

Position Summary :

To ensure a successful no hassle implementation of client’s data migration with a focus on data quality and integrity of core configuration setup and data conversion.

Work directly with Project Management and Clients as a consultant on database related issues. Provide Support to other departments with production and non-

production database related tasks. Work with other Data Services team members to enhance and or optimize current processes.

Our team is growing, and we are hiring for 2Database Analysts! A full-time / permanent position, and an 18-Month Contract.

Key Responsibilities :

  • Advanced aptitude for analysis and interpretation of data
  • Advanced ability writing Transact SQL queries and stored procedures
  • Design, Develop and Test database objects to run ETL processes that support new clients’ implementation to PointClickCare software solutions and other business requirements using SQL Server 2005 / 2012 SSIS packages
  • Ensure all Data Services packages, stored procedures, scripts and functions are updated as business logics are upgraded to meet Wescom standards.
  • Work in partnership with clients and the project manager to establish business requirements and solutions.
  • Provides technical assistance to implementation teams
  • Work with application developers and other database administration staff to research, define, and correct application data related issues
  • Provide off-hour support approximately 25% of the time. This includes overnight and weekends where necessary
  • Required Experience :

  • Bachelor's Degree in computer Science or comparable education
  • 3-6 years Transact SQL or equivalent SQL Server Database Analyst related experience
  • 1-2 years’ experience with .Net development
  • 3-6 years’ experience with relational databases and data model concepts (data mining, data analyst)
  • 3-6 years’ experience with Designing, Developing, Testing, and Debugging SQL Server Integration Services (SSIS) packages
  • 3-6 years’ experience with designing, creating, testing and debugging Stored Procedures
  • 3-6 years’ experience working in a production environment
  • Experience with Database Administration, Backup and Restore, SQL Profiling and Job Scheduling
  • Strong interpersonal and client facing skills
  • Strong communication and documentation skill
  • Must possess the ability to prioritize and multitask in a fast paced environment
  • Proactive and able to self-direct their own learning
  • Must be able to makes effective decisions
  • Working at PointClickCare goes beyond the resume, because the work we perform makes a true difference in people’s lives.

    We build innovative healthcare technology for seniors and their caregivers that improve their quality of life and well-being on a daily basis.

    We believe work is so much more meaningful when you’re doing it with a higher purpose.

    For more information on PointClickCare, please visit us on and

    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.

    Apply
    Add to favourites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form