Mikko Vikman

Azure Data Engineer | Power BI Expert | Freelancer


  • 2023 / dbt Fundamentals
    dbt Labs
  • 2022 / Data Engineer Associate
    Microsoft (DP-203)
  • 2022 / Data Analyst Associate
    Microsoft (DA-100)
  • 2022 / Data Fundamentals
    Microsoft (DP-900)
  • 2022 / Azure Fundamentals
    Microsoft (DA-100)
  • 2021 / Power Platform Fund.
    Microsoft (PL-900)


  • English
  • Finnish


  • Bachelor of Business
    Administration 2011 - 2014, HAAGA-HELIA


I'm a Microsoft certified data expert who loves to help and to solve problems with clients from all industries and all sizes. My background is from business analysis and thereafter from 2016 I have been specializing in Azure data platform and Power BI.

I favor open and frank communication. I don't talk much, but I will listen and understand your needs. I'm an introvert, a slow thinker, and a good writer.

Top Skills

Data Analytics:

Power BI (DAX, PQ/M, Visuals), Python

Data Warehousing:

SQL Server, Databricks, Snowflake

Data Models:

SSAS, Power BI

Data Ingestion:

Data Factory, Data Lake

Clouds & Dev Ops:

Azure, bicep


Python, SQL, Javascript




Analytics Engineer | Aktia
01/2024 -

Aktia is a Finnish asset manager, bank and life insurer that has been creating wealth and well-being from one generation to the next for 200 years.
My role: Build data models and Power BI reports.
Tech: dbt, Snowflake, Power BI

Data Engineer | Arvova Oy
02/2023 - 03/2024

Arvova is developing a SaaS product for customer value management.
My role: build IaC pipeline with Terraform, build CI/CD pipelines with Azure DevOps, build ADF pipelines, Snowflake scripting, data modelling, product development (SaaS), Power BI reporting.
Tech: Snowflake, SQL, Azure DevOps, Terraform, Python, Pandas, Azure Data Factory, Data Lake, Power BI

Data Engineer | Varma
05/2023 - 12/2023

Varma provides pension insurance for Finnish work and is a pioneer in work ability management.
My role: build ADF pipelines, data models and Power BI reports (Databricks lakehouse & SSAS & PBI).
Tech: Databricks, PySpark, Python, SQL, Azure Data Factory, Data Lake, SSAS, Power BI

Integration Developer | 2M-It
03/2023 - 06/2023

2M-It provides ICT solutions and related support for wellbeing services counties.
My role: Build data integrations and data related pipelines.
Tech: Python, PySpark, Pandas, Cloudera, Hue, HDFS, Oozie, Postgre SQL

Data Engineer | Camden A.I.
08/2022 - 01/2023 (6 months)

Camden A.I. is an UK based company creating intelligent analytics and solving complex business challenges for clients mostly in retail sales (eCommerce).
My role: build ADF pipelines, build dw's, write SQL procedures, data modelling, product development (SaaS), improve current technical solutions, Power BI reporting.
Tech: Azure SQL Server, Azure Data Factory, Data Lake, SSAS, Power BI

Data and Analytics Consultant | Hospitality
2021 - 2022 (total 9 months) | Client size 77 MEUR (2021)

The client needed urgent help with Power BI reports from their reservation system. Initial needs were solved using a super simple SQL dw and thereafter a more robust analytics system was created with Azure Databricks.
My role: design and implement meta driven dw for Databricks, build ADF pipelines, data modelling write SQL and PySpark notebooks, technical coaching for the clients team, optimize and create Power BI measures, build Power BI reports for reservations, occupancy, pricing and point of sales, coach client's internal Power BI devs.
Tech: Databricks, PySpark, Delta-Lake, Data Factory, Data Lake, Power BI, SQL Server

Data Architect | Construction
01/2022 - 04/2022 (3 months) | Construction budget 800MEUR

The client needed an analytics system for a very large scale building project. The client requested long-term data storage and BI solution. They required a robust system that was flexible enough to grow with future needs.
My role: design CI/CD pipelines, design a meta driven SQL dw, write SQL procedures, configure ADF pipelines, support team with SQL and ADF.
Tech: Data Factory, SQL Server, Data Lake, Dev Ops, bicep

Data Warehouse and Analytics Consultant | Logistics
08/2021 - 04/2022 (9 months) | Client size 144 MEUR (2021)

The client wanted to modernize and clean outdated on-prem Oracle SQL data warehouse using Azure Data Platform. Old dw was replaced with a meta driven Azure SQL dw utilizing Kimball's principles.
My role: build CI/CD pipeline for the dw, edit IAC pipeline (Terraform), meta driven dw design, dw data modeling, dw delivery, write sql procedures, build Power BI reports (data model, measures, visualization) for financial reporting and goods volumes, coach client's internal developers.
Tech: Data Factory, SQL Server, Data Lake, Power BI, Terraform

Power BI Architect | Consulting
02/2021 - 05/2021 (4 months) | Client size 52 MEUR (2021)

The client had built a data storage with Postgre SQL database in AWS cloud. They wanted to gain insights of the data using Power BI.
My role: build complex sql queries (Postgre), desing BI data model, build Power BI reports (project profitability, resource utilization, people), coach client's internal Power BI developers, develop Power BI governance & best practices principles.
Tech: Postgre SQL, Power BI

Developer | Multiple Industries | Side Project
2019 - 2021

I built Word Press sites and created content for small companies. Most successful site went from no audience to around 400 weekly users.
Tech: Word Press, HTML, CSS, SEO, Content marketing

Business Insight Consultant | Wholesale
10/2019 - 12/2020 (1 year 3 months) | Client size 170 MEUR (2018)

The client required a modern data analytics solution after new ERP implementation. The solution was built using Azure Cloud and Power BI.
My role: participate in sales, deliver a dw, write sql procedures, configure ADF pipelines, design and implement data model, create Power BI reports for sales, availability and domain specific inventory balance reports."
Tech: Data Factory, SQL Server, SSAS, Power BI

Developer | Personal Finance | Side Project
2018 - 2019 (1 year 4 months)

I started a personal finance webservice. Fun project, learned a lot, never finished. Demo at (wakes up in 5s).
Tech: Javascript, react, nestjs, nodejs

Power BI Consultant | Multiple Industries
2016 - 2018 (27 one person 10-30-day projects)

Event organizing, Construction, Import (alcohol), Food Storing, Networks, Retail (furniture), Advertising (medical), Consulting, Accounting, Mining, Moving Services, Automotive, Real Estate
Sales, Finance, Contracts, Projects, Efficiency, Contributions, Sales Forecast, Fleet Management, Add Inventory, NPS, Cohort Analysis
My role: everything, definitions, reports, data models, calculations, visualizations, onboarding.
Tech: SQL Server, Power BI


Send me an email and let's discuss the details of your project! You can read more of my thoughts about data and business intelligence from the blog .