At a Glance
- Tasks: Evaluate business data needs and create impactful BI solutions using SQL and Power BI.
- Company: Join CAAT, a fast-growing pension plan known for its innovative culture.
- Benefits: Enjoy competitive salary, comprehensive benefits, and opportunities for personal growth.
- Other info: Collaborative workplace recognized as one of Canada’s best employers.
- Why this job: Make a real difference in retirement security while developing your skills in a dynamic environment.
- Qualifications: 5+ years of experience in data management and BI development, with strong SQL skills.
The predicted salary is between 80000 - 113800 $ per year.
At CAAT, we’re passionate about what we do. Here, you’ll find a cultural spark in everything we do – from the way we partner with members and employers, to the way we work, collaborate, and grow. We challenge the status quo, making a real impact on the hundreds of employers we serve – from education institutions to major corporations and household brands. Driven by core values and a shared purpose, we’re fierce champions for better retirement security, known for our can-do culture where everyone plays a role in bringing our vision to life.
About the Role:
We are seeking a Data Management Analyst to work closely with various stakeholders to evaluate business requirements from a data perspective and implement data integrations, data models, and BI reports aligned with business objectives. You will build advanced SQL scripts and programs, ETL pipelines, reports and dashboards within various platforms such as Oracle databases, MS-Fabric, Power BI and different enterprise IT systems.
As the Newest Member of our Team, You’ll:
- Develop and implement BI solutions using different frameworks, technologies and best practices.
- Create and manage datasets by writing scripts and programs using SQL, MS Excel and other reporting tools.
- Develop business-focused reports and dashboards using Power BI, leveraging data models aligned with organizational objectives.
- Design and Develop ETL processes and unit tests in a data warehouse environment.
- Measure and ensure Data Quality improvements by identifying and resolving Data Quality issues.
- Participate in data requirements analysis for new projects and enhancement requests and produce technical specification documentation.
- Support the overall BI and data solutions delivery and on-going operations.
- Effectively collaborate with team members and people from different departments with varying degrees of business and/or technical experience.
To Succeed, You Bring:
- A university degree or college diploma in related discipline or a combination of education, training and experience deemed equivalent.
- A minimum of five (5) years of experience in working with data warehouse, dimensional / semantic modelling and BI development.
- A minimum of five (5) years of experience with SQL (MS T-SQL or Oracle PL-SQL).
- Over two (2) years experience, Power BI development, DAX, Power Query, data modeling and dashboard design.
- Strong experience in analyzing varying levels of business needs and developing appropriate data models.
- Proven ability to communicate effectively clearly with team members and be able to convey technical concepts into clear, simple language.
- Excellent analytical thinking skills for translating data into informative visuals and reports.
- Ability to prioritize and manage multiple tasks in a fast-paced environment.
- Certifications in DP-600 Microsoft Fabric Analytics Engineer Associate or DP-700: Microsoft Fabric Data Engineer Associate are considered assets.
At CAAT, we believe innovation, passion, and purpose are ingredients for a great work environment. We’re incredibly proud of our people and the remarkable impact they have as catalysts for change. We’re committed to attracting and keeping great talent, which means competitive compensation, exceptional benefits, and an environment where people can grow and thrive.
When you work with CAAT, you’ll enjoy:
- Opportunities to Build a Better You: Enjoy a place that provides endless opportunities to learn and master your skills while cultivating new ones.
- Comprehensive & Holistic Care: Be at your best with a Total Rewards program that feeds and prioritizes your physical, mental, and financial wellness.
- A Place to Collaborate and Win: We’ve built a lively environment where creativity and open communication thrive.
- Work that Truly Matters: You’re giving Canadians the opportunity for better retirement security, and organizations the chance to do more.
If you believe that Canadians deserve a future where a secure lifetime retirement income contributes to their financial and overall well-being, then CAAT could be the right fit for you. Start your journey with us today. Apply now.
Learn more about us by visiting www.caatpension.ca/careers
Diversity, Equity, Inclusion, and Belonging (DEIB): 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.
Data Management Analyst in Toronto employer: CAAT Pension Plan
At CAAT Pension Plan, we pride ourselves on being an exceptional employer in the heart of Toronto, offering a dynamic work culture that fosters collaboration and innovation. Our commitment to employee growth is evident through comprehensive training programs and opportunities for advancement, all while managing a significant $25B portfolio that ensures meaningful contributions to our members' futures. Join us to be part of a team that values integrity, efficiency, and excellence in investment operations.
