Software Engineer
Warsaw, Poland
☎️ +48 123 456 789 | 📧 example@gmail.com | 🔗 LinkedIn | 🐙 GitHub
I’m a software engineer with 5+ years of experience and co-author of two scientific papers in electrical engineering.
April 2023 - Present | Warsaw, Poland
Developing and maintaining an internal system for managing campaigns in the advanced advertisement area. I primarily work on backend services (FastAPI, Flask, Tornado). My responsibilities include gathering requirements from product owners, collaborating with the data science team to design the best technical solutions, implementing them, and maintaining them in production. I am also heavily involved in developing CI/CD pipelines (GitHub Actions) and ETLs (Argo Workflows). My role focuses on ensuring the reliability, scalability, and performance of the systems I work on, optimizing queries and data models to efficiently handle large volumes of data in both PostgreSQL and Snowflake.
Key Achievements
After we moved from Redshift to Snowflake, I was a key developer in building a tool that can sync production and other environments using Snowflake zero-copy cloning feature. It fixes permission issues, copies metadata (like stages and external tables), updates storage integrations, and applies the right permissions. This made dev/uat environment synchronization simple and fully automated.
I created an internal library that caches and mocks code connecting to external data providers for data science PoCs. It provides simple decorators that save fetched data to S3 (or other storage) and automatically mock external calls during tests (pytest). As a result, support tickets dropped by about 50%.
August 2015 - March 2023 | Warsaw, Poland
Led end-to-end development of data processing tools and advanced optimization models in Python using NumPy, Pandas, and Gurobi, creating solutions to optimize Poland’s energy mix, manage power flows, and ensure grid reliability. Processed large datasets efficiently, simulated multiple electricity supply scenarios, and identified cost-effective, low-emission strategies. These models were applied in two published research papers on energy security and power system management.
Developed a tool to estimate outage costs for the Polish transmission system. The Polish TSO used this tool to justify several critical investments, applying Monte Carlo simulations and parallel computing on NCBJ clusters to evaluate multiple large-scale scenarios efficiently. The tool implemented complex optimization model (MILP) written in Gurobi.
Built from scratch a PostgreSQL + PostGIS system, integrating geospatial data from Geoportal and other public sources to enable fast, scalable analysis for energy and infrastructure planning. Implemented backend data scraping and processing in Python using GeoPandas, SqlAlchemy, and Alembic for efficient handling of large datasets. Developed several spatial data algorithms, including methods for calculating distances between buildings and linear objects (e.g., gas pipes, power lines), which were also applied in my Master’s thesis.
Developed a Streamlit app to optimize cost-efficient solar installations for individual buildings in the prosumer system. Implemented the optimization as a linear model using the GLPK solver and deployed on AWS EC2.
Developed the application to optimize municipality energy mix and managed a small development team. Worked on the backend with FastAPI, SqlAlchemy,Alembic and data pipelines with Apache Airflow.
Full list on Google Scholar.
Management of Power Systems in Emergency States, 2016 - co-author (PDF)
Energy Security in the Era of Climate Neutrality, 2020 - co-author (PDF)
Warsaw University of Technology | 2017 - 2022
Thesis: “Methods of assessing the distance between buildings and linear objects on the basis of
various geospatial data (Python)”
Warsaw University of Technology | 2011 - 2017
Thesis: “Utilization of selected methods for assessing the impact of emergency outages in analyses of operating meshed transmission network conditions. Computer program to visualization of cascade failures (Matlab).”
I hereby give consent for my personal data included in my application to be processed for the purpose of conducting recruitment for the position for which I am applying. I also consent to processing of my personal data for the purposes of any future recruitment processes.