Custom Software Engineer

About the Role

Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.

Key Responsibilities

Smartsheet Solution Development & Automation

• Design, develop, and maintain scalable Smartsheet solutions utilizing Sheets, Workspaces, Reports, Forms, Dashboards, Dynamic Views, WorkApps, Pivot App, Functions, and Advanced Formulas.
• Create automated workflows for approvals, notifications, reminders, status updates, and data validations using Smartsheet Automation.
• Develop cross-sheet references and rollup solutions to consolidate project, program, and portfolio data into centralized views.
• Build and optimize enterprise-wide project tracking, resource management, governance, and operational reporting solutions.
• Configure Dynamic Views and WorkApps to deliver role-based access and personalized user experiences.
• Design and implement governance standards, templates, and best practices for Smartsheet adoption.

Power BI Development & Analytics

• Design, develop, and maintain interactive Power BI dashboards and reports for executive leadership and business stakeholders.
• Develop complex data models, DAX measures, KPIs, scorecards, and drill-through analytics using Power BI.
• Create executive-level visualizations for project health, resource utilization, financial metrics, operational performance, and program governance.
• Develop and optimize Power BI datasets, semantic models, and reporting frameworks for enterprise-scale analytics.
• Implement Row-Level Security (RLS), workspace governance, and data refresh strategies.

Smartsheet - Power BI Integration

• Integrate Smartsheet data with Power BI using native connectors, APIs, dataflows, and ETL pipelines.
• Design automated data ingestion processes to combine Smartsheet data with enterprise systems such as SharePoint, SQL Server, Azure, Salesforce, and other business applications.
• Build consolidated reporting solutions that provide a single source of truth across multiple business functions.
• Develop data transformation and cleansing processes using Power Query, Power BI Dataflows, and ETL tools.

Integrations & Technical Enablement

• Develop integrations using Smartsheet REST APIs, webhooks, Power Automate, Azure Logic Apps, and middleware platforms.
• Connect Smartsheet with Microsoft ecosystem tools including SharePoint, Teams, Power Platform, Outlook, and Excel.
• Support implementation of third-party connectors and integrations with enterprise applications such as Salesforce, ServiceNow, Jira, and other operational systems.
• Troubleshoot and optimize dashboard performance, data refreshes, data models, and workflow automations.

Stakeholder Engagement & Governance

• Collaborate with business stakeholders to gather requirements and translate them into scalable reporting and automation solutions.
• Provide technical guidance and best practices for Smartsheet and Power BI adoption.
• Conduct solution reviews, user training, and knowledge transfer sessions.
• Maintain technical documentation, governance standards, and solution architecture artifacts.

Requirements & Tech Stack

Must-have skills

• Microsoft Power Business Intelligence (PBI)

Good-to-have skills

• Microsoft SQL Server

Required Skills

Smartsheet

• Sheets, Workspaces, Reports, Dashboards
• Forms and Data Collection
• Workflows and Automation
• Dynamic View
• Pivot App
• WorkApps
• Resource & Project Tracking Solutions
• VLOOKUP, INDEX/MATCH, COUNTIF / COUNTIFS, SUMIFS, Cross-Sheet References, Nested IF Statements, Date Functions, Lookup and Rollup Logic

Power BI

• Dashboard & Report Development
• Data Modeling
• DAX Measures and Calculations
• Power Query (M Language)
• Dataflows
• Row-Level Security (RLS)
• Performance Optimization
• Workspace Administration
• Semantic Models and KPI Reporting

Other Required Skills

• Smartsheet REST APIs, webhooks
• Power Automate
• Azure Logic Apps
• Integration with SharePoint, Teams, Power Platform, Outlook, Excel
• Integration with Salesforce, ServiceNow, Jira

Qualifications

• 15 years full time education

Shift B Support: Availability to provide support until 11 AM PST.

Return to Office: Mandatory 5-day RTO from 4 strategic office locations (Chennai, Coimbatore, Hyderabad and Bangalore).