ON SITE REQ: 3 days with option to increase to 5 if needed
ABOUT THE ROLE
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:
1. Customize, develop, manage and administer agency's Smartsheet platform
2. Design and build Smartsheet solutions, including dashboards, reports and templates
3. Implement and maintain automated Smartsheet workflows using Smartsheet automation to improve efficiency and automation
4. Create alerts, reminders, and approval processes to streamline operations
5. Utilize Smartsheet API to connect with external systems such as Okta, CRM, ERP, database, Azure devops
6. Work with third-party tools such as Power Automate and PowerBI for reporting and data utilization
7. 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
8. Maintain Smartsheet System Security plan and serve as the primary contact for Smartsheet security initiatives and ensure compliance with data security and organizational policies
9. Server as Smartsheet Administrator including user access and identity management and maintaining Smartsheet licenses
10. Act as the primary point of contact for troubleshooting and resolving Smartsheet-related issues.
11. Work closely with business teams, IT, and project managers to understand business needs.
12. Develop documentation, best practices, and troubleshooting guides for Smartsheet solutions.
13. Work with CIO and team to provide needed assistance and support for all Smartsheet initiatives
| Skill | Required / Desired | Amount | of Experience |
| Smartsheet Core Product Certification | Required | 6 | Months |
| AWS Solutions Architect Associate Certification | Required | 6 | Months |
| Expertise in Smartsheet features, design and implementing Smartsheets solutions including workflow automation, building dashboards, reports, forms and | Required | 1 | Years |
| Knowledge of Smartsheet API, JavaScript, Python, Power BI | Required | 1 | Years |
| Experience with workflow automation tools like Power Automate, Zapier, or Bridge by Smartsheet. | Required | 1 | Years |
| Develop and deploy custom scripts and automation tool to extend Smartsheet functionality | Required | 1 | Years |
| Strong understanding of data management, database and data connectors to synchronize information across platforms | Required | 8 | Months |
| Smartsheet Integration with other tools via APIs such as Okta, Azure DevOps, PowerBI | Required | 7 | Months |
| Excellent problem-solving and analytical skills. | Required | 2 | Years |
| Work closely with business teams, IT, and project managers to understand business needs. | Required | 6 | Months |
| Convert business requirements into scalable Smartsheet solutions. | Required | 6 | Months |
| Participate in meetings, provide updates, and suggest improvements for Smartsheet usage. | Required | 6 | Months |
| Develop documentation, best practices, and troubleshooting guides for Smartsheet solutions. | Required | 6 | Months |
| Strong communication and stakeholder management abilities. | Required | 6 | Months |
| Ability to train and support end-users effectively. | Required | 6 | Months |
| Self-motivated and capable of handling multiple projects simultaneously | Required | 6 | Months |
| Prior Tax experience | Desired | 9 | Months |
| Knowledge on Angular scripting language | Highly desired | 1 | Years |
| Knowledge on assisting and supporting AWS Cloud Environment | Highly desired | 6 | Months |
| Business analyst and project management experience | Highly desired | 6 | Months |