Smartsheet Configuration Consultant

your Jared; Northern (KY); Hybrid; USD 83,000 - 90,000; Full time

Benefits offered by this job

Medical benefits

Dental & Vision

401(k) plan

Employee Stock Purchase Plan

Paid time off

Job summary

RGP is seeking a Smartsheet Configuration Consultant to design, build, and optimize Smartsheet environments that enable scalable execution, transparent reporting, and governance. This remote role focuses on translating business needs into intuitive Smartsheet solutions adopted by teams.

The candidate will configure DataMesh and Pivot App solutions, maintain data integrity across multiple sources, and lead governance with scalable access controls and robust documentation.

Qualifications

• 3–5+ years designing and building Smartsheet solutions.
• Demonstrated experience translating business requirements into Smartsheet designs and builds.
• Hands-on Smartsheet configuration across sheets, projects, forms, dashboards, reports, and automation workflows.
• Hands-on experience configuring DataMesh solutions.
• Hands-on experience configuring Pivot App solutions.
• Experience designing structured data models and managing large datasets.

Responsibilities

• Design, build, configure, and administer Smartsheet solutions (sheets, reports, dashboards, forms, Dynamic View, Pivot App, DataMesh, automation).
• Translate business requirements into scalable Smartsheet designs and data models.
• Manage large datasets while ensuring data integrity within Smartsheet limits.
• Configure and support DataMesh and Pivot App solutions.
• Develop cross-sheet formulas, workflows, reports, and dashboards; implement data-quality controls.
• Establish role-based access and governance for large user populations.

Skills

Smartsheet configuration

DataMesh integration

Pivot App configuration

Automation workflows

Data governance

Documentation

Requirements gathering

Client-facing

Education

Bachelor's degree or equivalent

Tools

Smartsheet

DataMesh

Pivot App

Control Center

Data Shuttle

DataTable

Job description

About This Role

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 - $65/hr. W2

Location: Remote

Duration: Through end of 2026, chance of extension

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.