Smartsheet Developer

ON SITE REQ: 3 days with option to increase to 5 if needed
Duration Expected: We expect to extend beyond May 2025 - up to 12 months or more

Job Description:

• Project (if Known): Seeking a Smartsheet Developer to design, develop, optimize and administer solutions within the Smartsheet platform to enhance business operations and project management.

Scope of Work:

• Customize, develop, manage and administer agency's Smartsheet platform

• Design and build Smartsheet solutions, including dashboards, reports and templates

• Implement and maintain automated Smartsheet workflows using Smartsheet automation to improve efficiency and automation

• Create alerts, reminders, and approval processes to streamline operations

• Utilize Smartsheet API to connect with external systems such as Okta, CRM, ERP, database, Azure devops

• Work with third-party tools such as Power Automate and PowerBI for reporting and data utilization

• Support and maintain following Smartsheet projects a. Procurement request workflow and dashboard b. Budget request workflow & Dashboard c. Agency Executive Project plan and dashboard d. Agency hiring request e. Telework Form f. Legislative implementation Dashboard g. HR recruitment dashboard h. Travel and Training request form

• Maintain Smartsheet System Security plan and serve as the primary contact for Smartsheet security initiatives and ensure compliance with data security and organizational policies

• Server as Smartsheet Administrator including user access and identity management and maintaining Smartsheet licenses

• Act as the primary point of contact for troubleshooting and resolving Smartsheetrelated issues.

• Work closely with business teams, IT, and project managers to understand business needs.

• Develop documentation, best practices, and troubleshooting guides for Smartsheet solutions.

• Work with CIO and team to provide needed assistance and support for all Smartsheet initiatives

Required/Desired Skills:

• Smartsheet Core Product Certification

• AWS Solutions Architect Associate Certification

• Expertise in Smartsheet features, design and implementing Smartsheets solutions including workflow automation, building dashboards, reports, forms and

• Knowledge of Smartsheet API, JavaScript, Python, Power BI

• Experience with workflow automation tools like Power Automate, Zapier, or Bridge by Smartsheet.

• Develop and deploy custom scripts and automation tool to extend Smartsheet functionality

• Strong understanding of data management, database and data connectors to synchronize information across platforms

• Smartsheet Integration with other tools via APIs such as Okta, Azure DevOps, PowerBI

• Excellent problem-solving and analytical skills.

• Work closely with business teams, IT, and project managers to understand business needs

• Convert business requirements into scalable Smartsheet solutions.

• Participate in meetings, provide updates, and suggest improvements for Smartsheet usage.

• Develop documentation, best practices, and troubleshooting guides for Smartsheet solutions

• Strong communication and stakeholder management abilities.

• Ability to train and support endusers effectively

• Self-motivated and capable of handling multiple projects simultaneously

• Prior Tax experience

• Knowledge on Angular scripting language

• Knowledge on assisting and supporting AWS Cloud Environment

• Business analyst and project management experience