Smartsheet Engineer — On‑Site BI Dashboards (Minneapolis)

Openkyber; Alaska; On-site; USD 90,000 - 130,000; Full time

Job summary

OpenKyber is seeking a skilled Smartsheet BI specialist to design scalable solutions, dashboards, and reporting tools that transform complex data into actionable insights. The role requires hands-on work with Smartsheet, large datasets, and on-site collaboration in Minneapolis, MN several days per week.

The ideal candidate will connect Smartsheet with ERP, Procore, Power BI, and Salesforce, build advanced formulas, automate workflows, and contribute to real-time reporting for project performance.

Qualifications

• Hands-on experience using Smartsheet in a BI, reporting, or ops role.
• Ability to manage large, complex datasets with accuracy.
• Proficiency developing complex formulas and automated workflows.
• Experience building dashboards and visual reporting tools.
• Familiarity with Smartsheet automation features (Data Shuttle/DataMesh) and BI integrations.

Responsibilities

• Design and maintain Smartsheet-based solutions to organize high-volume data and improve visibility across projects and operations.
• Build interactive dashboards and reporting views delivering timely, actionable insights for stakeholders.
• Create advanced formulas and logic within Smartsheet to support analysis and decision-making.
• Configure and manage automations, Data Shuttle processes, and DataMesh workflows.
• Connect Smartsheet with ERP systems, scheduling apps, Procore, Power BI, and Salesforce as needed.
• Partner with internal teams to translate reporting goals into BI tools.
• Support development of real-time reporting to improve tracking and project performance.
• Contribute on-site in Minneapolis, Minnesota several days per week.

Skills

Smartsheet proficiency

Large data handling

Formulas & automation

Dashboards & reporting

Team collaboration

Power BI knowledge

Tools

Smartsheet

Power BI

ERP systems

Procore

Salesforce

Job description

OpenKyber is seeking a skilled Smartsheet BI specialist to design scalable solutions, dashboards, and reporting tools that transform complex data into actionable insights. The role requires hands-on work with Smartsheet, large datasets, and on-site collaboration in Minneapolis, MN several days per week.

The ideal candidate will connect Smartsheet with ERP, Procore, Power BI, and Salesforce, build advanced formulas, automate workflows, and contribute to real-time reporting for project performance.