Senior Business Intelligence (Bi) Specialist

We believe that everyone has the right to a rewarding career with an organization that values and invests in your growth.

Are you looking for an energetic, high-performance culture that’s truly one of a kind?

How would you like to work in a fun, high-performance culture that’s truly one of a kind – on a team that appreciates your ideas, helps our members retire with confidence and makes Canada better, all at the same time?

If that sounds like your thing – and you’re an outstanding Senior Business Intelligence Specialist– let’s talk!

We’re CAAT Pension Plan, and we’re growing. We innovate defined benefit (DB) pension plans. What are they? Unlike other pension plans, they specifically define the lifetime benefits our members will receive in retirement. This means that once they retire, our members know exactly what they’re getting every month– for life! As a socially conscious company, we’re passionate about helping more Canadians retire with greater financial security and peace of mind.

This position is integral to the success of the Enterprise Data Management team, and to CAAT’s guiding mission and growth strategy.

As a BI Specialist, you will develop business intelligence (BI) and reporting solutions within Power BI/Microsoft Fabric platform. You will perform full business intelligence or data development lifecycle activities including business intelligence requirements analysis, data modelling, data integration, and data visualization. This position will report to the Director of Enterprise Data Management.

We are looking for someone with:

• Professional data certifications from a major data platform vendor like Microsoft, Informatica, Google, AWS, IBM, etc.
• Over eight (8) years of experience in data engineering, data modelling, data analysis and BI development.
• A minimum of three (3) years of experience in Power BI development and dashboard design.
• A degree in business, engineering, systems design, computer science, or a related discipline – or a combination of education, training and experience deemed equivalent.

The successful candidate will demonstrate:

• Experience developing technical solutions for complex business data problems.
• Strong communication, collaboration, and leadership skills.
• Advanced Power BI visualization and interactive design (using buttons, bookmarks, drill through, tooltips, etc.).
• Advanced DAX skills (calculate with multiple filter modifiers, variables, time intelligence, moving and running totals, calculation groups, etc.).
• Advanced Power Query Skills (M scripts and functions, query folding, merge/append/reference queries, variables and parameters, custom functions, etc.).
• Experience and strong understanding of SQL, ETL, data analysis and data modelling to interpret data, analyze results and identify trends or patterns in complex data sets.

Once here you will:

• Develop, maintain, and monitor Power BI premium dataflows to load, transform and democratize data assets.
• Design and develop tabular data models in Power BI using star schema, dimensional modeling principles and advanced DAX techniques.
• Ensure data quality by identifying and resolving data quality issues.
• Provide technical leadership to the data management team in designing and developing sound data management solutions.
• Collaborate with business users, data architects and data analysts to understand data & analytical needs, KPIs and develop solutions that can support ongoing and future analytical capabilities.
• Promote Power BI design best practices and conduct workshops at individual team levels and at enterprise level.
• Develop advanced SQL scripts to extract and prepare data from various sources.

What will CAAT offer you?

• Hybrid work arrangements for eligible employees and a collegial work environment.
• Opportunities to connect with senior leadership in a variety of informal settings for discussions, sharing, and mutual learning.
• We invest in our people and enthusiastically support your career development goals, regardless of your role, with access to tuition aid and learning opportunities like our ground-breaking CAAT Academy.
• We encourage you to learn more about us at www.caatpension.ca.
• Mental Well-Being: We provide an array of wellness programs including extended mental health benefits. We also offer generous paid time off to promote rest and relaxation.
• Financial Wellness: We provide a defined benefit (DB) pension plan (no big surprise here!).
• Physical Wellness: We provide a very competitive and comprehensive extended health and dental benefits including life insurance.
• We are conveniently located at the Eaton Centre in downtown Toronto, next to Queen subway station, with ready access to multiple TTC routes, GO Transit, and the PATH from Union Station.
• On-site gym and shower facilities; meditation/prayer room and cool collaboration spaces including electronic sit/stand desks.

If you meet most of the criteria above, we would love to connect with you. Please click onto “APPLY” above to easily submit your candidacy or email your resume to [email protected]. with Senior Business Intelligence (BI) Specialist in the subject line.

The success of our company is dependent on fostering a culture of embracing diversity, equity, and inclusion in everything we do. All employees are guided by our Mission, Values, and Code of Conduct.

CAAT Pension Plan is an equal opportunity employer, and we will accommodate any needs under the Accessibility for Ontarians with Disabilities Act and the Ontario Human Rights Code. Hiring processes will be modified to remove barriers to accommodate those with disabilities, if requested. Should any applicant require accommodation through the application processes, please contact us at [email protected] or call Human Resources at 416-673-9000 for assistance.