Senior BI Analyst

LifeLabs is the largest community diagnostics laboratory in Canada, serving the healthcare needs of Canadians for over 50 years. Our team members are truly centred around our customers, and we know that behind every lab requisition, sample being tested, or investment in technology is an individual and their family counting on us.

Consistently named one of Canada's Best Employers by Forbes, LifeLabs has also been recognized for having an award-winning Mental Health Program from Benefits Canada. The passion and commitment of over 6,000 diverse and innovative team members unites and motivates us to ensure our customers receive high quality tests and results that they can trust. Agile, customer-centred, caring and teamwork: we live these values every day in what we do to support our customers and healthcare providers, driving forward our vision of empowering a healthier you.

Reports to: Manager, Financial Business Systems

Purpose of the Role Own, maintain and enhance the end to end data flow, analytics and reporting within BI for Finance. Work with business stakeholders of various levels to provide insights and transform data to visualize key financial metrics and performance indicators. They will work with Finance and business stakeholders to provide support on system outputs such as reports, forecasts, KPIs and other data analysis.

The candidate will work cross functionally within Finance and IT for system updates, modifications, resolving system issues, and upgrades to identify and implement process improvement opportunities. They will work to provide documentation and training for users of Finance systems and provides end-user support as required.

This is a Full Time Remote role based in Ontario.

Core Accountabilities

• Take ownership of the PowerBI infrastructure and coordinate with Finance stakeholders to lead the development of data into dashboards, informative reports, and KPIs to enable strategic financial business decisions
• Act as the Subject Matter Expert in design reviews to ensure feasibility of requirements, quality and performance of data and solutions
• Work with Stakeholders to design, build, interact and conduct statistical analysis and hypothesis testing to improve forecasting, targeting and performance measurement
• Work with IT to continuously identify opportunities to automate, optimize and streamline ETL processes that will bring in efficiency in reporting and analytical environments
• Participate in a variety of data analytics and dashboard development projects including working within the project specifications, scope and deadlines. Lead and/or participate in all financial system application projects, upgrades and information gathering sessions
• Conduct gap analysis and make recommendations to management on improving BI functionality/usage
• Develop and maintain systems documentation.
• Maintain and develop configuration workbooks and end user guides
• Provide end-user support requests.
• Work with cross functional teams to resolve issues regarding finance reporting and analytics

Qualification and Skills

• Bachelor's degree or diploma (or equivalent experience) in related discipline
• Experience in the healthcare industry is an asset
• 5 - 7 years of experience in utilizing advanced data analysis tools (SAS, Alteryx, Excel, Open Source etc.)
• 5 - 7 years of experience in BI platform and data visualization tools (Power BI, etc.) with advanced knowledge of Power BI including DAX, Access Controls, Data Ingestion, and Complex Reporting
• Advanced knowledge of Power Query including M language, and be able to perform complex data transformations
• Experience in utilizing advanced SQL data extraction and manipulation tools (MS SQL)
• Superb analytical and conceptual thinking skills; to not only manipulate but also derive meaningful interpretations from data
• Knowledge of financial concepts such as budgets, reconciliations, forecasts, financial KPIs and accounting cycles
• Experience with data integration and data schema development, and database analytics
• Advanced MS Office skills (Excel, Word, Access, PowerPoint, Visio) including Macros
• Demonstrated experience working with Oracle Fusion Cloud ERP and EPM
• Strong attention to detail is essential in this role.

#LI SW1 #INDEED

This is a remote role.

Hiring Range: 78,300 - 99,800

The hiring range has been established, however, the final salary recommendation will be determined based off the level of experience, education requirement, external market conditions and internal equity.

In this position, you will be eligible for Lifelabs annual bonus.

Employee Benefits:

In this position, you will be eligible to participate LifeLabs' group benefits plan which is available to LifeLabs employees in accordance with the terms and conditions of those plans.

Retirement Savings Plan:

The LifeLabs plans provide members with an easy way to save for retirement. By participating in the plan, you receive contributions made to your account on your behalf from LifeLabs.

Vacation Entitlement:

In this position, you will be entitled to vacation. We promote a healthy work-life balance and expect your full vacation to be taken each year.

Employee Wellness:

LifeLabs offers an award-winning Wellness Program focused on supporting your total health and well-being under our physical, emotional, and financial wellness pillars. We have been recognized in the industry for our focus on mental health supports.

Employee Giving program:

Designed to support any employee who donates, fundraises or volunteers for a Canadian Registered Charity or Non-Profit Organization.

In addition, LifeLabs offers professional development and membership reimbursement, access to preferred rates and discount programs - WorkPerks, Home and Auto Insurance, Costco Membership, etc. - and Optional Health-related Benefits.

At LifeLabs, we strive to create an inclusive and equitable workplace where our team members and the communities we serve feel accepted, valued, and respected.

In accordance with LifeLabs' Accessibility Policy, the Accessibility for Ontarians with Disabilities Act, and the Ontario Human Rights Code, accommodations are available by request for candidates taking part in all aspects of the recruitment and selection process. For a confidential inquiry or to request an accommodation, please contact your recruiter or email careers@lifelabs.com.

We are committed to the ongoing development of our diversity, equity, and inclusion (DEI) program and have taken steps to strengthen our commitment to our team members and customers, to challenge ourselves to act with courage and integrity, and to create an environment where people can be their true selves.

At LifeLabs, we know that we are Stronger Together and that we will benefit from the unique perspectives and experiences that each team member offers.

Vaccinations are highly encouraged at LifeLabs'. Vaccinations may be mandatory for selected employees if regulated by provincial or regional governments, or through employer-led vaccination policies in the facilities we service. Please ensure you ask if this position requires the successful candidate to be fully vaccinated with the current Government approved COVID-19 vaccinations.