Business Analyst

Job Title: Business Analyst

Key Responsibilities

Smartsheet Development & Data Modeling

* Design, build, and maintain advanced Smartsheet solutions for operational reporting and business capability tracking.

* Create structured data tables and domains in Smartsheet from raw enterprise data inputs.

* Develop formulas, cross-sheet references, automation rules, and workflows within Smartsheet.

* Build and maintain real-time dashboards and reports to support leadership decision-making.

Business Process Mapping & Capability Design

* Translate business processes into visual maps and workflows using tools such as Microsoft Visio.

* Map current-state and future-state processes and align them with Smartsheet-based execution models.

* Support process change initiatives by documenting workflows, dependencies, and operational metrics.

* Ensure Smartsheet solutions accurately reflect evolving business capabilities.

Data Integration & Reporting

* Structure and normalize data coming from multiple enterprise sources before ingestion into Smartsheet.

* Apply strong Excel-based logic (formulas, lookups, data modeling concepts) to support Smartsheet builds.

* Support reporting and analytics concepts aligned with Power BI-style thinking (data cubes, metrics, KPIs), even if Power BI is not directly used.

* Ensure data integrity, accuracy, and scalability across all Smartsheet assets.

Project & Operational Support

* Support initiative tracking and planning aligned with Microsoft Project-style methodologies (timelines, dependencies, milestones).

* Maintain documentation for Smartsheet builds, process maps, and reporting logic.

* Collaborate closely with the business owner to iteratively improve systems as the business scales.

* Operate independently with minimal supervision while maintaining high attention to detail.

Required Skills & Qualifications

* Strong hands-on experience with Smartsheet (sheet design, formulas, dashboards, automation).

* Advanced proficiency in Microsoft Excel (formulas, data structuring, logic-based modeling).

* Experience with process mapping and documentation using Microsoft Visio or similar tools.

* Strong understanding of business operations, process change, and capability building.

* Familiarity with Power BI concepts (data modeling, KPIs, dashboards), even if not hands-on.

* Exposure to project management tools such as Microsoft Project.

* Experience working with enterprise or operational data.

* Ability to translate abstract business needs into structured technical solutions without coding.

US shift

Salary- 4.5-5LPA