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 pohatta.app (wakes up in 5s).
Tech: Javascript, react, nestjs, nodejs

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

Industries:
Event organizing, Construction, Import (alcohol), Food Storing, Networks, Retail (furniture), Advertising (medical), Consulting, Accounting, Mining, Moving Services, Automotive, Real Estate
Solutions:
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