Job Description

CAMH is seeking a skilled IT Specialist to join our Business Intelligence team. As Canada\xe2\x80\x99s leading mental health hospital, we are committed to harnessing data to drive business decisions and improve outcomes. The successful candidate will play a crucial role in developing, optimizing, and maintaining our data infrastructure and reporting solutions.Position DescriptionThe IT Specialist will be responsible for designing, implementing, and maintaining robust data solutions to meet the needs of our stakeholders. Working closely with cross-functional teams, the IT Specialist will leverage Microsoft SQL Server, SSRS, SSAS, SSIS and Tableau to develop data models, ETL processes, reports, and dashboards. The role will involve collaborating with business users, researchers and scientists to understand requirements, optimizing database performance, troubleshooting issues, and ensuring data accuracy and integrity.Key Responsibilities

• Design, develop, and maintain Microsoft SQL Server databases, data warehouses, and ETL processes.
• Create and optimize complex SQL queries, stored procedures, and functions to support data analysis and reporting requirements.
• Develop and maintain Tableau dashboards and reports to visualize data and provide insights to stakeholders.
• Design and implement reports in Microsoft SSRS for operational and analytical reporting needs.
• Build and maintain SSAS cubes for multidimensional analysis and data mining.
• Develop and maintain SSIS packages for data integration, transformation, and workflow automation.
• Collaborate with business users to gather requirements, understand data needs, and deliver solutions that meet business objectives.
• Perform data profiling, cleansing, and validation to ensure data quality and integrity.
• Monitor database performance, identify bottlenecks, and optimize query performance.
• Troubleshoot and resolve data-related issues in a timely manner.
• Document technical specifications, data models, and ETL processes.
• Stay up-to-date with industry trends and best practices in SQL Server, Tableau, and Business Intelligence technologies.

Qualifications

• Bachelor\'s degree in Computer Science, Information Systems, or a related field.
• Minimum of 3 years of experience as a SQL/Database Developer or similar role.
• Strong proficiency in SQL Server, including T-SQL programming, database design, and optimization.
• Experience with Tableau Desktop and Tableau Server or similar software suites for data visualization and dashboard development.
• Proficiency in Microsoft SSRS for creating and publishing operational and analytical reports.
• Experience with Microsoft SSAS for building and maintaining multidimensional models and cubes.
• Hands-on experience with Microsoft SSIS for ETL development and automation.
• Solid understanding of data warehousing concepts, dimensional modeling, and data integration techniques.
• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
• Proven ability to manage multiple tasks and priorities in a fast-paced environment.
• Experience working in Agile or iterative development methodologies is a plus.

Vaccines (COVID-19 and others) are a requirement of the job unless you have an exemption on a medical ground pursuant to the Ontario Human Rights Code.Please Note: This full-time, permanent position is part of the OPSEU Bargaining Unit.Salary Range: $40.73 - $54.94 per hourPlease click the apply button below.CAMH is a Tobacco-Free Organization.CAMH is fully affiliated with the University of Toronto and is a teaching hospital and research institute. As a CAMH employee, you will be expected to actively support CAMH\xe2\x80\x99s teaching and research activities, in addition to supporting the clinical work of the hospital.At CAMH, we strive to be an equitable and inclusive employer. Our commitment to equity is grounded in an institution-wide commitment to achieving a working, teaching, and learning environment that is free of discrimination and harassment.CAMH actively seeks candidates from First Nations, M\xc3\xa9tis and Inuit, racialized and LGBTQ2S+ communities, women, and people with disabilities (including people who have experienced mental health and substance use challenges).We encourage people from all backgrounds to apply to our positions.
We thank all applicants for their interest, however, only those selected for an interview will be contacted. Please inform us if you require accommodations during the interview process.Follow usKeep in touch with CAMHKeep your finger on our pulse - latest CAMH news, discoveries and ways to get involved delivered to your inbox.Please select a newsletter:Thanks for Subscribing.We look forward to keeping you informed, inspired and involved in all things CAMH.

CAMH