BI Developer

CMHA - Newmarket; Newmarket; On-site; CAD 70,000 - 76,000; Full time

Job summary

A leading organization focused on mental health support is seeking a Business Intelligence Developer for a one-year contract. The role involves analyzing data, developing dashboards, and improving data-driven insights to support management decisions. Candidates should have a bachelor's degree in a related field and experience in data analysis using SQL and Power BI. A commitment to inclusivity and diversity is emphasized in their hiring process.

Benefits

Healthcare of Ontario Pension Plan

Robust Performance and Career Development program

Qualifications

• 3-5 years relevant experience in data analysis and modeling.
• Proficiency in SQL and data visualization tools like Power BI.
• Effective interpersonal and communication skills.

Responsibilities

• Analyze data to provide insights for decision-making.
• Ensure data integrity by querying, cleaning, and validating datasets.
• Develop dashboards and streamline reporting for stakeholders.

Skills

Data Analysis

Statistical Analysis

Data Visualization

Data Mining

Interpersonal Skills

Communication Skills

Education

Bachelor’s degree in Computer Science, Science, or Math

Tools

SQL

Python

VBA

Power BI

Job description

We are a team committed to our vision of mental health support for all. We offer an inclusive, innovative and high-performance work culture that helps us deliver transformational impact. The organization cares about the growth, safety and well-being of employees and offers :

• HOOPP (Healthcare of Ontario Pension Plan)
• Robust Performance and Career Development program

Learn more about us by visiting :

We are looking for a Business Intelligence Developer to join our team!

1 Year Contract, 35 hours per week with possibility of extension.

Location : The primary location for this role will be our Newmarket Office at 1101 Nicholson Road, Unit 5. There may also be travel to our other satellite offices located throughout York and South Simcoe. Some evenings and weekends could be required.

Salary : $70,864 - $75,808 / annum.

• Candidate experience will be considered when determining the starting salary. This salary represents the first 3 steps in a 7-step salary band.

Job Profile :

The Business Intelligence (BI) Developer analyzes data to provide insights that aid decision-making, improving services and expanding client reach. Responsibilities include data quality, validation, cleaning, testing, transformation, and both quantitative and qualitative analysis.

The BI Developer utilizes various tools such as programming, statistical software, dashboards, mapping software, process automation, and machine learning to analyze relational, unstructured, and spatial data, presenting findings to managers and directors.

The role involves working on strategic and operational projects with both internal and external stakeholders, focusing on areas like mental health treatment effectiveness, internal operations, and new data-driven initiatives. The BI Developer applies Agile project management methodologies to gather requirements, design analysis, develop solutions, and deploy to stakeholders.

DUTIES :

Role and Responsibilities :

Interact cross-functionally with a variety of teams and executives within CMHA by applying project management such as Agile to identify requirements and offer recommendations for data and statistical analysis, uncover data insights, and presentation of information.

Measure healthcare outcomes over time to statistically demonstrate the effectiveness of treatments and protocols.

Develop strategic and operational plans to access fit-for-purpose data sources, support evidence generation, identify data quality issues, and define validation rules to assure data integrity and usability.

Query, clean, and validate data; analyze and present descriptive information; and design and implement statistical models for decision-making.

Identify solutions to data-driven business problems and find opportunities to create value using statistical techniques.

Design and develop dashboards, streamline reporting, and provide stakeholders with easy access to actionable insights.

Understand and query database tables from various sources such as Health Information Systems and understand the flow and use of data within these systems.

Combine relational, structured, unstructured, and spatial data for analysis and data mining.

Continuously learn about tools, techniques (e.g., machine learning), and best practices for data cleaning, analysis, mining, and presentation.

Work independently and collaboratively, managing workload while engaging with the data science community and participating in cross-functional working groups.

Organizational Effectiveness

• Develops tasks, systems, and processes to facilitate the overall effectiveness and operations of CMHA
• Contributes to the organizational growth of CMHA by identifying organizational needs, and works with the Management Team to achieve performance improvement
• Translates complex workflow requirements into cost-effective, user-friendly solutions specific to the program or service
• Communication and Public Relations
• Establishes and maintains open communication with the IT Manager, on relevant issues and exceptional, or precedent-setting issues
• Represents CMHA externally at meetings and on committees and may be required to conduct presentations
• Educates other health professions, community health and social agencies, and the public regarding data and analysis

Policies, Procedures and Legislations

• Operationalizes the organization’s Vision, Mission, Values and goals as outlined in its strategic plan
• Adheres to organizational policies and procedures, especially as they relate to human resources
• Demonstrates understanding of, and adherence to organizational policies and procedures, including but not confined to the Health and Safety Program, Anti-discrimination and Anti-Harassment and Workplace Violence policies
• Is familiar with, and adheres to relevant provincial legislation

The above statements are intended to describe the general nature and level of work being performed by the incumbent(s) of this job. They are not intended to be an exhaustive list of all responsibilities and activities required of the position.

KNOWLEDGE, SKILLS, AND ABILITIES

Education

• Bachelor’s degree in Computer Science, Science, Math or related discipline

Prior Work Experience

• 3-5 years of relevant work experience analyzing, modeling and presenting data using SQL, Python, VBA, Visualization (Power BI) and understand how data is created and used in various business applications such as CRM, Financial Systems and Health Information Systems
• Experience using SQL to query, cleanse, integrate and aggregate data from various sources

Skills

The incumbent must have demonstrated skills in the following areas

• Data and Statistical Analysis, data mining and visualization of information
• Research skill on application, tools, techniques, analysis best practices
• Hardware / Software tools as it impacts workflow
• Effective interpersonal, communication, and public relation skills
• Proficiency using SQL to query, cleanse, integrate and aggregate data from various sources
• Exceptional technical skills related to working database models
• Excellent administrative and organizational skills, with attention to detail
• Excellent communication skills, both written and verbal, including the ability to display and explain complex analyses in an easily understood user-friendly manner geared to the target audience
• Ability to work co-operatively with all levels of staff, management and external stakeholders
• Strong process, detail, and customer service skills
• Passion for working with data

Additional Requirements

• A valid Canadian driver’s license, a minimum $1,000,000 third party liability insurance
• A satisfactory Police Check

Working Conditions

Include physical effort, physical environment, sensory attention, and mental stress)

• Works extensively at a desk using a computer for up to 7 hours a day
• Works in a semi private office setting
• Occasional weekend / evening hours may be required
• Occasional lifting of up to 15 pounds

DISCLAIMER

In keeping with mental health reform, best practices, funding and direction this position may later require knowledge, skills, abilities and working conditions not noted here.

Application Procedure : If you are interested in this opportunity, please visit and search for Business Intelligence Developer Job Posting. Click on the “Apply Now” button and proceed to upload your cover letter and resume.

Complete the application form and submit the following :

• Optional Cover letter with 300 words or less and tell us why you would want this role and why you should be considered for the position (PDF or Word)
• Resume (PDF or Word) ( submissions received without a resume will not be considered)

CMHA-YRSS is dedicated to promoting employment equity and dismantling obstacles to employment for marginalized communities. CMHA-YRSS supports the journey to mental wellness, and we welcome applicants with lived experience of mental illness. In acknowledgment of the systemic underrepresentation faced by Black, Indigenous, racialized peoples, and those living with disabilities, this opportunity has been developed based on the special program provisions of the Ontario Human Rights Code. We therefore extend invitations for applications from the following groups :

• Racialized Persons
• Persons living with Disabilities

While we thank all candidates for their interest, only those selected for an interview will be contacted.