Tuadata Oy

Senior level data consultancy with love

Services

Offering high quality quality data consulting with almost a decade of experience. Focused on high quality data engineering and architect work. My roots are deep in Microsoft technologies from MS SQL Server to Azure Databricks and everything in between. I can provide wide range of services including complex database and data modelling work as well as Power BI development. I am also certified DataVault 2.0 practitioner.

Core offering

Data platform architecture and consulting

Data platform design, workshops, help with data architecture, best practices or even ad hoc analytical needs.

Data modelling and engineering

Helping to build scalable data platform solutions, design complex data models and integrate your systems to provide insights for your business.

End to End data services

Besides architecture design and engineering, Tuadata also provides high quality reporting solutions.

Skills

Data architecture, cloud tools and design

  • Data warehousing
  • Data warehouse architecture
  • DataVault 2.0 (certified)
  • Dimensional modelling
  • Implementing agile methodologies
  • Technological decisions
  • Git
  • CI/CD design
  • DevOps
  • PowerShell
  • Enterprise integration knowledge

Data engineering

  • SQL
  • Azure databricks (accredated)
  • ELT / ELT /ELTL
  • Azure SQL DB
  • Azure Synapse Analytics
  • MS SQL Server
  • Snowflake
  • Python / Pandas / PySpark
  • Agile Data Engine (ADE)
  • Multiple datasources, such as Salesforce, D365, Business central, AX, flat files, XML, JSON, multiple APIs, legacy databases etc.

Reporting

  • Power BI (certified)
  • DAX
  • SSAS
  • Governance models

Experience

Key projects

Music Industry: 2023/2 – ongoing

Agile Methods – Azure Data Factory – Azure Databricks – Azure DevOps – Azure SQL Database – Data architecture – Data Lakes – Data Management – Data Modelling – Data Visualization – Data Warehousing – DAX – ELT – ETL – Git – Github – Power BI – Power Shell – PySpark – Python – SQL – IBM DB2

Providing End to End data consulting for Finnish music industry customer. Working as data architect / engineer with diverse responsibilities from data architecture and integration design to PowerBI development and from coaching juniors to Databricks development. Main task being End to End data engineer in Azure environment. Data sources consist of multiple different file formats, API sources including Business Central, Lumoa and Salesforce. Also, legacy database sources such as DB2. Working with CI/CD pipelines for Databricks dashboards as well as doing Power BI development. High amount of volatile and rapidly changing data including transactional data.

Smart HR and payroll: 2023 / 8 – 2024 / 5

Agile Methods – Azure Data Factory – Azure DevOps – Azure SQL Database – Data Management – Data Modelling – Data Visualization – Data Warehousing – ETL – Git – Power Shell – SQL

Main task was to help the customer to tune their development processes. My task was to
create framework for efficient development, to help to choose right tools to implement
that and to implement technological solution for that in Azure/Microsoft environment.
Also helped customer with complex SQL and ETL problems as well as query optimizing.

Public sector: 2022 / 6 – 2023 / 2

ADE – Agile Methods – Airflow – Azure Data Factory – Azure DevOps – Azure Storage – Azure Synapse Analytics – Data architecture – Data Management – Data Modelling – Data platform architecture – Data Vault 2.0 – Data Visualization – Data Warehousing – DAX – ELT – ETL – Git – Power BI – SQL

Data engineer for Finnish public sector customer in news feed level projects. Mainly responsible for logical and physical data models, helping juniors with more complex ADF and Power BI tasks and taking care of technical as well as non-technical development processes. Worked all the way from ingestion to reporting. Data sources consisted of flat files and different APIs from multiple third parties and internal data sources

Energy: 2020 / 3 – 2023 / 2

ADE – Agile Methods – Airflow – Data architecture – Data Management – Data Modelling – Data platform architecture – Data Vault 2.0 – ELT – ETL – Git – Github – Jenkins – Microsoft SQL Server – Pandas – Python – SQL – SSIS

Building data platform solution. My main task was DV2.0 modelling, database optimization and publish layer design. Also worked with orchestration and Jenkins configurations. Data sources consisted of APIs, files, flat files etc.

Pension insurance: 2019 / 6 – 2020 / 2

Agile Methods – Data Management – Data Modelling – Data Visualization – Data Warehousing – DAX – Git – Microsoft SQL Server – Power BI – SQL – SSIS/SSRS/ SSAS

Worked as BI consultant for a Finnish pension insurance company. Responsibility was to work with SSAS Tabular models and Power BI reporting related to real estate, other investments and insurances. Also helped with dimensional modelling.

Manufacturing: 2017 / 8 – 2019 / 6

Agile Methods – Data Management – Data Visualization – Data Warehousing – DAX – ETL – Git – Microsoft SQL Server – Power BI – SQL – SSIS/ SSRS/ SSAS

Worked as a consultant to help the customer with near real-time analytics for quality
assurance in their factories located in multiple time zones for unified quality data
platform. Platform also worked as a data warehouse for quality reporting. Worked with
data modelling, stored procedure and SSIS based integrations and SSRS/SSAS/Power
BI based reporting. Also helped thecustomer with MDM. Same customer followed me
and my colleague from previous employer to next one

Various industries: 2016 / 10 – 2017 / 8

Data Modelling – Data Visualization – Data Warehousing – DAX – ETL – Git – Microsoft
SQL Server – Power BI – QlickView – SQL

Main responsibilities were to develop and maintain DW and reporting solutions for
customers in various industries. Worked with MS BI Stack and QlikView.

Certifications

  • Certified Data Vault 2.0 Practitioner (CDVP2) by Learndatavault.com
  • Databricks Fundamentals Accreditation by Databricks academy
  • Analyzing and Visualizing Data with Power BI by edX

Testimonials

”Miika helped us to streamline and standardize the setup of our clients’ Azure environments. With Miika’s help, we transitioned from person-dependent tasks to an almost fully automated creation process.”

Customer Smart HR and payroll

”Miika has the ability to quickly grasp even large-scale concepts and provide insight on how things could be improved.”

Customer Smart HR and payroll

About Tuadata

Founded 2023 by Miika Arvola (MSc tech). Tuadata is Tampere based, AI since birth, experienced, trustworthy, efficient, relaxad and highly skilled one man data consultancy. Specialized on complex data problems within various industries.

Ask for services or CV.

What Tuadata stands for?

Experienced

Tuadata offers highly experienced data consulting for multiple industries with almost 10 years of experience.

Quality

With Tuadata, the customer can trust to achieve high quality data solutions.

Trustworthy

If something is agreed on, it will be done with high quality.