BI Developer

CMHA York Region & South Simcoe; Newmarket; On-site; CAD 70,000 - 76,000; Full time

Job summary

A mental health support organization in Newmarket is seeking a Business Intelligence Developer to analyze data and improve services. This role involves using SQL and Power BI to present actionable insights. The successful candidate will have a Bachelor's in Computer Science and relevant experience, with a focus on Agile project management and data-driven decision-making. A passionate data professional is needed for this full-time position.

Benefits

HOOPP (Healthcare of Ontario Pension Plan)

Robust Performance and Career Development program

Qualifications

• 3-5 years of relevant work experience analyzing, modeling, and presenting data.
• Experience using SQL to query, cleanse, and integrate data from various sources.
• Strong communication skills, both written and verbal.

Responsibilities

• Analyze data to provide insights for decision-making.
• Develop dashboards and streamline reporting for stakeholders.
• Interact with teams to gather requirements and offer recommendations.

Skills

Business Intelligence

SQL

Power BI

Data Modeling

Data Warehouse

Education

Bachelor's degree in Computer Science or related discipline

Tools

SQL Server

Python

VBA

Tableau

Cognos

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 organization cares about the growth safety and well-beingof employees and offers :

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

Learn more about us by visiting : 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 : $70864 - $75808 / 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 organizations 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

• Bachelors 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
• Excellent computer skills required including Microsoft Office
• 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 drivers license a minimum $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.

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse

Employment Type : Full-Time

Experience : years

Vacancy : 1

Create a job alert for this search