Nikolaos Sigalas

Results-driven Senior Data and Business Intelligence Analyst with expertise in data management, analysis, and visualization using various tools, platforms and coding, such as ETL, Power BI, DAX, and SQL. Proven track record of leading data-driven initiatives, automating processes, and training teams. Passionate about delivering high-quality data insights that enable informed decision-making and enhance business performance.

07/2023 – Present  Senior Consultant - Data and Business Intelligence at Assystem, London, UK
Assystem (previously LogiKal) is a global leader in project controls and digital solutions consultancy services.
Client: The Earls Court Development Company 11/2023 – Present. Role: Senior Data and Business Intelligence Analyst.
• Developed scheduled ETL processes sourcing data from multiple systems and updating the Data Warehouse.
• Developed automated Power BI reports and managed security roles, the Power BI App and admin of the Power BI service and workspaces.
• Overhauled an existing custom app (Budibase), greatly increasing performance and adding new features.
Internally:
• Spearheaded Assystem's internal digital initiatives through its digital taskforce, emphasizing data
management, analysis, and reporting.
• Delivered internal Data Management training and mentored team members on Power BI and other tools.
• Undertook a Project Controls Maturity Assessment focused on the aspects of data, reporting, systems use and their integration for a large organisation, delivering actionable recommendations.
• Developed ETL processes for marketing, calling the LinkedIn and Google Analytics APIs and developed a Power BI report that enabled data-driven decision-making.
• Won second place in Logikal's (now Assystem) global Power BI competition.
• Authored industry-related articles, study cases, and bid proposals.

02/2022 – 07/2023 Consultant - Data and Business Intelligence at Assystem, London, UK
Client: The Earls Court Development Company – 3 months. Role: Digital PMO Solution Architect.
• Developed and implemented the project’s digital strategy, recommending the optimal hosting environment,
user directory, user workspaces, required systems and applications, database and data pipelines.
• Developed ETL processes and a Data Warehouse sourcing data from multiple systems.
• Developed automated Power BI reports, improving data quality and efficiency.
• Rapid application development of several custom apps, streamlining processes and increasing data accuracy.
Client: Network Rail Telecoms Portfolio Management Office – 11 months. Role: Data Analyst.
• Consulted on data management and reporting, identifying opportunities and applying best practices.
• Developed and managed several Power BI dataflows and live connections, combining multiple data sources into a Data Warehouse that was used as the single source of truth.
• Revamped several existing Power BI reports, significantly reducing required queries, increasing
performance, and improving data visualisation.
• Developed and managed Power BI reports, improving data quality, data visualisation and reducing workload.
• Rapid application development of several custom apps (Power Apps) for various functions, optimizing processes and increasing data quality.
• Developed automated processes using Power Automate, significantly reducing manual workload.
Internally:
• Developed a standardised ETL processes and dashboard for project schedule data, deployable in any project.
• Pioneered a concept tool using GIS, Power BI, and integrated schedule data for project clash detection.

10/2021 – 02/2022 Information Manager at Mott MacDonald, Croydon, UK
Mott Macdonald is a global engineering, management, and development consulting firm.
• Proposed, developed and managed an SQL database and a Power BI report to visualize and interrogate the data for a project.

• Proposed and developed a comprehensive tool (Python) to automate complex engineering calculations (managed the associated project and budget).
• Developed a validated data input tool and Power BI report providing insights to project performance for a multi-billion NHS improvement project.
• Proposed and developed automation tools (Power Automate) to automate tasks and processes to increase efficiency.
The largest project in my organization was the design of Highspeed 2 (HS2). Within my role in the design joint venture:
• Trained project teams on processes, platforms and digital tools.
• Led the development of a process to automate data sourcing from multiple systems and produce client reports.
• Managed asset data and processes across the project and interfaced with external organisations.
• Ensured compliance with ISO 19650 standards and client information packaging requirements.

10/2019 – 10/2021 Graduate Information Manager and Civil Engineer at Mott MacDonald, Croydon, UK
• Primary contact for advice and guidance for all digital innovation and data compliance related matters.
• Undertook engineering design, calculations and production of detailed client ready reports.
Secondment: Balfour Beatty VINCI JV – one year. Role: Assistant Information Manager working on HS2:
• Led digital training activities, managed the Digital Training site and onboarding app (Power Apps).
• Producing digital communications across the organization and chaired frequent meetings with the Directors of IT, Innovation and Transformation and the Head of Information Management.
• Developed the onboarding process, digital training and document requirements for external sub-contractors.
• Upgraded and managed Power BI reports for data quality control.

09/2016 – 05/2017 Airman in Hellenic Air Force, GR (Completed military service)

07 – 08 / 2014 – 2016 Summer Intern in STIRIXIS TECHNIKI S.A. Construction Company, Rhodes, GR
• Collected and processed project and construction material data, which helped refine data management skills.
• Demonstrated high numeracy, diligence and excellent reporting skills while composing project progress reports.
• Collaborated with internal and external stakeholders to effectively complete all aspects of the projects on time.

08/2017–7/2019 MSc in Coastal and Marine Engineering and Management (Distinction)
Delft University of Technology, University of Southampton, Norwegian University of Science and Technology

09/2010 – 07/2016 Diploma in Civil Engineering (Equivalent to MSc/MEng degree)
School of Civil Engineering, Aristotle University of Thessaloniki, Greece