Assistant Project Controller Reporting & Performance Analytics (PowerBI and Python required)

Position Summary

We are seeking an experienced Smartsheet Solution Architect to lead the design configuration deployment and optimization of enterprise-scale Smartsheet solutions with a strong emphasis on Advanced Work Management (AWM) capabilities. This role will be responsible for translating business and operational requirements into scalable secure Smartsheet-based solutions that improve delivery governance and reporting across portfolios and programs.

This is a consultative problem-solving role. Requests often arrive loosely defined. The successful candidate will interpret ambiguity probe for the real need and shape solutions that solve the immediate problem while building in room to grow. Solutions should be designed to extend and adapt over time not to be rebuilt with each new requirement.

The ideal candidate will bring deep hands-on expertise in Smartsheet core platform capabilities and premium applications along with proven experience delivering complex multi-workspace multi-team implementations in large organizational environments. This individual must be equally comfortable with solution architecture detailed configuration stakeholder engagement governance and user enablement.

Key Responsibilities

• Lead the end-to-end design and implementation of enterprise Smartsheet solutions using Advanced Work Management capabilities.
• Architect scalable solutions using core Smartsheet functionality and premium applications such as Control Center Dynamic View Data Shuttle DataMesh Pivot Calendar App and Connectors.
• Design solution frameworks data models template sets intake workflows portfolio roll-ups dashboards and reporting structures that support enterprise governance and standardization.
• Partner with business leaders project teams PMOs and operational stakeholders to gather requirements and convert them into practical and scalable solutions.
• Interpret ambiguous or loosely defined requests clarify the underlying need and shape them into clear actionable solution designs.
• Design solutions with extensibility in mind so they accommodate future enhancement and refinement without rework.
• Establish and maintain solution design standards development practices naming conventions security models and governance controls.
• Configure and deploy automated workflows approval processes update requests alerts forms and cross-sheet reporting solutions.
• Support enterprise portfolio and program management use cases including schedule management RAID logs financial tracking resource planning status reporting and executive dashboards.
• Identify opportunities to streamline manual processes improve data integrity and increase visibility through automation and standardized architecture.
• Provide technical leadership for enhancements environment optimization and ongoing platform maturity.
• Support change management training documentation and transition to business-as-usual support models.
• Collaborate with platform owners IT security and data teams to align Smartsheet deployments with enterprise requirements for access integration and compliance.
• Troubleshoot complex solution issues and provide expert guidance on platform capabilities design tradeoffs and best practices.

Qualifications :

Required Qualifications

• Bachelors degree in information systems computer science business engineering or related field or an equivalent combination of education and hands-on experience.
• 5 years of hands-on experience designing and deploying Smartsheet enterprise solutions in large complex organizations.
• 3 years of experience with Smartsheet Advanced Work Management and its associated premium applications.
• Demonstrated success delivering enterprise-scale deployments including standardized template architectures cross-functional workflows portfolio reporting and governance models.
• Strong experience with:
  • Control Center
  • Dynamic View
  • Data Shuttle
  • DataMesh
  • Pivot
  • Calendar App
  • Connectors
  • Core automation forms dashboards and reporting
• Strong understanding of solution architecture information structure scalability security and platform governance.
• Experience facilitating workshops defining business requirements and translating needs into technical designs.
• Strong communication skills with the ability to engage both executive stakeholders and hands-on delivery teams.
• Proven ability to balance strategic design with detailed solution build and deployment.
• Experience developing user guides standards training materials and support documentation.
• Must be willing to work on fixed night shifts and 3 days onsite per week.

Preferred Qualifications

• Smartsheet certification is strongly preferred. This includes the current Smartsheet Architect Certification or Smartsheet Professional Certification as well as the legacy Smartsheet Solution Certification or Product Certification.
• Experience supporting PMO portfolio management capital delivery operations or enterprise transformation environments.

• Experience integrating Smartsheet with adjacent enterprise systems or reporting environments.
• Familiarity with structured delivery methodologies solution governance and phased rollout approaches.
• Experience in regulated highly matrixed or geographically distributed organizations.
• Experience building Power Automate workflows.
• Experience developing API workflows.

Additional Information :

At AECOM we are committed to maintaining a secure and trustworthy recruitment process and take any fraudulent hiring activity seriously. To support this commitment all newly hired employees are required to attend an in-person Day 1 onboarding at an AECOM office location as a condition of employment.

About AECOM 

AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status AECOM benefits may include medical dental vision life AD&D disability benefits paid time off leaves of absences voluntary benefits perks flexible work options well-being resources employee assistance program business travel insurance service recognition awards retirement savings plan and employee stock purchase plan. 

AECOM is the global infrastructure leader committed to delivering a better world. As a trusted professional services firm powered by deep technical abilities we solve our clients complex challenges in water environment energy transportation and buildings. Our teams partner with public- and private-sector clients to create innovative sustainable and resilient solutions throughout the project lifecycle from advisory planning design and engineering to program and construction management. AECOM is a Fortune 500 firm that had revenue of $16.1 billion in fiscal year 2025. Learn more at . 

What makes AECOM a great place to work 

You will be part of a global team that champions your growth and career ambitions. Work on groundbreaking projects - both in your local community and on a global scale - that are transforming our industry and shaping the future. With cutting-edge technology and a network of experts youll have the resources to make a real impact. Our award-winning training and development programs are designed to expand your technical expertise and leadership skills helping you build the career youve always envisioned. Here youll find a welcoming workplace built on respect collaboration and community - where you have the freedom to grow in a world of opportunity. 

As an Equal Opportunity Employer we believe in your potential and are here to help you achieve it. All your information will be kept confidential according to EEO guidelines. 

Remote Work :

No

Employment Type :

Full-time