Markus Koch is an independent researcher and research advisor based in Portugal with over a decade of experience at the intersection of data science, simulation, and blockchain engineering. He has held senior research and product roles at Balancer and BlockScience, combining hands-on SQL/data-engineering work (notably creating production-ready on-chain SQL views for Balancer and Ethereum ETL pipelines) with systems-level simulation and modeling in cadCAD. His background spans government analytics leadership—where he built and led data science teams to detect misuse of public funds—to product and engineering roles in DeFi, showing an uncommon blend of public-sector rigor and crypto-native engineering. Markus regularly contributes to open-source analytics tooling for blockchain research and has practical experience integrating front-end, back-end, and on-chain data workflows. He brings a methodical, experiment-driven mindset to complex socio-technical systems, often surfacing subtle signals (e.g., liquidity mining and veBAL dynamics) that improve protocol analytics and decision-making.
10 years of coding experience
21 years of employment as a software developer
Engineer Industrial Automation, Engineer Industrial Automation at Universidade Federal de Santa Catarina
Engineer's Degree Mechanical and Industrial Engineering, Engineer's Degree Mechanical and Industrial Engineering at Ecole Nationale Supérieure d'Arts et Métiers
Contributions:105 reviews, 222 commits, 158 PRs in 1 year 8 months
Contributions summary:Markus contributed to the frontend application, focusing on features related to trade and liquidity mining within the Balancer protocol. They made changes to UI components like trade cards and tables, as well as integrating functionality for claiming rewards. The user also made changes to the backend by integrating polygon blockchain features. The user was involved in updating code and also refactoring parts of the application.
Airflow DAGs for exporting, loading, and parsing the Ethereum blockchain data. How to get any Ethereum smart contract into BigQuery https://towardsdatascience.com/how-to-get-any-ethereum-smart-contract-into-bigquery-in-8-mins-bab5db1fdeee
Role in this project:
Data Engineer
Contributions:1 review, 43 commits, 30 PRs in 1 year 5 months
Contributions summary:Markus primarily contributed to the data engineering aspects of the project, focusing on defining and creating SQL views for analyzing Ethereum blockchain data, specifically for Balancer pools. Their work involved the creation and modification of SQL views for various Balancer pool types (weighted, stable, meta stable) and their associated BPT token balances. The user also added logic to include weights, liquidity mining power, and veBAL balances to these views. These changes were essential for enabling the efficient querying and analysis of on-chain data within the context of the Ethereum blockchain and the Balancer protocol.
gcpethereumgoogle-cloud-platformcontractweb3
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.