I am Bartosz Wiecha

Senior Data & Analytics Engineer, Tech Lead
Risk IT Department
Stakeholders: Risk Business, Banking IT, Banking Business

As a Senior Data & Analytics Engineer / Tech Lead, I lead Data & Analytics initiatives, with additional expertise in DevOps/DataOps and Data Architecture & Governance.

Leading the decommissioning of a legacy Risk Data Warehouse and building a new Data Platform for all Risk-related data, overseeing both technical and administrative aspects, including planning, stakeholder coordination, and approvals.

Driving the strategy and execution for replacing the legacy system, ensuring minimal disruption and alignment with business priorities.

Analyzing 10+ Risk source systems to understand data production and flows across systems.

Designing and implementing a new ingestion and transformation engine in the Data Lake (Cloudera, Spark, Parquet, Iceberg, dbt, CDC, Great Expectations).

Introducing Data Quality, Data Observability, Data Governance, and Data Contract components into the newly built Data Platform.

Mentoring and training team members to enhance their Data Engineering skills, promoting best practices and competency growth across the team.

Collaborating with Data Engineers from Banking IT and Information Technology & Services to define common, bank-wide data engineering standards, contributing to the creation of a Data Engineering & Analytics Centre of Excellence (COE).

Data & Analytics Engineer
General Secretariat, Information Technology and Services Department
Stakeholders: FinOps, Procurement Department

Developed the Bank's first-ever centralised Data Platform to unify cost tracking and cost optimisation. Reduced manual effort by 60% (96 to 38 man-days) by replacing Excel-based business processes with a single source of truth data solution. Enabled self-service and on-demand reporting, including integrated reports for the Bank's COO Department (180+ users).

Modeled data for Accounting and Budgeting (General Ledger, Cost Centre, Accounts Receivable, Accounts Payable, Fixed Assets, Cost), Party, and Procurement modules

Architected, designed, orchestrated (Airflow, Dagster) and maintained data pipelines and transformations (dbt, dlt, REST API) to integrate data from various sources, including Oracle Fusion ERP, Workday and ServiceNow, across both non-containerized and containerized environments.

Migrated an on-prem Spark solution to the Databricks platform, including Unity Catalog and business logic in the Gold Layer.

Drove DevOps and DataOps adoption by introducing CI/CD processes and pipelines (Azure DevOps, GitHub); implemented the Elastic Stack (ELK) for logging and monitoring (Dagster, Airflow, dbt and deployments); and established observability practices and processes to ensure data quality and system reliability.

Developed Data Lake ingestion processes (batch and real-time) and storage mechanisms. Introduced a Data Contract framework.

Built a chatbot (based on LLM, RAG and LangChain technologies) to help business users understand Data Platform's data and metric definitions.

Developed several applications (using Streamlit and containerisation technologies) to facilitate business users' interaction with the Data Platform, including development in Streamlit and management of containerized applications in Red Hat OpenShift Container Platform.

Participated in Cloud & Data Governance strategy meetings, including planning and execution phases of the Data Platform migration to Microsoft Azure.

Implemented the Security Model and Security Governance for data access across various Business Units, enabling tailored data access according to the Bank's security principles.

Led twice-monthly meetings of data professionals to present and discuss new technologies, proofs of concept (PoCs) and ideas.

Technologies: SQL Server 2022, Oracle 19c, PostgreSQL, DuckDB, Sybase IQ, T-SQL, PL/SQL, Data Vault 2.0, Python, C#, PySpark, Streamlit, dbt, dlt, Dagster, NiFi, Kafka, Airflow, Cloudera Data Platform, Microsoft Azure, Docker, Red Hat OpenShift, Argo CD, Azure DevOps, Octopus Deploy, GitHub, Elastic Stack (ELK), Open AI, Large Language Models (LLM), Langchain, Dataiku, Oracle Fusion ERP

As a Senior Data Engineer, I contributed to the development and maintenance of a Global Data Platform supporting Credit Suisse Trust locations worldwide (Zürich, Liechtenstein, Singapore, Bahamas, and Guernsey). My role involved gathering requirements, architecting and developing the platform, and supporting internal stakeholders (Finance/Controlling and Trust Advisory teams) with high-quality data delivery — both repetitive and ad-hoc. I also developed the CI/CD strategy and contributed to the creation of Security Governance and Data Governance frameworks.

As Technical Lead and Architect, I developed the TCO Financial Dashboard — a Total Cost of Ownership solution used by 25+ Cost Center and Project Owners daily. The dashboard also supports strategic monthly meetings between Finance, Controlling, and IT departments. It enhances visibility into project and cost center expenses, providing insights into both past and future financial figures, and improving decision-making through accurate cost allocation, resulting in monthly cost savings of 100,000 CHF.

Gathered business requirements from the Finance, Controlling, and Client-Facing departments.

Mapped business processes to data models and system design.

Performed data modelling (logical, physical) of the entire business (Accounting and Budgeting, Party Management, Assets).

Led the transformation of multiple disparate reports into a modern, centralised Data & Analytics Portal for over 150 users. This involved (re)writing reports and dashboards, streamlining report access, standardising formats and report lifecycles, and aligning with company branding.

Worked on a Global Data Lake solution to ingest and store all company data, serving various downstream systems. This involved both conceptual and architectural design, including development.

Designed and implemented standards for the Security Model and Security Governance of data access to the centralized Credit Suisse Trust Data Warehouse. As a result, access was expanded to a broader range of business users, increasing the user base from 6 to over 150.

Automated the financial Month-End Process, saving 5 man-days per month and significantly reducing manual effort.

Technologies: SQL Server 2017, T-SQL, Microsoft Business Intelligence (SSIS, SSAS, SSRS), MDX, DAX, Power BI, Biml, Powershell, Tableau (Desktop and Server), Excel, NavOne (3rd party tool for maintaining Trust businesses), Cloudera, HDFS, Apache Airflow

As a Senior Data Engineer, I worked on a Global Data Warehouse project for the entire company, focusing on Sales, COGS (Cost of Goods Sold), Inventory, and Supply Chain. The system gathered data from 45+ countries, processing over 5 billion rows.

Joined the project during its greenfield phase, allowing me to influence architectural decisions and implementation from the start. Built a complete end-to-end (E2E) solution based on the Microsoft BI Stack, including a BI portal for various stakeholders such as Management and the Sales Department in Switzerland, Spain, Italy, Brazil, and Hong Kong. Coordinated the implementation of CI/CD processes based on TFS, while overseeing and mentoring a team of six, including remote members.

Gathered business requirements from the Sales, Inventory, and Supply Chain departments.

As Technical Lead and Product Owner, I led the development of a solution for analysing website traffic based on Google Analytics data for the Marketing Team. The solution provided insights for targeted campaigns, resulting in a 25% year-over-year increase in online sales. I led architectural decisions and development while overseeing and mentoring a team of three.

Built a Data Quality / Data Monitoring Center solution for the entire company, which improved data quality and provided a better overview of the overall status of data quality.

Technologies: SQL Server 2016, T-SQL, Microsoft Business Intelligence (SSIS,SSAS,SSRS), Power BI, TFS, PSH, C#, Google Analytics

As an IT Consultant in Microsoft Practice, I delivered Microsoft technology solutions for clients such as Tesco, Qatargas, and the UK NHS. I also contributed to the development of an internal Azure Data Platform Framework.

Developed a prediction tool for Tesco's F&F clothing brand to analyse WSSI data (Weekly Sales, Stock and Intake), resulting in a 30% cost reduction.

Created a cost-optimisation solution for the UK National Healthcare Service (NHS) to improve purchasing of medical supplies and staff allocation, saving up to £100,000 per month.

Developed an application for Qatargas that helped analyse and improve wrench time on natural gas drilling rigs, leading to a 30% faster wrench time and a 40% reduction in accidents on sites.

Developed a solution for the UK NHS to gather and analyse KPIs (Key Performance Indicators) for defined diseases, providing insights into disease spread, impact, and optimal staff allocation through predefined reports and self-service BI.

Technologies: SQL Server 2012/2014/2016, T-SQL, Microsoft Business Intelligence (SSIS, SSAS, SSRS), Biml, Power BI, MDX, DAX, SharePoint 2010, Excel, Power Pivot, PowerView

As a Business Intelligence Consultant, I contributed to the development of a Data Warehouse for the Basel III Accords, which included the Financial Liquidity Reporting Portal, a Master Data Management solution, and integration between Oracle 12c, REST API, and SQL Server 2012.

Collected business requirements from the Risk Management department.

Performed logical and physical data modelling of the Risk Management data in line with Basel III Accords.

Served as the Architect of Master Data Management solution for Liquidity Risk Data Warehouse, unifying all core business and technical data into a single, managed and trustworthy point. This involved the conceptual design of Master Data, technical implementation, and the creation of a framework for working with Master Data.

Acted as a Scrum Master for a CI/CD (Continuous Integration / Continuous Delivery) team, leading daily stand-ups, retrospectives, sprint planning, and meetings with Product Owners and stakeholders.

As a part of the CI/CD Team, helped define CI/CD best practices for 6 Scrum Teams and Product Owners, totaling 50+ people. This included building the CI/CD process from scratch using Agile methodology and Microsoft TFS, defining the Definition of Ready (DoR) and Definition of Done (DoD), merging code standards, deployment pipelines.

Technologies: SQL Server 2012, T-SQL, Microsoft Business Intelligence (SSIS, SSAS, SSRS), Data Vault 2.0, Biml, Oracle 12c, PL/SQL, Tableau, C#, ASP.NET, REST API, Powershell, Master Data Services, Attunity for Oracle, IIS, TFS, XL Deploy, XL Release

I worked as a Business Intelligence Consultant, contributed to projects for various clients.

Migrated the Polish branch of Norway’s largest financial services group’s operations (modules such as Customer, Risk, General Ledger, etc.) from Oracle to SQL Server, rewriting 350,000+ lines of business logic and creating a Reporting Platform for 400+ users.

Developed a system for intergrating and automating crop ordering from various agricultural companies and farmers for one of the world's largest agricultural company. My contributions included developing a central system for automatic ordering, migrating of the solution from SQL Server 2005 into SQL Server 2008R2, implementing the EDI standard (Electronic Data Interchange), and setting up data-driven subscriptions to crop managers via SSRS and Email.

Owned an internal company system for Project Budgeting. Analysed and implemented the data model, developed an ETL layer to process data from SharePoint lists into a database and created of Analytical Cube and Reports for managers and Sites in SharePoint

Technologies: SQL Server 2005/2008R2/2012, Microsoft Business Intelligence (SSIS, SSAS, SSRS), T-SQL, MDX, Oracle 11g, PL/SQL, C#, SharePoint 2013

I worked as a Business Intelligence Consultant, contributed to various projects.

Built a new analytical platform for a Fund Trading Company (PKO TFI), implementing one of Poland’s first commercial SQL Server 2012 Business Intelligence platforms. Delivered a full end-to-end solution, from gathering requirements to building Business Intelligence solution and Reporting Platform.

Designed and implemented data batch loading processes from multiple external systems (including SAP) into ODS (Operational Data Store) and CRM database for Raiffeisen Leasing. Also developed reports and optimised internal CRM database.

Developed a system to support the vindication and restructuring processes for a corporate banking client (BRE Bank).

Developed reports for the CRM system of the City of Wrocław.

Built and application for Group Insurance for the Financial Services Department of the Insurance Corporation (ING Financial Services).

Technologies: SQL Server 2008R2/2012, Microsoft Business Intelligence (SSIS, SSAS, SSRS), T-SQL, MDX, C#, FetchXML, WCF, ASP.NET (MVC3), VBA, SharePoint 2010, Dynamics CRM 2011, CRM 2011 Online, Access 2003

I worked as a Business Intelligence Developer in the Business Intelligence Team, contributed to various projects.

Implementation of Reports for a public transport company in the City of Kraków. The reports were designed and implemented in SQL Server Reporting Services (SSRS), with stored procedures written in SPL (procedural language for Informix Database).

Worked on a series of projects within an IT program for an Insurance Company (Liberty Direct), which involved implementing ETL processes for the Claims Department, developing a Windows application (WinForms) for testing database queries, and creating a series of Visual Studio add-ins to support the maintenance lifecycle of the BI system.

Technologies: SQL Server 2008R2, Microsoft Business Intelligence (SSIS, SSAS, SSRS), T-SQL, LINQ, AMO, SMO, CLR, WinForms, Informix 7.3, SPL

I worked in a department that provided solutions for Polish Public Administration.

Servlets Code Optimisation in the ePUAP program (Elektroniczna Platforma Usług Administracji Publicznej, Electronic Platform for Public Administration Services).

Development of a Document Workflow Application for the City of Wrocław.

Extension of an existing CMS Portal for the City of Łódź, which involved adding functionality for BIP (Biuletyn Informacji Publicznej), the Polish Government Portal for serving information from various Public Administration offices, as well as migrating to an SSAS (Software-as-a-Service) delivery and pricing model, enabling new tenants to create sub-portals.

Technologies: Java EE (Servlets), Jave SE, Python, JavaScript, PostgreSQL