Zsolt Szalai

I'm a Software Engineer, a dynamic personality with over 6 years' experience building scalable data systems and delivering solutions for on-premises and cloud technology.
Currently living in the greater Toronto area, and working in a Senior Data Engineer role at SEON.
I consider myself to be a professional and lifelong learner in the data field across multiple domains. Skilled in data warehousing, data modeling, automation, and leveraging available technologies in my arsenal to drive business value. Also passionate about engineering, artificial intelligence, collaborating across global teams, and advancing sustainability initiatives.
I love spending time on my computer or outdoors, and sometimes both.
Developed big data API event driven data processing pipelines with dynamic schema evolution for analytics and AI (Spark, Iceberg, Glue, Airflow)
Modeled and implemented a multi-region Snowflake DWH from Data Vault 2.0 to Medallion and Star Schema, improving data analytics (Snowflake, dbt)
Enabled data ownership and best-practices by adapting data governance tools, company-wide roles in a cross functional setting (Snowflake, Atlan)
Deployed, and enabled data processing and cloud infrastructure in new geographical regions on AWS using IaC (Terraform)
Data modelling, ETL and universe development, retiring old systems (SAP Business Objects, Power BI, Azure)
Oracle on-prem Data Warehouse migration into lakehouse architecture (Azure, Databricks, DBT)
Deveoped a high security data & interface management and archival system and built supporting data centric restful web applications (Oracle Apex, Kestra, KV stores, API integration)
Leveraged delta lake for scalable orchestrated pipelines and data workflows for B2B projects (Azure Data Factory, PySpark)
Allianz Technology
Data Infrastructure Engineer
2022/01 – 2023/11
Designed, implemented, automated and optimized data acquisition pipelines using SQL, Shell scripts, PL/SQL and Python
Built semantic layer for analyzing large volumes of actuarial finance data in an enterprise DWH setting (Oracle, Redshift)
Automated data quality checks for actuarial datasets and downstream analytics on AWS (using services such as Lambda, Glue, S3)
Platform and interface management across multiple systems using shell scripts and sas jobs
IBM Data Storage Systems Kft.
Database developer
2018/09 – 2021/12
Automated data warehousing solutions for BI, using Oracle and PL/ SQL .
Data driven restful bi web application development with Oracle APEX, APIs and Postgres.
Assisted in multi cloud projects for containerized application and database deployment (MCMP, Docker).
Automated data piplelines and onboarded service management systems (ServiceNow)
Development and implementation of plug-and-play SaaS product catalog (Fivetran)
Modern scalable data stack
Atomation with pipelines
Cloud-native solutions
AZ-900
Azure Fundamentals
Achieved: 2024
Personality traits
Work Style & Values