ETL System Analyst

Quick Facts

Role: ETL System Analyst (Middle/Senior)
Focus: Data pipelines, data warehouse/data lakehouse, and GCP-based data integration
Collaboration: IT (developers, PM, testers) and business units
Engagement: B2B

Description

Work on data warehouse and data lakehouse solutions by analyzing and designing data pipelines and ETL integration processes. Model data and integration workflows, including implementations on GCP, and help define specifications for new data sources. Support the full lifecycle—design, development, and testing of data loading processes—so results are delivered via services, files, and message queues.

Responsibilities

• Analyze and model data models for data pipelines in data warehouses and data lakehouse environments.
• Analyze and model ETL integration processes for data.
• Analyze and model data integration processes in GCP.
• Collaborate with bank units to define requirements specifications for new data sources.
• Design the logical data model for the operational area of the data warehouse.
• Create STM (Source-Target-Matrix) to support developer process building.
• Work with the IT team (developers, PM, testers) and the business.
• Provide analytical support during design, implementation, and testing of data feeding processes.

Requirements

• At least 5 years of experience as an IT System Analyst in data integration processes (data pipelines).
• Experience documenting business-to-system requirements.
• Very good SQL knowledge.
• Knowledge and understanding of relational database principles.
• Experience designing data warehouse models and/or working with GCP BigQuery.
• Experience creating requirement matrices that translate into unit tests.
• Ability to specify tasks for developers, including descriptive documentation and STM-style matrices.
• Experience maintaining project documentation.
• Experience working directly with clients when defining business-to-system requirements.
• Experience preparing functional and/or technical specifications.
• Skills in analyzing XML/XSD and building a relational model based on XSD.
• Knowledge of Confluence and Jira.
• Preferred: GCP cloud tools for data integration (BigQuery, Dataflow, Cloud SQL/Postgres).
• Preferred: Enterprise Architecture and Visio.
• Basic knowledge of banking product concepts.
• Ability to communicate effectively in both business and IT environments.
• Good time management and strong autonomy, commitment, and responsibility.
• English knowledge at least at the level of technical documentation.
• Analytical thinking, fast learning, and creativity in problem-solving.
• Timeliness and reliability in delivering projects.

Benefits

• B2B cooperation.