CAAT Pension Plan

We believe that everyone has the right to DEFINE themselves and their future.

That includes YOU.

How would you like to do it in a fun, high-performance culture that’s truly one of a kind – on a team that appreciates you for being you, 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 exceptional Data Management Analyst (18 month contract) – we’d like to hear from you.

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 our members know exactly what they’re getting every month – for life! Because we provide that certainty, we help more Canadians retire with greater financial security and priceless peace of mind and take pressure off the social safety net at the very same time, which frees up those resources for other Canadians who really need them.

 Reporting to the Manager, Data Management, this position is responsible for the integration of data from various sources. The Data Management Analyst will assist users, and other stakeholders, by extracting and interpreting data from various systems, providing management reports and statistics to enable business decision making. By using various automated data mining, data analysis/interpretation and ETL methods, the Data Management Analyst will extract, analyze, and evaluate information that is stored across various systems in order to provide support for decision making as well as support for various business processes. The Data Management Analyst will work closely with pension system stakeholders to evaluate business requirements from a data perspective to support enhancements to the pension administration system as well as other systems that interface with it. The Data Management Analyst brings expertise in automated methods of data analysis using various enterprise systems.

We are looking for someone with the following attributes:

• Experience in Integration with external data sources including Oracle databases, Flat files, XML files, Excel files, various APIs.
• Good comprehension of financial data.
• Expert knowledge of Structured Query Language including experience using Oracle or Microsoft SQL Server database.
• Experience in at least one high level (either 3GL or 4GL) programming language.
• Experience using various automated ETL methods including scripting and programming familiarity.
• Proficiency in the use of various Business Intelligence tools.
• A high degree of accuracy and attention to detail.
• Experience with the following programming languages / tools is desirable: Oracle, Python, Informatica Cloud and/or Power BI.

A University or College Degree in related field(s), with good communication skills and expertise in data automation methods and data analysis using various business systems methodologies, along with at least (5) years of proven experience in a similar role help to make you an ideal candidate.

Once here you will:

• Analyse data from different sources in various formats, gathers requirements, develops strategies and executes applications to integrate data from various systems and formats.
• Provide data analytics to users ensuring that data is properly interpreted.
• Extract information from data management systems as required by users or external consultants and regulatory bodies.
• Respond to queries regarding data issues.
• Maintain documentation and creates processes for bulk data operations such as batch processing.
• Develop and executes programs to ensure that data integrity and quality is maintained.
• Uses various systems and tools, developed, or purchased, to create a comprehensive view of the organization’s data assets.
• Design and executes data queries to support year-end processes such as COLA, LTD PA and Annual Statements.
• Keep up to date on various methods and technologies related to data management.

 What does CAAT offer you and what should you know about us?

• Our vision is to provide an environment where employees can bring their whole, authentic selves to work. That’s what drives our high-performance, fun culture – one that’s truly one of a kind. In fact, we have been recognized as one of Canada's Most Admired Corporate Cultures for 2019 and 2020, as one of Greater Toronto's Top Employers for 2020 and 2021, and by Canadian HR Reporter as one of the Best Places to Work for 2021.
• We provide (no big surprise here!) membership in CAAT’s defined benefit (DB) pension plan, a flexible and friendly work environment, a comprehensive health and dental benefits package, life insurance, and an array of wellness programs
• Everyone is a leader at CAAT, so 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 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.
• We are working remotely at present due to the COVID-19 pandemic, and in the future will be offering a flexible, hybrid work arrangement.
• You can learn more at www.caatpension.ca

If you are interested, please apply via LinkedIn or email your resume to careers@caatpension.ca by October 21, 2022.

We recruit and select the most qualified candidates and thank all applicants for their interest but only those considered for an interview will be contacted. All interviews are being held remotely at this time.

CAAT Pension Plan is an equal opportunity employer that supports abilities and diversity of all kinds. If you require accommodation during the recruiting and selection process, please contact us at 416-673-9000.