Business Analyst Contractor: 3-5 years (Intermediate)

Alpha Consulting Corp. is seeking an experienced Smartsheet Project Tracking & Automation Consultant to help design and implement project tracking capabilities for a US-based team. The consultant will be responsible for translating business needs into practical Smartsheet solutions, including dashboards and automated workflows.

Responsibilities:

• Translate the team’s project tracking vision into a practical Smartsheet solution
• Design and build Smartsheet sheets, reports, dashboards, and portfolio-level views
• Integrate disparate workplans into a cohesive project tracking structure
• Develop Smartsheet workflows for:
• O Task assignments
• O Status updates
• O Approvals
• O Escalations
• O Reminders
• O Milestone tracking
• O RAID tracking
• Configure automated notifications in Microsoft Teams using Power Automate based on Smartsheet data & project events
• Establish consistent project tracking fields, statuses, ownership, milestones, and reporting logic
• Partner with US-based project and delivery resources to understand requirements and validate the solution
• Rapidly prototype, demonstrate, and refine capabilities based on user feedback
• Document the solution architecture, key workflows, operating procedures, and maintenance considerations
• Provide knowledge transfer to designated team members before the end of the engagement
• Identify practical opportunities to simplify reporting, reduce manual status collection, and improve project visibility

Requirements:

• Demonstrated hands-on experience designing and implementing Smartsheet solutions
• Strong experience creating: Smartsheet dashboards, Reports and cross-sheet references, Automated workflows, Project and portfolio tracking structures, Executive and operational reporting views
• Experience integrating multiple workplans or project tracking sources into a consolidated Smartsheet environment
• Practical experience with Power Automate and Microsoft Teams notifications
• Ability to connect Smartsheet events or data changes to automated Teams communications
• Strong understanding of project management concepts, including milestones, dependencies, risks, issues, owners, and status reporting
• Ability to work independently with limited day-to-day direction
• Strong analytical, organizational, and communication skills
• Ability to rapidly iterate from an initial concept to a usable solution within a short timeframe
• Availability to work with US-based resources during overlapping US business hours
• Smartsheet certification or equivalent demonstrated experience
• Experience supporting enterprise transformation, technology, consulting, or PMO initiatives
• Experience designing lightweight governance and adoption processes for project tracking tools
• Familiarity with Microsoft 365 tools, incl Teams, SharePoint, and Power Automate
• Experience working with senior stakeholders and translating ambiguous requirements into executable solutions