Project Controls System Specialist

Job description / Role

Job summary:

We are seeking a highly skilled and experienced Smartsheet & Power BI solutions analyst & developer to support and optimize our portfolio reporting and collaboration platforms. The ideal candidate has a minimum of 4 years hands-on experience in advanced Smartsheet features including Control Center, Data Shuttle, Portfolio WorkApps, and Dynamic View, as well as robust Power BI reporting capabilities.

This role will be responsible for building scalable Smartsheet solutions, integrating data from multiple sources, and delivering insightful dashboards to support business decision making and project portfolio visibility.

Key responsibilities:

• Design, build, and manage scalable Smartsheet solutions using Control Center, Dynamic View, and Portfolio WorkApps.
• Develop and maintain Data Shuttle workflows for efficient and automated data transfer and updates.
• Create and manage Power BI dashboards and reports integrating Smartsheet and other data sources.
• Collaborate with cross-functional teams to understand business needs and translate them into technical solutions.
• Maintain data integrity, enforce data governance, and ensure the security of sensitive information.
• Provide training, documentation, and user support for Smartsheet solutions and Power BI reporting tools.
• Troubleshoot and resolve issues related to workflows, permissions, integrations, and reporting.

Qualifications:

Required skills & qualifications:

• 4 years of advanced Smartsheet experience including:
  • Control Center (solution configuration, blueprint management, global updates)
  • Data Shuttle (data mapping, scheduled workflows, integrations)
  • Portfolio WorkApps (role-based access, custom UI for project portfolios)
  • Dynamic View (secure stakeholder collaboration and data filtering)
• Strong Power BI skills including:
  • Data modeling, DAX, and report design
  • Integration with Smartsheet via connectors or APIs
  • Dashboard creation for executive and operational reporting
• Experience with data governance, security, permissions, and version control
• Excellent problem-solving skills and the ability to manage multiple priorities
• Strong communication and collaboration abilities
• Bachelor's degree in IT, Business Analytics, or related field (or equivalent experience)

Remote work: No

Employment type: Full-time