Zoltán Tálas-Data Architect
Check rate
Experience
Data Architect
Europaeiske ERV (ERGO Group AG)
- Provide technical leadership within a 5-person DWH team maintaining an insurance Data Warehouse for claims, policy, finance and management reporting.
- Maintain and extend dimensional models and reporting structures supporting downstream Power BI, SSRS and SSAS consumption.
- Stabilise business-critical finance and IFRS reporting by resolving recurring data quality, transformation logic and SQL/SSIS processing issues.
- Helped improve quarterly IFRS report quality from approximately 60% to around 98% across PRE and ACT reporting cycles.
- Troubleshoot and optimise complex T-SQL stored procedures, SSIS packages and SQL Server data flows.
- Technologies: SQL Server, T-SQL, SSIS, SSRS, SSAS, SSMS, Power BI
SQL Domain Expert / AI Model Trainer
Bluebird
- Applied deep SQL and database expertise to train and evaluate large language models on complex database reasoning tasks.
- Designed advanced SQL training and evaluation scenarios covering correctness, optimisation, execution plans, indexing, data modelling and cross-database behaviour.
- Evaluated and corrected AI-generated SQL across Oracle, PostgreSQL, SQL Server, MySQL, BigQuery, Hive and SQLite using synthetic enterprise-style datasets.
- Served as reviewer and senior reviewer, ensuring task quality, evaluation consistency and high standards across SQL-focused model training workflows.
- Technologies: Oracle, PostgreSQL, SQL Server, MySQL, BigQuery, Hive, SQLite
Big Data Architect / Team Lead
K&H Bank
- Technically led a 3-person team developing a near-real-time banking messaging platform for push, SMS, email, system and campaign communications.
- Established code review, logging, clean code and maintainability standards across Oracle, Python and Airflow components.
- Reused legacy Oracle stored procedures and Python logic while introducing Airflow-based orchestration for future cloud alignment.
- Supported hybrid architecture planning, connecting on-premise Oracle/DWH capabilities with longer-term cloud platform direction.
- Technologies: Oracle, PL/SQL, Python, Apache Airflow, Hadoop
Big Data Architect
British Petroleum
- Took ownership of an existing Cloudera-based data lake and reporting platform, leading 2 developers across Informatica Big Data ETL, Hive/Impala data structures and Power BI reporting support.
- Supported multiple downstream reporting consumers by investigating data quality, processing and operational issues across the Cloudera/Hadoop environment.
- Led technical migration of multiple legacy reporting applications to Azure using Azure Databricks and Azure Data Factory.
- Designed a pragmatic migration pattern with ADF used for scheduling/orchestration and Databricks notebooks handling SQL/Python transformation logic, parallel processing and load control.
- Built detailed source-to-target validation across row counts, column values and business rules to prove data consistency between legacy and migrated solutions.
- Identified and corrected legacy defects during migration, delivering the new reporting solution according to plan while improving accuracy versus the original implementation.
- Technologies: Cloudera, Informatica Big Data Management, Hive, Impala, Hadoop, Azure Databricks, Azure Data Factory, SQL, Python, Power BI
Staff Data Engineer
Hortonworks / Cloudera
- Created a centralised engineering reporting platform where release validation data had previously been fragmented across Jira, Git and test execution systems.
- Integrated Jira issue data, Git commit history, release metadata and Elasticsearch-based test results to provide a unified view of component quality across release cycles.
- Enabled development teams to analyse regressions, fixes and test outcomes, making it easier to understand which releases introduced or resolved specific issues.
- Owned end-to-end database and reporting architecture, from data model and ingestion logic to Tableau/Superset dashboards and Docker/Kubernetes deployment.
- Acted as the primary database and reporting specialist within an approximately 8-person internal platform team, combining architecture, development and stakeholder collaboration.
- Technologies: Cloudera, Hortonworks, Hive, Impala, Spark, Hadoop, Elasticsearch, Kibana, Logstash, PostgreSQL, Tableau, Apache Superset, Docker, Kubernetes, Jira, Git, Python
Lead Data Engineer/Data Architect
GE Digital
- Served as data architect for an approximately 15-person data & analytics delivery team, shaping technical direction for DWH, data lake, reporting and analytics initiatives.
- Designed enterprise DWH and analytical backend solutions primarily on Greenplum, with additional Oracle and PostgreSQL implementations.
- Guided ETL/data integration delivery using Talend and Informatica, supporting enterprise reporting and Tableau consumption.
- Acted as escalation point for complex SQL, data modelling and reporting performance issues across critical analytics projects.
- Optimised Tableau and handheld field reporting backends, reducing key report runtimes from minutes or non-completion to under one second.
- Technologies: Greenplum, Oracle, PostgreSQL, Informatica, Talend, Solr, Elasticsearch, Kibana, Logstash, Spark, Hadoop, Hive, Parquet, ORC, Python, AWS, Tableau
Data Engineer
Secret Sauce Partners
- Built the company’s first scalable DWH / big data platform for fashion-tech analytics products, supporting Fit Predictor, size recommendation and personalisation use cases.
- Integrated multi-tenant e-commerce data across orders, returns, product/size charts, clickstream events and customer behaviour signals from multiple clothing brands.
- Helped scale the architecture from PostgreSQL/Pentaho to AWS/Hadoop as major customer growth exceeded the limits of the original relational platform.
- Developed batch processing pipelines using S3, EMR, Hive, Pig Latin, Parquet and Sqoop, with Redshift handling high-volume clickstream analytics of approximately 10M+ daily events.
- Loaded curated analytical outputs into MongoDB to support the Fit Predictor algorithm and application consumption, and delivered BI datasets for reporting.
- Technologies: AWS EMR, S3, Redshift, Hadoop, Hive, Pig Latin, Spark SQL, Avro, Parquet, Sqoop, MongoDB, PostgreSQL, Pentaho, Tableau, Superset, Snowplow
DWH Architect
HP Hungary
- Worked on Vodafone’s enterprise Oracle-based DWH, adapting dimensional models, ETL logic and Business Objects reporting structures.
- Supported Siebel CRM implementation and integration into downstream DWH/reporting processes.
- Guided 2 developers across PL/SQL, Oracle Warehouse Builder ETL and production support activities.
- Technologies: Oracle, PL/SQL, Oracle Warehouse Builder, Business Objects
BI/DWH Developer
Tata Consultancy Services
- Delivered enterprise Data Warehouse solutions for GE Capital, implementing ETL processes and dimensional models to support reporting requirements.
- Designed and developed ETL using Informatica, and created reporting structures and BI artifacts.
- Provided production support, release management and stakeholder coordination to maintain data availability and quality.
- Technologies: Oracle, Informatica, Business Objects, QlikView
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Banking and Finance, Telecommunication, Fashion, Energy, and Insurance.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Product Development, and Research and Development.
Summary
Senior Data Architect with 20+ years of experience designing and delivering enterprise DWH, data lake and analytical platforms across banking, insurance, telecom, energy and retail technology. Expert in dimensional modelling, ETL/ELT architecture, SQL performance tuning and large-scale data migration. Proven technical leader with experience mentoring teams, stabilising business-critical reporting, building greenfield data platforms and supporting cloud/big-data migrations across Azure, AWS and Cloudera-based environments.
Skills
Data Architecture | Dwh & Data Marts | Dimension Modelling | Etl / Elt Architecture | Data Integration | Data Migration | Data Quality | Sql Performance Tuning | Bi & Reporting | Data Lakes | Cloud & Big Data Platforms | Data Engineering | Technical Leadership
Data Architecture: Enterprise Dwh, Data Marts, Dimension Modelling, Star Schema, Scd, Olap, Kimball, Inmon, Row-Based Storage, Columnar Storage, Data Lake Architecture, Data Migration, Data Quality
Sql & Databases: Oracle, Sql Server, Postgresql, Greenplum, Redshift, Bigquery, Mysql, Hive, Pl/Sql, T-Sql, Sql Performance Tuning
Etl & Orchestration: Informatica, Informatica Bdm, Owb, Talend, Pentaho, Ssis, Airflow, Azure Data Factory, Azure Databricks Workflows
Bi & Reporting: Tableau, Power Bi, Business Objects, Qlikview, Superset, Kibana, Ssrs, Ssas
Nosql: Mongodb, Solr, Elasticsearch
Cloud & Big Data: Aws, Emr, S3, Redshift, Cloudera, Azure, Hadoop, Spark, Hive, Impala, Pig, Parquet, Avro
Other: Shell, Python, Git, Jira, Confluence, Agile, Scrum, Docker, Kubernetes
Languages
Education
International Business School (IBS)
Economic degree, specialization in BI · Economics · Budapest, Hungary
Statistics
Experience
Global Experience
Expertise
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Architect
Nearby freelancers
Professionals working in or nearby Budapest, Hungary
