͏

Smartsheet Analyst

Location: Greensborough NC

Responsibilities:

• Design and configure custom Smartsheet solutions tailored to business needs, including setting up sheets, dashboards, reports, and forms for project management, workflows, and data tracking.
• Develop and manage automated workflows in Smartsheet, such as alerts, reminders, approvals, and task assignments, to streamline business processes and enhance productivity.
• Implement Smartsheet as a project management tool by creating Gantt charts, task dependencies, resource allocation views, and Milestone tracking to help teams stay on schedule.
• Integrate Smartsheet with other business systems (e.g., Salesforce, Jira, Microsoft Office, Google Workspace) for seamless data flow and ensure data synchronization across platforms.
• Create and maintain Smartsheet reports and dashboards that provide real-time insights into project progress, resource utilization, risks, and other key metrics to support decision-making.
• Provide guidance, support, and training to users on how to effectively use Smartsheet features, including how to create sheets, use templates, build reports, and leverage automation tools.
• Collaborate with cross-functional teams to understand their project management needs and deliver tailored Smartsheet solutions that improve teamwork, communication, and productivity.
• Ensure data integrity within Smartsheet by monitoring data entry, validating data against business rules, and implementing automated checks to prevent errors or discrepancies.

͏

Qualifications:

• A Bachelor’s degree in Business Administration, Information Technology, Project Management, or a related field.
• 6+ years of experience working with Smartsheet, including hands-on experience with advanced features like automation, reporting, dashboards, and integrations.
• Preferred Smartsheet Certified User or Smartsheet Certified Administrator certification, demonstrating proficiency in Smartsheet tools and capabilities.
• Proficiency in Smartsheet features, including Gantt charts, Kanban boards, task dependencies, reports, and automation workflows. Familiarity with Smartsheet API or integration tools like Zapier is a plus.
• Experience in managing or supporting projects using Smartsheet, with knowledge of project management methodologies such as Agile or Waterfall.
• Strong analytical skills to identify and solve problems, troubleshoot issues in Smartsheet, and recommend best practices for optimization and process improvement.
• Excellent communication skills, both written and verbal, to effectively collaborate with cross-functional teams, train users, and present data insights through Smartsheet dashboards and reports.
• High attention to detail to ensure the accuracy and quality of data entered into Smartsheet and to create well-structured, easy-to-read reports and dashboards.
• Experience with data integration tools such as Microsoft Power Automate, Zapier, or custom APIs to connect Smartsheet with other enterprise systems like Salesforce, Jira, or ERP systems.