POSITION TITLE Senior Business Intelligence Developer SHIFT TYPE Monday-Friday DEPT/PROGRAM Data Analytics JOB CLASS Database Specialist EMPLOYMENT TYPE Temporary Full Time up to 12 months RATE OF PAY $46.24-$56.31 per hour WORK SCHEDULE 37.5 hours a week EMPLOYEE GROUP OPSEU POSTING TYPE Open POSTING DATE October 18, 2024 HYBRID ELIGIBLE Yes NUMBER 1 Waypoint Centre for Mental Health Care is a 315-bed academic and teaching hospital that provides specialized mental health, addiction and geriatric care. Located on the shores of Georgian Bay, we serve some of the most complex and disadvantaged individuals in Ontario and are the sole provider of high-secure forensic mental health services in the province. The Director of Data Analytics is currently seeking a temporary full-time Senior Business Intelligence Developer. The purpose of the position is to support Waypoint's data analytics and business intelligence program including responsibility for designing, modeling, developing, maintaining and enhancing Waypoint's data environments and tools/solutions. This role will also support reporting, analytics and business intelligence/decision support solutions to meet the information needs and strategic goals of the organization. Please Note: This position offers a hybrid work environment consisting of three in-office days a week as well as remote work. The office location is: 500 Church St. in Penetanguishene. KEY ACCOUNTABILITIES: Develop and maintain an overall data architecture, design principles, quality control, and data standards for the organization that supports the information needs of the business in a secure environment following best practice guidelines Manage Enterprise data warehouse, ETL processes, SQL replication and data transformations as required to support requests in on premise and cloud based environments. Conceptualize and guide data requirements including initiation, oversight and evaluation of projects, initiatives and operations. Develop and maintain data models, data dictionaries, data maps and other artifacts including conceptual and physical models, as well as metadata repository. Create and maintain documentation of business requirements including functional and technical specifications and access controls. Maintain and document standard operating procedures related to Data & Analytics environments including databases, reporting platforms, and supporting applications. Analyzes data and develops reports (and other data and analytics solutions) as assigned to support requests and business needs. Maintains a solid working knowledge of business intelligence/decision support industry trends and best practices. Supports, follows and contributes to information governance and data standards established by the organization Assists the Director of Data Analytics in the development and implementation of an annual data and analytics work plan Maintains current knowledge of data and analytics leading practices in healthcare and provides coaching and mentoring to team members Serves as a project lead for assigned projects and quality improvement initiatives, including developing, monitoring, and reporting tools Maintain and develops materials to enhance work performance, such as communications, reference material, and reporting tools Demonstrate the core values of the organization, Caring, Respect, Accountability and Innovation at all times Performs all work at all times in compliance with all hospital policies and procedures and legislation (Occupational Health &Safety Act, Fire Code, WHMIS, etc.) relevant to health and safety, security (including relational/therapeutic security) and potential risk hazards, and in particular, "duties of the worker" as defined in Section 28 of the OH&S Act. Minimum 5 years' experience in Senior Developer positions Preference for proficiency in French/English language skills REQUIRED SKILLS: Tools: SQL Server, Power BI/MS Fabric, Azure Data Factory IDE: SSMS, Visual Studio, VS Code, Azure Data Studio, Power BI Desktop Programming Languages: T-SQL, C#, Python Code Repository Tools: Git, GitHub, Azure DevOps Cloud-Based Tools: MS Azure, MS365, AWS, GCP Other: REST APIs, Project Management Tools HOW DO I APPLY? Waypoint employees apply through the Employee Self-Service portal at and external applicants apply to by close of business (4:00 pm) on October 28, 2024 quoting WC24-299. Attach your cover letter and resume detailing why you are interested in this opportunity and how you meet the qualifications and key accountabilities specified. #Information Technology jobs