Moving Home Assistant Data to Cloud PostgreSQL with Python ETL
Move Home Assistant sensor history to cloud PostgreSQL with a Python ETL pipeline. Learn incremental loading, SSH transport, Bronze/Silver/Gold modeling, and run monitoring.
Read articleAUTHOR / PROFILE
ICT Project Manager · Data Engineer
Timo is an ICT Project Manager and Data Engineer focused on practical data platforms, automation, and infrastructure. His professional background combines enterprise data warehousing, Python and SQL development, reporting, and technical project delivery.
Published Articles: 2

Timo Rautio works at the intersection of data engineering and project delivery. His professional experience includes enterprise data warehouse development, ETL, data quality, data modeling, analytics, and reporting. He is interested in making technical systems understandable and maintainable: clarifying requirements, validating data, and building reliable flows from source systems to useful reporting.
Timo's public CV describes data-focused ICT project management and enterprise data warehouse work, including coordination of requirements, scope, risks, documentation, developers, data flows, ETL, data quality, data modeling, and reporting. His earlier ICT Specialist work included ERP-supported business processes, Odoo implementation, and a Python workflow for transforming operational XML data into traceable ERP records.
His independent portfolio projects include a Python and PostgreSQL pipeline that transfers selected Home Assistant history to a cloud warehouse, self-hosted Git and homelab infrastructure, an Astro portfolio with automated deployment, and AI-assisted data and multi-agent workflows. These projects show how he approaches implementation, automation, and operational clarity outside his professional role. See the project catalogue and the blog for the underlying work.
Technologies documented in Timo's CV and project work include:
Kubernetes, MLflow, KServe, Keycloak, and Vault are additional areas of technical interest and exploration; they are not presented here as technologies used in the professional experience summarized above.
The strongest documented experience is in data engineering, project delivery, and practical infrastructure work. MLOps and Kubernetes are included as technical focus areas rather than claims of production experience.
Timo writes about data pipelines, incremental ETL, data platforms, automation, self-hosted infrastructure, static-site development, and the design decisions behind practical technology projects. Posts connect implementation details with trade-offs, reliability, and lessons learned.
Move Home Assistant sensor history to cloud PostgreSQL with a Python ETL pipeline. Learn incremental loading, SSH transport, Bronze/Silver/Gold modeling, and run monitoring.
Read article ↗Build an Astro portfolio from a CV using Markdown, Docker, GitHub Actions, and Nginx; learn how static content is generated and deployed through a repeatable container workflow.
Read article ↗