Business Intelligence Developer

PointClickCare - Mississauga, ON (6 months ago)

Apply Now

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 build innovative healthcare technology for seniors and their caregivers that improve their quality of life and well-being on a daily basis. 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. We believe work is much more meaningful when you're doing it with a higher purpose. For more information on PointClickCare, please connect with us on Glassdoor and LinkedIn.

Position Type:
Co-op Student (Summer 2020 Work-term)

Reporting to the Director of Business Intelligence, the Business Intelligence Developer I plays an important role as a supporting member of the Business Intelligence department and the broader employee base of PointClickCare. Customer service and a positive, supportive, personality are essential to the success of this role. This role will provide you the opportunity to gain exposure to some of the core systems and tools that help run our business. You will learn various data transformation and analytical tools such as MS SSIS, MS SSMS, SQL Server, PowerBI.

Key Responsibilities:
  • Engage technology and business leaders to leverage business tools to solve real world business challenges
  • Supporting the existing Business Intelligence environment through job trouble shooting
  • Documenting existing Business Intelligence configurations
  • Designs, prototypes, codes and tests new or enhanced SQL queries
  • Performs customer support processes and activities for the implementation of new or existing applications
  • Monitors the efficiency and effectiveness of application operations and troubleshoots problems, as necessary
  • Learn and be involved in different phases of project plan (Business Requirements to Solution Delivery)
  • Evaluating new products and services to judge their suitability for use
  • Preliminary research and investigation of software and evaluating new products and services to judge their suitability for use
Desired Skills & Experience:
  • Enrolled in a Business, Computers, Engineering, or IT related co-op program
  • Motivated learner with the eagerness to work with data
  • Exposure in ETL and Data Integration, Data Profiling, Data Modeling
  • Knowledge of SQL
  • Experience with SQL Server, SSIS, SSMS, Visual Studio or ETL tools
  • MS Office Applications (Excel), Strong Excel experience (macros)
  • Workflow design and implementation
  • Scripting experience
  • Demonstrating strong written and verbal communication
  • Critical thinker, problem solver, with the ability to pursue help when required
  • Experience composing project documentation (e.g., high level use cases, detailed business specifications)
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. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.

When you apply for a position, your information is processed and stored with Lever, in accordance with Lever’s Privacy Policy. We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it. If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare’s human resources team here