Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this Data Management Analyst (12-Month Fixed Term) role.

Rezi rewrites your resume against CAAT Pension Plan's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Data Management Analyst (12-Month Fixed Term) posting at CAAT Pension Plan — free, in seconds.

About the Role

We are seeking a Data Management Analyst 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.

Responsibilities

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.

Requirements

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.

Skills

SQL
MS Excel
Power BI
DAX
Power Query
Data modeling
Dashboard design
ETL processes
Data warehouse
Dimensional modelling
Semantic modelling
BI development
MS T-SQL
Oracle PL-SQL
MS- Fabric
Oracle databases

Location

Remote
Hybrid
Onsite

Work Type

Full-time

Experience Level

5+ years of experience in data warehouse, dimensional / semantic modelling and BI development
5+ years of experience with SQL (MS T-SQL or Oracle PL-SQL)
2+ years of experience with Power BI development, DAX, Power Query, data modeling and dashboard design

Education Level

University degree or college diploma in related discipline or equivalent combination of education, training and experience

Salary/Compensations

$96,800.00-$113,800.00

Benefits

Opportunities to learn and master skills
Comprehensive & Holistic Care
Total Rewards program
Flexible work arrangements
Comprehensive benefits
Wellness incentives
Defined benefit pension plan
Lively environment where creativity and open communication thrive

About the Company

At CAAT, we’re passionate about what we do. And it shows! 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. It doesn’t just feel different at CAAT. It is different. We’re one of the fastest-growing pensions in the country for a reason. 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. And we’re just getting started. 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.
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.
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

Equal Opportunity

No artificial intelligence tools are used to screen, assess, or select applicants for this position. Artificial intelligence tools may be used to help recruiters identify potential candidates on external platforms. All hiring decisions are made by human reviewers.
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 hr@caatpension.ca or call Human Resources at 416-673-9000 for assistance.