BI/DWH Analyst (ETL, GCP) - Banking

Quick Facts

• Role: BI/DWH Analyst (ETL, GCP) for a banking environment

• Focus: data warehousing, Lakehouse ingestion, ETL/Data Pipelines, and data integration

Description

Design and develop modern data solutions for banking, including data ingestion process design for DWH and Data Lake/Lakehouse and exposing data via services, files, and message queues. Work with business and IT to define data sources, integration requirements, and how the data is used. Support analysis through design, implementation, and testing, and maintain project documentation.

Responsibilities

• Analyze and design data models for DWH, Data Lake, and Lakehouse environments

• Analyze and model Data Pipeline and ETL processes

• Design data flows and integrations, including GCP/BigQuery-based solutions

• Create logical data models and Source-to-Target (STM) mappings

• Prepare requirements and specifications for development teams

• Analyze XML/XSD structures and map them into relational models

• Collaborate with business and IT teams (developers, testers, PM)

• Provide analytical support during design, implementation, and testing of data ingestion processes

• Prepare and maintain project and functional-technical documentation

Requirements

• Minimum 5–6 years of experience in data analysis, DWH systems, data integration, or ETL processes

• Very good SQL knowledge and relational database concepts

• Experience with data modeling for data warehouses, Data Lake, or Lakehouse

• Practical knowledge of Data Pipelines and data integration processes

• Experience creating Source-to-Target (STM) mappings

• Knowledge of GCP/BigQuery or other cloud solutions for data integration and processing

• Ability to analyze XML/XSD structures and translate them into relational models

• Experience defining requirements and specifications for technical teams

• Knowledge of Jira and Confluence

• English knowledge enabling work with technical documentation

• Independence, analytical thinking, good organization, and collaboration skills with business and IT

• Readiness to work in a hybrid model (1/4; one office day per week in Warsaw)

Benefits

• Job stability with long-term projects and opportunities to grow across IT domains

• Flexible employment forms (B2B, employment contract, or contract work)

• Benefits: Medicover (expanded with dentistry), FitProfit, English language lessons

• F45 gym training sessions at the office with professional trainers

• Internal referral program

• Possibility to get IT certificates funded

• Hybrid/remote/on-site options depending on the project

• Company events and integration trips

• Community support initiatives (e.g., Szlachetna Paczka) and #PomagamyNexio