Salesforce Administrator & Reporting Consultant

LeverageTek Staffing Solutions; Ottawa; Remote; CAD 80,000 - 100,000; Part time

Job summary

A staffing solutions provider is seeking a Salesforce Admin and Reporting Consultant for a 3-month contract. This mid-senior level role involves building and maintaining Salesforce reports, collaborating with stakeholders, and contributing to data governance. Key qualifications include over 5 years of Salesforce admin experience and expertise in Power BI. The position offers a remote work arrangement and focuses on delivering operational insights to enhance data management. Equal opportunity employer committed to inclusivity and diversity.

Qualifications

• 5+ years of Salesforce Administration experience.
• Advanced Power BI and Salesforce reporting expertise.
• Solid SQL skills and experience with Salesforce data.

Responsibilities

• Build and maintain operational Salesforce reports and dashboards.
• Collaborate with internal stakeholders to understand reporting needs.
• Maintain documentation for reports, dashboards, and data models.

Skills

Salesforce Administration

Power BI

SQL

Data modeling

DAX

SOQL

Job description

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

  About LeverageTek Staffing Solutions

  Founded in 2003, LeverageTek provides end-to-end, cross-functional staffing solutions throughout North America. We are a trusted partner to leading private and public sector organizations and experts in talent solutions that create optimal business outcomes.

  Don’t let our name fool you. Our roots are in technology, but we are also a proven leader in accounting and finance, sales and marketing, human resources, supply chain, and legal talent acquisition. We offer contract and permanent staffing, executive search, talent mapping, management consultancy, and contractor payroll management.

  LeverageTek is an equal opportunity employer. We offer a welcoming and inclusive environment in service to one another, our customers, the candidates we represent, and the diverse communities we call home. We do all of this with kindness, empathy, and respect for each other. LeverageTek is committed to employment equity and creating a diverse and inclusive workplace. We welcome applications from all qualified individuals regardless of race, religion, gender, national origin, age, disability, and marital status.

  Accessibility accommodations are available upon request.