data cleansing analyst Jobs

Senior Data Analyst & Developer (Hybrid)
Calgary Board of Education —Calgary, AB
- $118,200–$144,100 a year
- Full-time
- Microsoft Excel
- Oracle
- Research
2d
Banking Technology - Data & Functional Analyst
EY —Toronto, ON
- $80,000–$120,000 a year
- Azure
- Oracle
- Computer Science
- Dental care
3d
HR Analyst (Workday)
Tilray —Toronto, ON
- $60,000–$90,000 a year
- Full-time
- Microsoft Excel
- Analysis skills
- Bachelor's
- Dental care
- Paid time off
6d
Senior Analyst, Trading Systems Management
Raise —Toronto, ON
- $39.21–$46.28 an hour
- Contract
- Microsoft Excel
- SQL
- Machine learning
Quick apply
9d
Financial Analyst, Plant Finance
PCS Inc —Cory, SK
- $82,700–$153,600 a year
- Full-time
- Microsoft Powerpoint
- Microsoft Excel
- Microsoft Office
6d
Senior Data Scientist - Generative AI, ML & Agentic Systems
Scotiabank —Toronto, ON
- Azure
- Doctoral degree
- Computer Science
Intern, Digital Shipyards Architecture (4 months)
Seaspan ULC —North Vancouver, BC
- $28 an hour
- Full-time
- Oracle
- Computer Science
- Project management
6d
Solution Architect (Kroll & Sage)
Sentrex Distribution Inc. —Markham, ON
- $115,000–$133,500 a year
- Monday to Friday
- Hybrid work
- Azure
- Computer Science
- DevOps
- Wellness program
- Dental care
Sr. Data Architect - GOAPRDJP00000616
Source Code —Toronto, ON
- Full-time
- Azure
- Computer Science
- SQL
Quick apply
Financial Solutions Architect
Exchange Technology Services Inc. —Winnipeg, MB
- Full-time
- Microsoft Excel
- ERP systems
- Bachelor's
Quick apply

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Senior Analyst, Trading Systems Management
Raise —Toronto, ON
Support system enhancements, upgrades, and project initiatives, including testing, implementation, and post-launch validation.
$39.21–$46.28 an hour
Quick apply
9d
Banking Technology - Data & Functional Analyst
EY —Toronto, ON
Our Total Rewards package includes a discretionary bonus program, a comprehensive medical, prescription drug and dental coverage plan, a defined contribution…
$80,000–$120,000 a year
3d

Show more jobs in cities nearby

I want to receive the latest job alerts for data cleansing analyst

By signing in to your account, you agree to Workopolis's Terms of Service and consent to our Cookie and Privacy Policy.

Senior Data Analyst & Developer (Hybrid)

Calgary Board of Education
Calgary, AB

Apply Now

Job details

Full-time
2 days ago

Skills

Power BI
Microsoft Excel
Oracle
Business intelligence
Data structures
R
Research
Microsoft Office
SQL
Analysis skills
Bachelor's
PeopleSoft
Human resources
Data analytics
HRIS
Metadata
Data Science

Full job description

Mission

The Calgary Board of Education (CBE) is the largest school board in western Canada with over 144,000 students and 16,000 employees. Our mission: Each student, in keeping with their individual abilities and gifts, will complete high school with a foundation of learning necessary to thrive in life, work and continued learning. We pride ourselves in the values we hold. Students come first. Learning is our central purpose. Public education serves the common good. The CBE encourages an inclusive and equitable workplace, which supports our diverse student and employee community. We encourage all applicants to join our dynamic, diverse, and collaborative culture and welcome applications from all qualified individuals.

When you apply to the CBE, you can feel good about serving our future leaders and contributing to student success.

Competition Info

Competition Close Date: Sunday, June 29, 2026 at 11:59pm

Calendar: 12 month

Salary: Exempt $118,200 - $144,100 annually

FTE: 1.0 - 35 hours per week

What does this role look like?

Purpose

The Senior Data Analyst & Developer serves as a subject matter expert in transforming complex data sets into actionable insights that drive organizational and workforce decisions. Operating with a high degree of professional autonomy, the incumbent designs, develops, and governs enterprise data solutions within the Human Capital Management (HCM) environment. This role provides leadership in data strategy, analytic methodologies, and system optimization, while ensuring the integrity and strategic use of organizational data assets.

Accountability

The Senior Data Analyst/Developer provides leadership and technical direction for enterprise data initiatives. This job exercises independent judgment in developing, maintaining, and optimizing reporting, analytics, and integrations across the PeopleSoft system. The incumbent collaborates with HR, Finance, and IT to translate business objectives into analytic strategies and ensures continuous improvement in data quality, system performance, and decision support.

What will you do?

Major Responsibilities

Design, develop, and analyze complex data sets from HCM and SmartFind Express, to identify trends, patterns, and areas for improvement.
Design, develop, and maintain reports, dashboards, and data extracts using Query Manager, BI Publisher, or other reporting tools.
Use R to perform statistical analyses, modeling, and visualizations to identify trends, patterns, and outliers.
Develop predictive and prescriptive models to support workforce planning, financial forecasting, and operational efficiency.
Design and implement automated workflows for data integration, validation, and reporting.
Train, mentor, and develop junior Data Analysts and business users on data tools and reporting best practices.
Advise senior leadership through advanced data analysis, dashboards, and forecasting models that inform strategic decision-making, compliance, and operational efficiency.
Leverage R scripts, SQL jobs, and scheduling tools to reduce manual work and enhance reliability by developing automations for complex business processes, audits, and workflows.
Analyze requirements, perform configurations, test changes, and implement custom code in the PeopleSoft 9.2, and update documentation.
Develop custom SQR programs and modifications according to specific business requirements using Application Designer, PeopleCode, SQL and SQR.
Apply configuration changes to PeopleSoft for earning codes, tax codes, action reasons, combo codes, department & location codes, job codes, salary grades, benefits, position data and any other table changes within PeopleSoft.
Develop new PeopleSoft interfaces and maintain existing integrations.
Work on multiple PeopleSoft modules and exercise a thorough knowledge of institutional business processes.
Develop core competency with multiple PeopleSoft technologies (SQR, PeopleTools, PeopleCode and SQL) to troubleshoot and design new solutions.
Collaborate with HR, Finance, and IT stakeholders to gather reporting requirements, provide analytical support, and deliver custom data solutions.
Perform data validation, cleansing, and reconciliation between HCM and other enterprise systems.
Provide technical guidance on data structure, table relationships, and query optimization within the HCM environment.
Support system upgrades, patching, and enhancements by conducting impact analysis and data testing.
Ensure data security and compliance with internal and external policies and regulations.
Oversee compliance-related data reporting and ensure accuracy and alignment with regulatory, and collective bargaining requirements.
Provide trending, preparation of collective bargaining reporting, and ad hoc reporting.
Investigate, research, and compile background and current information, statistics, and forecasts for the preparation of briefs, reports, proposals, and scenario building, related to HR program development, collective bargaining, settlements, grievances, and arbitration hearings.
Provide trending, preparation of collective bargaining reporting, and ad hoc reporting.
Document data sources, definitions, processes, and code for transparency and reusability.
Communicate findings to senior management via formal presentations, standard management reporting artifacts on a periodic/quarterly/annual basis.
Support upgrades, patches, and data migrations within the HCM environment including testing and updating all existing queries, reports and automations.
Perform other related duties as assigned.

What are we looking for?

Qualifications

Education and Experience

Bachelor's degree in Data Science, Data Analytics, Information Systems, Computer Science, or a related field.
7 to 10 years of experience in a data analyst, business intelligence, or senior Peoplesoft developer role.
Strong knowledge of PeopleSoft HCM, including data structures and reporting tools required.
Proficiency in PeopleSoft tools: Application Designer, PeopleCode, Application Engine, SQR, and Integration Broker required. Preferred working experience and understanding in PeopleSoft 9.2 and PeopleTools 8.62
Proven experience with HR data analytics, metrics development, building automated data workflows, and advanced reporting tools (PeopleSoft Query, SQL, Power BI, R or equivalent).
Knowledge of core functionality for some of the following PeopleSoft 9.2 modules: Human Resources, Benefits Administration, Position Management, Payroll, Time and Labor, HRMS Portal Pack, Workflow, eBenefits, ePay, Talent Acquisition Manager, Candidate Gateway, eCompensation, eProfile, eLearning, Learning Management.
Strong grasp of data governance, data quality, and metadata management principles.
Advanced proficiency in Microsoft Office, with a strong focus on Excel and data analysis.
Experience working with multiple unions required.
Strong analytical mindset with excellent problem-solving skills.
Ability to communicate complex findings to non-technical audiences.

Demonstrated Skills and Competencies

Demonstrated ability to exercise sound professional judgment on complex technical and organizational issues.
In-depth understanding of HR processes, HR compliance, and workforce data management.
Strong analytical and problem-solving skills with a focus on data-driven decision-making.
High attention to detail, data accuracy, and system compliance.
Strong leadership and mentoring capabilities within a technical team environment.
Proficient in utilizing Microsoft Office applications for in-depth data analysis.
Solid understanding of statistical or quantitative methodology and technology.
In-depth knowledge of PeopleSoft HCM.
Preferred Oracle certifications; PeopleSoft Application Developer I: PeopleTools and PeopleCode and PeopleSoft Application Developer II: Application Engine & Integration.

Conditions of Employment

Police Information Clearance: Applicants new to the Calgary Board of Education WHO ARE OFFERED EMPLOYMENT must complete and pass a police information clearance before employment is confirmed.

Be Part of Our Success

A career with the CBE offers incredible opportunities, rewards and supports.

What happens next?

We thank all candidates for their interest in this position however only those selected for an interview will be contacted.

Land Acknowledgement

The Calgary Board of Education acknowledges the traditional territories and oral practices of the Treaty 7 Nations, including the Siksikaitsitapi Nations, Tsuut'ina Nation, and the Îyârhe Nakoda Nations. We acknowledge the Métis Nation within Alberta, and all people who make their homes in the Treaty 7 region of southern Alberta. As a learning organization, we are committed to advancing the Truth and Reconciliation Calls to Action focused on Education for ReconciliACTION.

Apply Now

Refine Your Search

Senior Data Analyst & Developer (Hybrid)

Banking Technology - Data & Functional Analyst

HR Analyst (Workday)

Senior Analyst, Trading Systems Management

Financial Analyst, Plant Finance

Senior Data Scientist - Generative AI, ML & Agentic Systems

Intern, Digital Shipyards Architecture (4 months)

Solution Architect (Kroll & Sage)

Sr. Data Architect - GOAPRDJP00000616

Financial Solutions Architect