Data Analyst- Smartsheet

Company Description

Egis is an international player active in architecture, consulting, construction engineering and mobility services. We create and operate intelligent infrastructures and buildings that respond to the climate emergency and contribute to more balanced, sustainable and resilient territorial development. Operating in 100 countries, Egis puts the expertise of its 19,500 employees at the service of its clients and develops cutting-edge innovations accessible to all projects. Through its wide range of activities, Egis is a key player in the collective organisation of society and the living environment of citizens all over the world.

With 3,500 employees across 8 countries in the Middle East, Egis has delivered over 700 complex development projects, stimulating economic growth and enhancing quality of life. Ranked among the top ten firms in the Middle East by Engineering News Record (ENR), Egis is committed to sustainable development. The Group’s operations in the Middle East are built on strategic acquisitions and a deep understanding of local market conditions. Egis’ long history of providing comprehensive engineering, consulting, and project management services makes it a trusted partner for regional governments, investors, and developers.

Job Description

We are seeking a highly skilled and experienced Smartsheet & Power BI Solutions Analyst & Developer to support and optimize our portfolio, reporting, and collaboration platforms. The ideal candidate has a minimum of 4 years’ hands-on experience in advanced Smartsheet features including Control Center, Data Shuttle, Portfolio WorkApps, and Dynamic View, as well as robust Power BI reporting capabilities.

This role will be responsible for building scalable Smartsheet solutions, integrating data from multiple sources, and delivering insightful dashboards to support business decision-making and project portfolio visibility.

Key Responsibilities:

• Design, build, and manage scalable Smartsheet solutions using Control Center, Dynamic View, and Portfolio WorkApps.
• Develop and maintain Data Shuttle workflows for efficient and automated data transfer and updates.
• Create and manage Power BI dashboards and reports integrating Smartsheet and other data sources.
• Collaborate with cross-functional teams to understand business needs and translate them into technical solutions.
• Maintain data integrity, enforce data governance, and ensure the security of sensitive information.
• Provide training, documentation, and user support for Smartsheet solutions and Power BI reporting tools.
• Troubleshoot and resolve issues related to workflows, permissions, integrations, and reporting.

Qualifications

Required Skills & Qualifications:

• 4+ years of advanced Smartsheet experience, including:
  • Control Center (solution configuration, blueprint management, global updates)
  • Data Shuttle (data mapping, scheduled workflows, integrations)
  • Portfolio WorkApps (role-based access, custom UI for project portfolios)
  • Dynamic View (secure stakeholder collaboration and data filtering)
• Strong Power BI skills, including:
  • Data modeling, DAX, and report design
  • Integration with Smartsheet via connectors or APIs
  • Dashboard creation for executive and operational reporting
• Experience with data governance, security permissions, and version control
• Excellent problem-solving skills and the ability to manage multiple priorities
• Strong communication and collaboration abilities
• Bachelor's degree in IT, Business Analytics, or related field (or equivalent experience)

Preferred Qualifications:

• Smartsheet Product Certification(s)
• Microsoft Power BI Certification
• Knowledge of Smartsheet Resource Management is a strong plus
• Experience with other data tools (Excel Power Query, SharePoint, SQL, or RPA tools)
• Familiarity with project/portfolio management frameworks (PMO, Agile, etc.)

Experience in nonprofit, tech, healthcare, or enterprise environments a plus