Salesforce Administrator & Reporting Consultant in Ottawa

Salesforce Administrator & Reporting Consultant in Ottawa

Ottawa Full-Time 81000 - 99000 $ / year (est.) Hybrid
L

At a Glance

  • Tasks: Build and maintain Salesforce reports and dashboards while collaborating with teams.
  • Company: LeverageTek, a leader in staffing solutions with a focus on technology.
  • Benefits: Remote work, inclusive environment, and opportunities for professional growth.
  • Other info: Join a diverse team committed to equity and inclusion.
  • Why this job: Make an impact by optimizing reporting solutions and enhancing data governance.
  • Qualifications: 5+ years of Salesforce Admin experience and strong Power BI skills required.

The predicted salary is between 81000 - 99000 $ per year.

LeverageTek is actively seeking a Salesforce Admin and Reporting Consultant for a 3-month contract with its Ottawa-based customer.

Work Location: Remote

Security Requirement: Be eligible for Enhanced Reliability

Key Tasks:

  • Build and maintain operational Salesforce reports and dashboards
  • Create custom report types and optimize existing reporting structures
  • Analyze Salesforce data to understand lifecycle flows (e.g., time in each status, throughput, volumes)
  • Configure and maintain objects, fields, workflows, validation rules, and permissions
  • Manage data integrity, security, and platform configuration
  • Collaborate with developers and other teams on cross-functional enhancements

Stakeholder Collaboration:

  • Work directly with internal stakeholders to understand reporting and operational challenges
  • Gather and refine requirements and translate them into practical reporting solutions
  • Support user adoption, training, and documentation

Governance & Documentation:

  • Contribute to evolving data governance processes
  • Maintain documentation for reports, dashboards, and data models
  • Provide knowledge transfer to internal teams

Key Qualifications:

  • 5+ years of Salesforce Administration experience (Admin or Sys Admin roles)
  • Advanced Power BI and Salesforce reporting expertise, including building dashboards, operational analytics, and custom reports in Power BI, with experience integrating Salesforce data into Power BI reports (data modeling, DAX, Power Query, DirectQuery, SOQL, APIs)
  • Solid SQL skills and experience working with Salesforce data (API, Data Loader, Workbench)

Qualifications:

  • Strong understanding of Salesforce data structures and data flow
  • Ability to gather requirements and translate them into scalable reporting solutions
  • Excellent communication skills and comfort working directly with business users

Assets:

  • Salesforce Administrator or Advanced Administrator certification
  • Experience with data governance frameworks

Seniority Level: Mid-Senior level

Employment Type: Contract

Job Function: Information Technology

Industries: Staffing and Recruiting

Salesforce Administrator & Reporting Consultant in Ottawa employer: LeverageTek Staffing Solutions

As a leading staffing agency, we pride ourselves on fostering a collaborative and inclusive work culture that empowers our employees to thrive. With remote work flexibility, competitive benefits, and ample opportunities for professional growth, we are dedicated to supporting our team members in achieving their career goals while making a meaningful impact in the IT Strategy and Governance sector.

L

Contact Details:

LeverageTek Staffing Solutions Recruitment Team

We think you need these skills to ace Salesforce Administrator & Reporting Consultant in Ottawa

Salesforce Administration
Power BI
Dashboard Creation
Operational Analytics
Custom Reporting
Data Modeling
DAX