Our mission is to provide a secure, valuable, and sustainable workplace retirement solutions for Canadians. At CAAT, we live our values of integrity, impact, and teamwork every day.
The Senior Business Intelligence Specialist is integral to the success of the Enterprise Data Management, and to CAAT’s guiding mission and growth strategy.
As a Senior Business Intelligence Specialist, you will develop business intelligence (BI) and reporting solutions within the Power BI Service platform. The ideal candidate will have a strong background in data modeling, SQL, Power BI tabular design (star schema), Power Query, DAX, visualization, and data quality management. You will be responsible for designing and developing Power BI datasets, reports and dashboards that meet business needs. You will also be responsible for ensuring that data is accurate, consistent, and of high quality. This position will report to the Director of Data Management.
We are looking for someone with:
- Completion of a degree in Business, Engineering, Systems Design, Computer Science, or a related discipline, or a combination of equivalent education, training, and experience.
- 8+ years of experience in data engineering, data modeling, data analysis, and BI development, with a strong emphasis on ETL processes and reporting design.
- 3+ years of experience in Power BI development and dashboard design.
- Professional data certifications from a major vendor (e.g., Microsoft, Informatica, Google, AWS, IBM).
- Excellent communication skills to convey complex technical concepts to non-technical stakeholders.
The successful candidate will demonstrate:
- Experience and a strong understanding of SQL, ETL, data analysis and data modelling to interpret data, analyze results and identify trends or patterns in complex data sets.
- Experience developing technical solutions for complex business data problems.
- Advanced Power Query Skills (M scripts and functions, query folding, merge/append/reference queries, variables and parameters, custom functions, etc.).
- Advanced DAX skills (calculate with multiple filter modifiers, variables, time intelligence, moving and running totals, calculation groups, etc.).
- Advanced Power BI visualization and interactive design (using buttons, bookmarks, drillthrough, tooltips, etc.).
- Strong communication, collaboration and leadership skills.
- A commitment to staying updated on trends and advancements in data management and BI technologies.
Once here you will:
- Design and develop ETL processes using data warehousing models and technics.
- Design and develop tabular data models in Power BI using star schema, dimensional modeling principles and advanced DAX techniques.
- Develop, maintain, and monitor Power BI Premium Dataflows to load, transform and democratize data assets.
- Develop advanced SQL scripts to extract and prepare data from various sources.
- Provide technical leadership to the data management team in designing and developing sound data management solutions by leading design meetings, assigning tasks and performing peer reviews.
- 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.
- Ensure data quality by identifying and resolving data quality issues.
Step into CAAT - where your work is both rewarding and meaningful, growth is a constant, fun is the way we roll, and your impact is real! If you meet most of the criteria above, we would love to connect with you.
Our commitment to you as a CAATster:
We’re about growing together and creating impact in a collaborative and caring environment!
- Comprehensive & Holistic Care: Your dedication deserves appreciation! At CAAT, we celebrate the complete you, prioritizing your well-being above all. Our all-encompassing employee programs are designed to cater to every aspect of your life and well-being, ensuring you feel cherished and valued. We provide a competitive Total Rewards program based around your physical, mental, and financial wellness. This includes, but is not limited to, your compensation, paid time off, health and dental benefits, wellness programs, wellness incentives, and (of course) a defined benefit pension plan.
- Growth Opportunities: Embrace a vibrant, ever-evolving environment at CAAT, where growth is not just a goal, but our way of life! We're expanding and transforming constantly, which means endless opportunities for you to adapt, innovate, and learn. As we grow, so do you. Let’s make a difference together!
- A Culture of Collaboration and Fun: We're a team that works, grows, and celebrates together. At CAAT, you belong to a collaborative, inclusive and lively environment that sparks creativity and fosters open communication.
- Making a Difference, Together: We're on a mission to secure a better future for Canadians. Your meaningful contributions go beyond the workplace, touching lives and making a significant societal impact. Work that truly counts!
But don't just take our word for it! We’ve consistently been recognized as one of Canada's Most Admired Corporate Cultures, as one of Greater Toronto's Top Employers, and one of the Best Places to Work.
Learn more about us by visiting www.caatpension.ca/careers
Diversity, Equity, Inclusion, and Belonging:
Diversity, Equity, Inclusion, and Belonging (DEIB) at CAAT means we respect and value the broadest range of experiences, geographies, gender, ethnicities, backgrounds, and perspectives as key elements of our culture. Our vision is to provide an environment where employees can bring their best, professional, authentic, selves to work.
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.
Job Type: Full-time
Application question(s):
- How many years of experience do you have with ETL design processes, data modeling concepts, and Power BI report designs?
- How many years of experience do you have establishing and implementing best practices and standards in data management, including ETL processes, data modeling, and reporting tools like Power BI?
- How many years of experience do you have providing technical leadership to a team of data analysts in ETL design, data modeling, and Power BI report development?
- This is a hybrid position. Are you comfortable commuting to our office located in Downtown Toronto?
Work Location: Hybrid remote in Toronto, ON
