indeed
Data Management Analyst (12-Month Fixed Term)
CAAT Pension Plan
Toronto, CAN
Full-time
Onsite
$96,800 to $113,800
Discovered 4 days ago
Data warehousingDimensional and semantic data modelingBusiness intelligence developmentSQLPower BIDAX
Role Overview
Data Management Analyst working with stakeholders to deliver data integrations, data models, and BI reports aligned with business objectives.
The title specifies a 12-month fixed term.
Key Skills for This Role
Data warehousingDimensional and semantic data modelingBusiness intelligence developmentSQLPower BIDAX
Full Job Posting
Role overview
Data Management Analyst working with stakeholders to deliver data integrations, data models, and BI reports aligned with business objectives.
The title specifies a 12-month fixed term.
Responsibilities
- Develop BI solutions and create datasets using SQL, Excel, and reporting tools.
- Build Power BI reports and dashboards using organizationally aligned data models.
- Design ETL processes and unit tests in a data warehouse environment; identify and resolve data quality issues.
- Analyze requirements for projects and enhancements, prepare technical specifications, and support ongoing BI and data solution operations.
- Collaborate with stakeholders and colleagues across business and technical teams.
Qualifications
- Related university degree or college diploma, or equivalent education, training, and experience.
- At least 5 years of data warehouse, dimensional or semantic modeling, and BI development experience.
- At least 5 years of SQL experience with MS T-SQL or Oracle PL-SQL.
- More than 2 years of Power BI development experience, including DAX, Power Query, data modeling, and dashboard design.
- Strong business-needs analysis, communication, analytical, prioritization, and task-management abilities.
- DP-600 or DP-700 Microsoft Fabric certification is considered an asset.
Compensation
- Target hiring salary is $96,800 to $113,800; placement depends on internal equity, market conditions, and relevant experience, skills, and qualifications.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at CAAT Pension Plan
Manager, Employer Onboarding (DB Pension Implementation)
Toronto, CAN
ManagerFull-time
Discovered 2 days agoView →
Pension Analyst, Operational Acceptance Testing (Contract until December 2027)
Toronto, CAN
MidFull-time
Discovered 1 weeks agoView →
Pension Analyst, Employer Services (18-Month Contract, Two Vacancies)
Toronto, CAN
MidFull-time
Discovered 1 weeks agoView →
Manager, Investment Operations (Public Markets)
Toronto, CAN
ManagerFull-time
Discovered 3 weeks agoView →
Manager, Employer Onboarding (DB Pension Implementation)
Toronto, CAN
Discovered 2 days agoFull-time
HRIS Analyst
Toronto, CAN
Discovered 2 days agoFull-time
ServiceNow Technical Lead
Toronto, CAN
Discovered 4 days agoFull-time
Pension Analyst, Operational Acceptance Testing (Contract until December 2027)
Toronto, CAN
Discovered 1 weeks agoFull-time
Pension Analyst, Employer Services (18-Month Contract, Two Vacancies)
Toronto, CAN
Discovered 1 weeks agoFull-time
Full Stack Solutions Developer
Toronto, CAN
Discovered 2 weeks agoFull-time
Pension Software Testing Analyst
Toronto, CAN
Discovered 3 weeks agoFull-time
Manager, Investment Operations (Public Markets)
Toronto, CAN
Discovered 3 weeks agoFull-time