Senior Analytics and Reporting Specialist

TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider – encompassing physical, mental and financial health – TELUS Health is improving health outcomes for consumers, patients, healthcare professionals, employers and employees.

The BI Developer role requires an individual with a minimum of 3-5 years of experience, who possesses a breath of analytical and data skills. The candidate must be passionate about data and process efficiency. The candidate must be able to communicate effectively with team members and have an understanding of data analysis, data analytics, reporting, dashboarding, and data modeling. They must have a technical background in data analysis, data preparation, and experience developing Reporting/Dashboarding solutions on top of Data Lakes and Data Warehouses.

Responsibilities:

• Fully understand the business goals of each project assigned

• Gather requirements and develop report/dashboard specification documents

• Fully understand the overall data structure of source systems and interaction of data tables in order to accurately develop reports/dashboards

• Design and write automated SQL Jobs/Scripts to perform a variety of functions

• Fully test and QA all new jobs, as well as enhancements to existing jobs, to ensure seamless integration with production environment

• Using SQL Reporting Services, make enhancements to Morneau Shepell's standard reporting

• Using SQL Reporting Services, design custom client and program-specific reports to meet specific business needs of internal account teams, as well as client contacts

Qualifications:

• Degree in Computer Science, Mathematics / Statistics, Engineering, Business Administration, or related field from an accredited college or university

• 3-5 years Microsoft Power BI experience

• 3-5 years’ SQL Server Reporting Services (SSRS, SSAS, SSIS) experience

• 3-5 years’ Data Mart development/modeling experience

• 3-5 years’ developing solutions using standard RDBMS, No-SQL, semi-structured data sources such as SQL Server, MongoDB, Dyanmo DB, Redis, JSON, etc.

• Expert-level SQL query development (T-SQL) and stored procedures

• Strong analytical and data manipulation skills to enable production of management information

• Experienced in estimating complexity, time and effort, planning and worked closely with Project Managers to successfully meet requirements and timelines

• Experience with data processing flowcharting techniques

• Ability to develop and maintain strong relationships with key contacts

• Strong proficiency in Windows 2010 and Microsoft Office applications (Excel, Word, PowerPoint, and Access)

• Demonstrated clear and effective professional communication skills, both written and verbal

• Outstanding attention to detail, and the ability to uphold high quality control standards

• Excellent analytical thinking and problem-solving abilities

• Exceptional interpersonal, organizational, prioritization, and follow-up skills, with a strong commitment to being a team player and meeting the client’s needs

• Ability to work through complex issues in order to meet deadlines for deliverables

• Ability to demonstrate a sense of urgency, resourcefulness, responsibility and accountability

Nice to have:

• 3-5 years’ Cognos Analytics experience (Cognos Dashboards, Report Studio, Cubes, Framework Manager)

• 3+ years developing solutions for use on Cloud platforms

#LI-CL2

Where permitted by law, company employees must be fully immunized to access a TELUS Health or LifeWorks office or customer premises.

Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to talentacquisitiononboarding@lifeworks.com.

By applying to this role, you understand and agree that your information will be shared with the TELUS Group of Companies’ Talent Acquisition team(s) and/or any leader(s) who will be part of the selection process.