System Analyst – Data Warehouse & GCP

About the Position

System Analyst – Data Warehouse & GCP

System Analyst with strong SQL, data modelling and data integration experience for a long-term data warehouse project at one of Poland’s largest banks. Hybrid work in Warsaw, 12+ months, B2B.

About the Client & Cooperation Model

Our Client is a prominent, innovation-driven financial institution and one of the largest banks in Poland. The Bank is continuously developing its technology landscape, modernising its data platforms and building scalable solutions that support critical banking processes.

Please note that Optiveum is acting as the recruitment partner for this role. You will sign a long-term B2B contract directly with a reputable IT outsourcing company and dedicate your expertise full-time to the Bank’s technological transformation.

About the Role

We are looking for a Middle or Senior System Analyst to join an IT team responsible for data warehouse solutions, data integration processes and data pipelines.

The role combines system analysis, logical data modelling and close cooperation with developers, testers, project managers, business teams and other units within the Bank.

You will analyse data sources, design data flows and ETL processes, prepare Source-to-Target Mapping documentation and support the implementation and testing of data ingestion processes. The project also involves data integration within Google Cloud Platform.

Key Project Information

• Location: Hybrid – one day per week in the Warsaw office
• Contract type: Long-term B2B contract
• Project duration: More than 12 months
• Planned start date: 1 September 2026
• Rate: 130–160 PLN net per hour
• Engagement: Full-time

Responsibilities

• Analyse and model data used in data pipelines within data warehouse and data lakehouse environments.
• Analyse and model ETL and data integration processes.
• Analyse and design data integration processes within Google Cloud Platform.
• Cooperate with other units within the Bank to define requirements and specifications for new data sources.
• Design logical data models for an operational data warehouse.
• Prepare Source-to-Target Matrices and detailed data mappings for development teams.
• Translate business and system requirements into clear development tasks, including descriptive specifications and STM documentation.
• Create and maintain functional, system, technical and project documentation.
• Ensure traceability between requirements, data mappings and unit tests.
• Analyse XML and XSD structures and create relational data models based on XSD schemas.
• Support the design, development and testing of data ingestion and integration processes.
• Work closely with developers, testers, project managers, business representatives and other IT teams.
• Provide analytical support throughout the design, implementation and testing stages.

Requirements

• At least five years of professional experience as an IT System Analyst, including practical experience with data integration processes and data pipelines.
• Very good knowledge of SQL.
• Strong understanding of relational databases and relational data modelling.
• Experience in designing data warehouse models or working with Google BigQuery.
• Practical experience with ETL processes, data integration and data mapping.
• Experience in preparing Source-to-Target Matrices or similar data mapping documentation.
• Ability to translate requirements and data mappings into specifications for developers.
• Experience in documenting business and system requirements.
• Experience in creating functional and/or technical specifications.
• Experience in maintaining comprehensive project documentation.
• Experience in working directly with internal or external clients to define business and system requirements.
• Ability to analyse XML and XSD structures and build relational data models based on XSD schemas.
• Experience with Jira and Confluence.
• At least a basic understanding of banking products and processes.
• English sufficient for working with technical documentation.
• Strong communication skills and the ability to work effectively with both business and IT stakeholders.
• Analytical thinking and the ability to quickly understand complex data structures and business processes.
• Independence, accountability and a proactive approach to problem-solving.
• Strong organisational skills and the ability to deliver work reliably and on time.

Nice to Have

• Practical knowledge of Google Cloud Platform services related to data processing and integration, particularly:
  • BigQuery
  • Dataflow
  • Cloud SQL
  • PostgreSQL
• Experience with data lakehouse architectures.
• Experience with Enterprise Architect, Visio or similar modelling tools.
• Previous experience in banking or financial services projects.
• Understanding of data exchange through services, files and message queues.

We Offer

• Competitive salary ranging from 130–160 PLN net per hour.
• Long-term B2B contract with a reputable IT outsourcing company.
• Hybrid work model with one day per week in the Warsaw office.
• Opportunity to work on a significant data warehouse project at one of Poland’s largest banks.
• Collaborative environment with close cooperation with various IT and business teams.

About the Company

Optiveum is a recruitment and consulting company created based on our 20-plus years of experience in HR & IT services.

We work for Clients located in Poland and abroad providing our local and international Candidates with Project-based or Permanent job opportunities in a remote or office-based model.

COMPANY DATA

Optiveum Sp. z o.o.

ul. Tomasza Zana 43 lok. 2.1 20-601 Lublin, Poland

nr KRS: 0000834436, NIP 7010975729

Contact us at: info (at) optiveum.com

Founded in 2020

Applicant tracking system by Teamtailor