Azure Data Engineer | Power BI Expert | Freelancer
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.
Power BI (DAX, PQ/M, Visuals), Python
SQL Server, Databricks, Snowflake
SSAS, Power BI
Data Factory, Data Lake
Clouds & Dev Ops:
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
Data Engineer | Arvova Oy
02/2023 - 12/2023
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
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 Databrics, 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 pohatta.app (wakes up in 5s).
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