Nikolaos Vogiatzopoulos
Data Integration Specialist - Business Intelligence Engineer at Deloitte
Kalamaria
Summary
Data Integration Specialist and Business Intelligence Consultant with a proven track record in designing and delivering scalable, results-driven data integration solutions using Azure Data Factory (ADF) and SQL Server Integration Services (SSIS). Expertise includes building and optimizing ETL pipelines, data workflows, and comprehensive data warehouse solutions tailored for enterprise environments. Proficient in data modeling techniques such as star and snowflake schemas, along with strong SQL skills in T-SQL, data migration, replication, and complex query development. Demonstrated ability to integrate diverse systems including SAP, Salesforce, and Oracle into cohesive enterprise data workflows while leveraging tools like Power BI, Tableau, and SSRS for impactful data visualization.
Overview
20
20
years of professional experience
5
5
Certifications
2
2
Languages
Work History
Data Integration Engineer - Business Intelligence Specialist
Deloitte
12.2021 - Current
- Expertise in Azure services including Data Factory, SQL Database, Synapse, Data Lake, Logic Apps, DevOps and Fabric.
- Proficient in and Microsoft Fabric and Informatica IICS Cloud ETL tool
- Develop, manage, and optimize end-to-end ETL processes, ensuring seamless data integration and transformation across diverse platforms.
- This includes designing complex data pipelines using Azure Data Factory and Informatica IICS, leveraging Azure Functions for automation, and orchestrating data flows in real-time for Power BI.
- Expertise in data cleansing, transformation, and loading to support efficient data warehousing, analytics, and reporting solutions.
- Skilled in performance tuning and monitoring ETL workflows to ensure data integrity, scalability, and optimal processing times.
- Design comprehensive Microsoft BI architectures (SSAS, Power BI, Power BI Report Server, On-premises Data Gateway) for both cloud and on-premises environments.
- Build, deploy, and maintain reports and dashboards using Power BI.
Business Intelligence Data Specialist
iQom
10.2020 - 12.2021
- Identify, select, and customize the most useful tools for collecting and analyzing data and developing solutions to support the customer's goals.
- Proactively interpret the customer's needs, identifying the most suitable methodologies and approaches for their best satisfaction.
- Knowledge of Data Management and Data Warehousing (OLAP, Dimensional Modelling)
- Design on Microsoft BI architectures (e.g. Microsoft SQL Server, SSIS, SSAS, Power BI, Power BI Report Server, On-premises data gateway).
- Design, build and deploy reports and dashboards using Power BI, TARGIT, Reporting Services
Business Intelligence Consultant - Developer (TARGIT, Power BI)
ITS SA
09.2019 - 09.2020
- Provide analysis, design, development and deployment for Business Intelligence Solutions.
- Work with clients to understand, analyze, and refine the application requirements and, where needed, provides guidance on selection of BI tools and methodologies.
- Creating Business reports for various departments & end users.
- Further more capable of improving and optimizing BI solutions in order to achieve optimal performance.
- Working consistently towards meeting the project's specifications and ensuring the client's needs are met.
HR Web Application Analyst - Consultant
EPSILON HR
11.2015 - 09.2019
- Mastering and Maintaining a web collaboration portal (ESS) that interacts with Pylon payroll software and automates HR procedures and management for employees and managers.
- Design and Deliver projects based on customer needs related to Performance Appraisals, Training and Recruitment procedures, Organizational Roles, Train customers etc.
Application Development Analyst
EPSILON NET
12.2012 - 10.2015
- Collaborate with software development teams to efficiently design queries and expand DB schemas for existing and new applications
- Optimize and review SQL queries and create required reports
- Experience in writing stored procedures, views, functions, etc (TSQL)
- Knowledge of Microsoft Analysis Services (SSAS)
Senior Enterprise Resources Planning Consultant
Self-Employed IT Consultant
07.2005 - 09.2012
- Consulting and implementing Business Software. Especially in Enterprise Resource Planning Systems (ERP), Business intelligence (BI) and customer relationship management systems (CRM).
- I have implemented and supported business software in several enterprises.
- I am specialized in analyzing the business needs and adjusting the software to customer needs.
- Technologies: EpsilonNet Pylon, Entersoft Business Suite, Logic Business ERP, Crystal reports, OLAP
- Reporting, Microsoft SQL server, Microsoft office
WordPress Web Developer
Self Employed Freelance Web Developer
01.2010 - 04.2010
- Design, Develop and maintaining WordPress Corporate websites and eshops
Education
Accounting
Alexander Technological Educational Institute of Thessaloniki
Skills
Extract, Transform, Load (ETL)
Certification
Informatica Data Management Cloud (IDMC) Partner Bootcamp Associate
Projects
Oct 2023 – Present | MSC (Mediterranean Shipping Company)
- Goal: Create a common data storage and ADF processes to feed it.
- Responsibilities: Extract data from different sources, implement requested transformations, and load data into the final target Synapse database.
Oct 2022 – Sep 2023 | DiaSorin Pharmaceutical
Role: Technical Head – Middleware Informatica Integration Team
- Led the end-to-end Informatica integration layer connecting the IT landscape of a newly acquired company with DiaSorin’s ecosystem.
- Defined integration strategies and data flows using Informatica as the central middleware platform.
- Coordinated cross-platform integrations between SAP (ERP & Finance), Oracle (Databases & Applications), and Salesforce (CRM).
- Collaborated with 3 technical/functional teams to align requirements, standardize interfaces, and resolve integration challenges.
- Ensured data governance, quality, and compliance within integration processes.
Mar 2022 – Oct 2022 | Ferrero Rocher
- Goal: Create a common data storage and ADF processes to feed it.
- Responsibilities: Extract data from multiple sources, apply requested transformations, and load into the final target database.
Dec 2021 – Feb 2022 | Champion BI
- Goal: Collect and organize main business requirements.
- Defined the implementation roadmap to bridge the gap between information needs and available data.
Jun 2012 – Sep 2019 | Employee Self Service
- Developed a web collaboration portal integrated with Pylon payroll software.
- Automated HR procedures and management for employees and managers.
- Technologies: ASP.NET Classic, C#, SQL Server.
Timeline
Data Integration Engineer - Business Intelligence Specialist
Deloitte
12.2021 - Current
Business Intelligence Data Specialist
iQom
10.2020 - 12.2021
Business Intelligence Consultant - Developer (TARGIT, Power BI)
ITS SA
09.2019 - 09.2020
HR Web Application Analyst - Consultant
EPSILON HR
11.2015 - 09.2019
Application Development Analyst
EPSILON NET
12.2012 - 10.2015
WordPress Web Developer
Self Employed Freelance Web Developer
01.2010 - 04.2010
Senior Enterprise Resources Planning Consultant
Self-Employed IT Consultant
07.2005 - 09.2012
Accounting
Alexander Technological Educational Institute of Thessaloniki
Similar Profiles
Neo MojiNeo Moji
Junior Actuarial Analyst at DeloitteJunior Actuarial Analyst at Deloitte
Aishwarya BasaniAishwarya Basani
Audit Senior at DeloitteAudit Senior at Deloitte
Nkcubeko MehlwanaNkcubeko Mehlwana
Audit Trainee at DeloitteAudit Trainee at Deloitte
Rashed Bin ArabRashed Bin Arab
Audit Associate at DeloitteAudit Associate at Deloitte
Freiderikos TserkezidisFreiderikos Tserkezidis
Chief Financial Officer at General Hospital of Thessaloniki "George PAPANIKOLAOU"Chief Financial Officer at General Hospital of Thessaloniki "George PAPANIKOLAOU"