IT Specialist

1 week ago

Toronto, Canada Centre for Addiction and Mental Health Full time

Job Number: 929123

Category: IT

Positions Available: 1

Years Experience Required: 5

Location: Toronto, Ontario

Posted Date: Mar 20, 2024

EMPLOYMENT OPPORTUNITY

**IT Specialist**
**Business Intelligence Team**
**Information Management Group (IMG)**

**Position Description**

The 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 hour

**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’s 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.**

**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.

  • Document Control Specialist

    2 days ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    Document Control SpecialistToronto,ON REMOTEContractResponsibilities: Document Control Specialist for medical devices is responsible for managing and maintaining all documentation related to the development, design, and production of medical devices. This includes creating and updating documents such as design control plans, design history files, and...

  • Document Control Specialist

    1 day ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    ROLE - Document Control SpecialistLOCTION - Ontario, Canada,REMOTEContractJD:Document Control Specialist for medical devices is responsible for managing and maintaining all documentation related to the development, design, and production of medical devices.This includes creating and updating documents such as design control plans, design history files, and...

  • Xdr Specialist @toronto, On

    7 days ago

    Toronto, Canada Atlantis IT group Full time

    **Role - XDR specialist** **Location - Toronto, ON - Canada** **Duration - Long Term** 1. **Deploying and managing Palo Alto XDR solutions**: The XDR specialist is responsible for the installation, configuration, and maintenance of Palo Alto's XDR platform. This involves working with various teams to ensure proper setup and integration with existing...

  • Messaging Specialist

    1 week ago

    Toronto, Canada Atlantis IT group Full time

    **Title: Messaging Specialist** **Location: Toronto, ON****: - Remote/Hybrid** **Duration: Long Term** **Description: - ** **MANDATE**: **ACCOUNTABILITIES**: Delivers a highly available and stable messaging services environment Participates in assigned projects following effective requirements, design, development and implementation processes Analyzes...

  • Fah/ebs Platform Specialist

    2 weeks ago

    Toronto, Canada Atlantis IT group Full time

    **Role: FAH/EBS Platform Specialist** **Location: Toronto, ON** **Duration - Long Term** **Role**: 1.Extensive experience with E-Business Suite to holds overall accountability for technical delivery and implementation of projects involving installation, configuration and support 3. Provide production and user acceptance testing support to complex...

  • Business Development Specialist/Analyst

    2 days ago

    Toronto, Ontario, Canada Nationwide IT Services, Inc. Full time

    Nationwide IT Services, Inc. Business Development Specialist/Analyst Fairfax , Virginia Apply Now Business Development Specialist/Analyst Fairfax, VA · Government/Military Apply Now Hybrid Remote – 3 days onsite per week Position Overview: Nationwide IT Services is seeking a Business Development Specialist/Analyst to join our team in HQ. This...

  • Tvm Code Scanning Specialist

    3 weeks ago

    Toronto, Canada Atlantis IT group Full time

    **Job Title**:TVM Code Scanning Specialist** **Location: Toronto, ON** **Duration: Long Term Contract** - Conduct thorough code scanning and analysis using various tools with a focus on TVM (Threat and Vulnerability Management). Utilize expertise in SonarQube to perform code reviews, identify security vulnerabilities, and ensure code quality. Collaborate...

  • TVM Code Scanning Specialist

    3 weeks ago

    Toronto, Canada Atlantis IT Group Full time

    Role name: TVM Code Scanning SpecialistRole Description: - Conduct thorough code scanning and analysis using various tools with a focus on TVM (Threat and Vulnerability Management).- Utilize expertise in SonarQube to perform code reviews, identify security vulnerabilities, and ensure code quality.- Collaborate with development teams to provide...

  • TVM Code Scanning Specialist

    3 weeks ago

    Toronto, Canada Atlantis IT Group Full time

    Role name: TVM Code Scanning SpecialistRole Description: - Conduct thorough code scanning and analysis using various tools with a focus on TVM (Threat and Vulnerability Management).- Utilize expertise in SonarQube to perform code reviews, identify security vulnerabilities, and ensure code quality.- Collaborate with development teams to provide...

  • Tvm Code Scanning Specialist

    1 day ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    Job Title:TVM Code Scanning Specialist**Location: Toronto, ONDuration: Long Term Contract Conduct thorough code scanning and analysis using various tools with a focus on TVM (Threat and Vulnerability Management). Utilize expertise in SonarQube to perform code reviews, identify security vulnerabilities, and ensure code quality. Collaborate with development...

  • Data Quality Specialist

    2 months ago

    Toronto, Canada Hire IT People Inc Full time

    **Role - Data Quality Specialist** **Location: Toronto, Canada** **Duration: Fulltime** **Responsibilities**: - Work collaboratively with cross-functional teams, including engineering, operations, and business groups to ensure that all quality initiatives are aligned with the organization’s overall business objectives. - Responsible for defining and...

  • Sales Growth Specialist

    2 days ago

    Toronto, Ontario, Canada TRIELLA - Your IT Success Partner Full time

    _TRIELLA is an award-winning global MSP. We were ranked top 75 globally, top 3 in Canada and top 2 in Ontario in 2023 by Channel Futures. Come join our diverse and fun team_ABOUT USTRIELLA is a growing IT firm that is the trusted IT Success Partner of Canadian lower to middle market professional service firms (incl. law, accounting, engineering, architects),...

  • TVM Code Scanning Specialist

    3 weeks ago

    Toronto, Ontario, Ontario, Canada Atlantis IT Group Full time

    Role name: TVM Code Scanning SpecialistRole Description: - Conduct thorough code scanning and analysis using various tools with a focus on TVM (Threat and Vulnerability Management).- Utilize expertise in SonarQube to perform code reviews, identify security vulnerabilities, and ensure code quality.- Collaborate with development teams to provide...

  • Sales Growth Specialist

    2 weeks ago

    Toronto, Canada TRIELLA - Your IT Success Partner Full time

    _**TRIELLA is an award-winning global MSP. We were ranked top 75 globally, top 3 in Canada and top 2 in Ontario in 2023 by Channel Futures. Come join our diverse and fun team!**_ **ABOUT US** TRIELLA is a growing IT firm that is the trusted IT Success Partner of Canadian lower to middle market professional service firms (incl. law, accounting, engineering,...

  • Cyber Security

    7 days ago

    Toronto, Canada Atlantis IT group Full time

    **Cyber Security - XDR** **Toronto, ON** **Roles and responsibilities**: The job description for a Palo Alto XDR (Extended Detection and Response) role typically includes the following responsibilities: Deploying and managing Palo Alto XDR solutions: The XDR specialist is responsible for the installation, configuration, and maintenance of Palo Alto's XDR...

  • Cyber Security

    7 days ago

    Toronto, Canada Atlantis IT group Full time

    Role: Cyber Security - ESE-XDR Location: Toronto **XDR**: 1. Deploying and managing Palo Alto XDR solutions: The XDR specialist is responsible for the installation, configuration, and maintenance of Palo Alto's XDR platform. This involves working with various teams to ensure proper setup and integration with existing security infrastructure. 2. Monitoring...

  • Ese-xdr (Niche)

    3 days ago

    Toronto, Canada Atlantis IT group Full time

    **ESE-XDR (Niche)** **Toronto, Hybrid** **Long Term Contract** **Experience and qualifications**: "XDR 1. Deploying and managing Palo Alto XDR solutions: The XDR specialist is responsible for the installation, configuration, and maintenance of Palo Alto's XDR platform. This involves working with various teams to ensure proper setup and integration with...

  • ese-xdr

    2 days ago

    Toronto, Ontario, Canada Atlantis IT Group Full time

    Role: ESE-XDR Location: TORONTO, ONDuration - Long TermJob DescriptionESE-XDRXDR:Deploying and managing Palo Alto XDR solutions: The XDR specialist is responsible for the installation, configuration, and maintenance of Palo Alto's XDR platform. This involves working with various teams to ensure proper setup and integration with existing security...

  • Cyber Security

    1 day ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    Cyber Security - XDRToronto, ONRoles and responsibilities:The job description for a Palo Alto XDR (Extended Detection and Response) role typically includes the following responsibilities:Deploying and managing Palo Alto XDR solutions: The XDR specialist is responsible for the installation, configuration, and maintenance of Palo Alto's XDR platform. This...

  • Ese-xdr (Niche)

    1 day ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    ESE-XDR (Niche)Toronto, HybridLong Term ContractExperience and qualifications:"XDRDeploying and managing Palo Alto XDR solutions: The XDR specialist is responsible for the installation, configuration, and maintenance of Palo Alto's XDR platform. This involves working with various teams to ensure proper setup and integration with existing security...