Smartsheet Consultant

RGP; Chicago (IL); Remote; USD 83,000 - 124,000; Full time

Benefits offered by this job

Medical

Dental

Vision

Life Insurance

Disability Insurance

401(k)

Professional Development Program

Paid Time Off

Paid Sick Time

Job summary

RGP is seeking a Smartsheet Configuration Consultant to design, configure, and optimize Smartsheet environments that enable scalable execution, transparent reporting, and effective program governance.

You will translate business needs into intuitive Smartsheet solutions, manage large datasets, and support governance, security, and change management in a remote-capable consulting role.

Qualifications

• 3–5+ years of hands-on experience designing and building Smartsheet solutions.
• Demonstrated experience translating business requirements into Smartsheet solution designs.
• Hands-on Smartsheet configuration experience including sheets, dashboards, reports, and automation.
• Experience configuring and supporting DataMesh and Pivot App solutions.

Responsibilities

• Design, build, configure, and administer Smartsheet solutions (sheets, reports, dashboards, forms, Dynamic View, Pivot App, DataMesh).
• Translate business requirements into scalable Smartsheet solution architectures and data models.
• Manage large datasets and ensure data integrity within Smartsheet platform limits.
• Configure and support DataMesh to synchronize data across sheets/reports.
• Configure Pivot App solutions to summarize large datasets and support executive reporting.
• Maintain cross-sheet formulas, automated workflows, reports, dashboards, and data-quality controls.
• Design role-based access models and security controls for large user populations.
• Establish reconciliation and exception-management processes for multi-source data.
• Test, troubleshoot, and optimize Smartsheet solutions and performance.
• Support solution releases and ongoing production issues.
• Maintain governance documentation for audit readiness.

Skills

Smartsheet configuration

Data governance

Data modeling

Requirements gathering

Stakeholder communication

Analytics

Education

Bachelor's degree or equivalent

Tools

DataMesh

Pivot App

Dynamic View

DataTable

Data Shuttle

Job description

We are seeking a Smartsheet Configuration Consultant to support clients in designing, configuring, and optimizing Smartsheet environments that enable scalable execution, transparent reporting, and effective program governance. This role sits at the intersection of process design, technology enablement, and change management, translating business needs into intuitive Smartsheet solutions that teams actually adopt.

Rate: $60 - $90/hr. W2Location: Remote

What you will work on

• Design, build, configure, and administer complex Smartsheet solutions, including sheets, reports, dashboards, forms, Dynamic View, Pivot App, DataMesh, and automation workflows.
• Translate business requirements into scalable Smartsheet solution architecture and structured data models.
• Manage large, highly structured datasets with extensive field sets and multiple data sources while protecting data integrity and designing within Smartsheet platform limits.
• Configure and support DataMesh solutions to synchronize and distribute data across sheets and reports using defined source data, target data, and match keys.
• Configure Pivot App solutions to summarize large datasets, create refreshed reporting outputs, and support dashboards and executive reporting.
• Build and maintain cross-sheet formulas, automated workflows, reports, dashboards, and data-quality controls.
• Design and support role-based access models and security controls for large user populations working with sensitive organizational and workforce data.
• Establish reconciliation and exception-management processes for data received from multiple sources.
• Test, troubleshoot, and optimize Smartsheet solutions, including formulas, workflows, reports, integrations, access configurations, and performance issues.
• Support solution releases, enhancements, and production issues after implementation.
• Maintain governance documentation, including business processes, operating procedures, data definitions, solution design, testing, and change traceability to support audit readiness.
• Participate in recurring governance, design, and documentation reviews with client and internal teams.

What you will bring

• 3–5+ years of hands-on experience personally designing and building Smartsheet solutions for other users, preferably in a client-facing consulting or enterprise delivery environment.
• Demonstrated experience translating business requirements into Smartsheet solution designs and builds.
• Hands-on Smartsheet configuration experience, including sheets, project plans, forms, dashboards, reports, cross-sheet references and formulas, Dynamic View, and automation workflows.
• Hands-on experience personally configuring and supporting DataMesh solutions.
• Hands-on experience personally configuring and supporting Pivot App solutions.
• Experience designing structured data models and managing large datasets, including reporting optimization and designing around platform performance limits.
• Experience establishing unique identifiers, lookup relationships, reconciliation processes, and data-quality controls across multiple data sources.
• Working knowledge of enterprise data governance, permissions design, role-based access, and security controls for confidential data.
• Experience testing, troubleshooting, and supporting Smartsheet solutions in production.
• Strong documentation discipline across process documentation, operating procedures, solution design, data definitions, testing, and change traceability.
• Ability to lead requirements-gathering sessions and facilitate working sessions with both technical and business audiences.
• Ability to explain technical design decisions and tradeoffs clearly to non-technical stakeholders.
• Strong analytical and problem-solving skills with attention to detail.
• Bachelor's degree in Business, Engineering, Information Systems, or a related field, or equivalent practical experience.

Preferred

• Smartsheet certification, at solution professional and above.
• Experience with DataTable and Data Shuttle.
• Experience with Smartsheet Control Center and Global Updates.
• Experience with connectors or integrations between Smartsheet and enterprise systems.
• Experience building executive and operational analytics using Smartsheet dashboards and related reporting tools.
• Experience supporting high-volume or enterprise-scale Smartsheet environments.
• Experience in regulated industries or environments with strict confidentiality, auditability, and access-control requirements.

What you can expect

• An inspirational place for you to do your best work, be engaged in meaningful ways, and continually develop the skills, competencies and qualities that set our team apart.

• Compensation commensurate with your qualifications, experience, and other factors including geographic location, market and operational factors.

• Total Rewards include: Medical, Dental, Vision, Life Insurance, Disability Insurance, 401(k) Savings Plan, Employee Stock Purchase Plan, Professional Development Program, Paid Time Off and Paid Sick Time (in geographies where legally required).

What we do

At RGP, we're creating a future where businesses produce their best work without constraints. We've built a global network of over 2,600 experts across four regions, providing a comprehensive suite of solutions across on-demand talent, next-generation consulting, and outsourced services to support organizations at every stage of their growth journey. Trusted by Fortune 100 companies and emerging disruptors alike, we challenge conventional ways of working, drive growth, and pave the way for long-term success through bold innovation and fearless collaboration.

Our values guide everything we do and strengthen our commitment to people. By combining smart processes, human-centered design, and advanced technology, we celebrate our team's excellence and ensure we grow together. We believe in the power of continuous learning and development to drive both individual and organizational success. It’s time to rethink how work gets done. Dare to Work Differently with RGP.

RGP is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information, veteran status, or any other legally protected trait and encourage all applicants to apply.