Project Role : Analytics Practitioner
Project Role Description : Develop business insights using predictive statistical modeling activities. Use analytical tools and techniques to generate and improve decision-making by modeling client, market, and key performance data.
Must have skills : Microsoft Power Business Intelligence (BI)
Good to have skills : NA
Minimum 3 year(s) of experience is required
Educational Qualification : 15 years full time education
Senior Smartsheet Developer is responsible for designing, developing, and optimizing Smartsheet solutions to automate workflows, improve collaboration, and enhance project management processes. In this role, the primary focus is on building executive-grade reports and dashboards and connecting Smartsheet data to Power BI for advanced analytics.
Key Roles & Responsibilities
Dashboard & Report Development
Develop extensive metrics and insights through Smartsheet using Dashboards and advanced formula creation, with expertise across Sheets, Workspaces, Reports, Forms, Workflows, Dynamic Views, Pivots, Functions and Formulas.
Design and publish leadership-ready reports and dashboards for program tracking, resource management, and operational visibility.
Build cross-sheet rollup reports consolidating data from multiple workstreams into a single executive view.
Design new Smartsheet solutions, automate existing workflows, build dashboards and reports, and integrate Smartsheet with other business tools.
Configure alerts, reminders, approval workflows, and row-level automation using Smartsheet's native automation engine.
Leverage Pivot App, Dynamic View, and WorkApps to extend reporting capabilities.
Integrate Smartsheet with Power BI for combined analytics reporting (detailed in next section).
Connect Smartsheet to upstream/downstream systems via REST API, Zapier, or middleware platforms.
Leverage connectors such as Salesforce Connector or similar third-party integrations to bring external data into Smartsheet solutions.
Required Skills
Smartsheet- Reports, Dashboards, Forms, Workflows, Pivot App, Dynamic View, WorkApps
Advanced Formulas - VLOOKUP, INDEX/MATCH, COUNTIF, cross-sheet references, IF nesting
Automation - Workflow rules, alerts, approval flows, row automation
Integrations - Power BI connector, REST API, OAuth, Zapier/Make
Microsoft Stack - Excel, SharePoint, Teams, Power Automate
