03 / CV

Timo Rautio Data Engineer, SQL, Python & Data Platforms

Data Engineer and ICT Project Manager with hands-on experience in SQL, Python, enterprise data warehousing, ETL, data quality, reporting and analytics. I build reliable data flows and models, investigate the logic behind business figures, and connect technical delivery with the needs of stakeholders and decision-makers.

Discuss an opportunity ↗

Relevant technical capabilities

Data engineering focus

SQL & data platforms

SQL
Relational databases
Data warehousing
Data modeling
Source-to-target mapping
Incremental loading

Python & pipelines

Python
Pandas
ETL / ELT
API and file ingestion
Validation
Operational monitoring

Quality & analytics

Data quality
Reconciliation
Metric definitions
Power BI
DAX
Reporting
Decision support

Delivery practices

Git
Documentation
Requirements
Risk assessment
Stakeholder alignment
Agile / SAFe-inspired delivery

Timeline

Experience

2023–present

ICT Project Manager, EDW & Reporting

Finnish Customs

Manage data-focused development projects end-to-end in a high-security environment, coordinating stakeholders, scope, timelines, risks, requirements, documentation, and developers.
Maintain and develop the enterprise data warehouse, including data flows, ETL, data quality, data modeling, reporting, and lifecycle management.
Guided a team-level transition from waterfall towards a SAFe-inspired way of working, improving transparency, workload management, collaboration, throughput, and cadence.

2010–2023

ICT Specialist

Taitonetti Oy / Nuvoo Oy

Developed and maintained ERP-supported business processes, including Odoo implementation, configuration, rollout, user training, and business alignment.
Designed scalable device processing, warehouse management, and internal logistics processes, including a Python pipeline transforming Blancco XML into traceable ERP data.
Worked with B2B and B2C customers in Finnish, Swedish, and English across sales, support, maintenance, and service operations.

Education

Learning

2022–2024

Master of Business Administration

OAMK

Data Analytics and Project Management.

2011–2016

Bachelor of Business Administration

OAMK

Information Technology and Web Application Development.

2025

Customs Sector Basic Training, TPK E

Finnish Customs

2023

IBM Data Warehouse Engineer Professional Certificate

Coursera

2022

Data Analytics and Predictive Analytics

Xamk & Haaga-Helia University of Applied Sciences

Data analytics for business development and decision support.

Broader toolkit

Supporting skills

Data & Warehousing

Data architecture
Data modeling
Master data
SQL
ETL / ELT
Data pipelines
SSIS
Apache Airflow
Enterprise data warehouses
On-prem environments

Analytics & BI

Power BI
DAX
Reporting
Data analytics
Data visualization
Predictive analytics
Decision support
Self-service BI
Plotly
Seaborn
Matplotlib
Streamlit

Governance & Delivery

Data governance
Data quality
Data lifecycle management
Metadata and traceability
Information security
Requirements specification
Risk assessment
ICT project management
Procurement processes
SAFe / Agile-inspired development

Development & Collaboration

Python
Pandas
NumPy
Machine learning
Odoo
ERP development
Jira
Confluence
Facilitation
Technical documentation
Stakeholder alignment

Selected practical work

Projects

Data quality

Data quality analysis tool

Python-based tool for analyzing CSV and Excel datasets, including structure, distributions, quality metrics, correlations, and categorical variables.

Combines pandas, NumPy, Seaborn, Matplotlib, and an AI-assisted analysis workflow to produce practical strategic and operational data quality insights.

Visualization

Interactive location analytics

Python-based map visualization combining Statistics Finland geospatial data with sales data to create interactive heatmap views.

Built with GeoPandas and Plotly to support exploration of spatial patterns and clearer data-driven decision-making.

ETL · Data platform

Home Assistant data pipeline

Python and PostgreSQL pipeline for incrementally transferring numeric sensor data from a self-hosted source into a cloud warehouse through an SSH tunnel.

Uses Bronze, Silver and Gold layers, batch loading, transaction handling and operational run logging to make the pipeline observable and recoverable.

View More Projects ↗

Core strengths

Approach

Clear communication, empathy, analytical thinking, adaptability, structured facilitation, rapid learning, and ownership of complex challenges. I enjoy acting as a bridge between technical and non-technical stakeholders and creating clarity through practical solutions, strong documentation, and continuous improvement.