Business Intelligence Analyst - Decision Support

Open:           May 7, 2022

Deadline:      May 20, 2022

Non-Union

Department Name

Decision Support

Reporting to Manager, Decision Support, the Business Intelligence Analyst plans, designs, develops, tests and maintains business intelligence (BI) products to support LHSC’s business intelligence platform, including tables, views, cubes and report delivery and infrastructure. This requires communication skills to determine the customer’s needs, extensive knowledge and experience in the Microsoft BI Stack (SSIS, SSRS, SSAS), very good knowledge of T-SQL, technical expertise to design and implement the solution while adhering to the SDLC, and precise attention to detail to test and validate the end product

The Business Intelligence Analyst designs and implements expansions to existing products, creates new products as per high level design documents, and troubleshoots technical and/or software problems related to the use of BI products and implements solutions. The Business Intelligence Analyst is a high level technical expert and is also an effective collaborator and team member; capable of acting as team lead on projects, as well as mentoring less experienced staff.

Regular Full-Time

Rate of Pay:      $37.35 per hour - $46.69 per hour

Hours of Work:   37.5 hours per week 

Qualifications

• Successful completion of a 3 Year College Diploma or Bachelor’s Degree (preferred) in Computer Science, Computer Engineering or Software Engineering
• Structured Query Language (SQL) Certification preferred
• Minimum four (4) years recent, related job experience
• Demonstrated advanced technical and programming skills
• Demonstrated advanced understanding of relational databases, i.e. Oracle, MySQL, Sybase, MS*SQL, Interbase, and MS Access
• Advanced knowledge of Programming Languages: SQL (required), additional desirable: MDX, C#, Java and JSP
• Demonstrated advanced knowledge of productivity tools such as MS Excel, MS Word and Tableau
• Advanced experience with project management (milestones, outcomes and deliverables)
• Demonstrated advanced testing methodology
• Proficient knowledge of clinical process and nomenclature
• Demonstrated advanced experience in design, modeling and documentation in BI and data warehousing
• Advanced verbal and written communication skills
• Excellent organizational and time management skills to effectively coordinate multiple deadlines and conflicting priorities
• Advanced attention to detail
• Ability to be flexible, adaptable and manage change effectively
• Commitment to excellent customer service
• Demonstrated ability to synthesize ideas and communicate complex concepts to audiences with or without technical expertise
• Ability to work independently and collaboratively as a working member of a team
• Ability to work well under pressure, with strong problem solving and troubleshooting skills
• Demonstrated practice and commitment to the principles of patient and family centered care
• Demonstrated practice and commitment to patient and staff safety at LHSC
• Demonstrated practice and commitment to LHSC’s Mission, Vision and Values
• Demonstrated ability to attend work on a regular basis

Immunization Requirements:

• Successful candidates will be required to complete a health review which includes providing vaccination records or proof of immunity against Measles, Mumps, Rubella and Varicella (Chicken Pox). In addition, candidates will need to provide documentation of Tuberculosis Skin testing and a completed COVID vaccine series (two vaccines).

We are committed to providing a safe, healthy and inclusive work environment that inspires respect. LHSC is committed to employment equity and diversity in the workplace and welcomes applications from women, visible minorities, Indigenous people, persons with disabilities, and LGBTQ2+ persons. We are committed to providing persons with disabilities equal opportunities and standards of goods and services, and are also fully compliant with the Accessibility for Ontarians with Disabilities Act (2005), as applicable.

As part of the assessment process applicants may be required to complete a written examination or test. Please be advised that a reference check may be conducted as part of the selection process.

Your interest in this opportunity is appreciated. Only those applicants selected for an interview will be contacted. Successful candidates, as a condition of job offer, would be required to provide a satisfactory police information check (original document) completed in the last 3 months.