French-Speaking ETL Data Analyst: Data Modeling & BI

Bpce Si; Viseu; Híbrido; EUR 36 000 - 60 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Hybrid Work Policy

Resumo da oferta

Bpce Si in Portugal seeks a data-focused professional to collaborate with business stakeholders, translating needs into data models and technical specifications for the Data Engineering team.

You will design robust data models (star/snowflake) optimized for analysis and reporting, and design, build, test, and optimize ETL/ELT pipelines into the data warehouse using Stambia or other tools.

Qualificações

• 3+ years in data analytics/ETL with focus on analysis and ETL development.
• Advanced SQL and data warehouse concepts (Kimball).
• Experience with Power BI dashboards and DAX.

Responsabilidades

• Collaborate with stakeholders to translate needs into data models and specifications.
• Design, structure, and maintain data models (star/snowflake) for analysis and reporting.
• Ensure data quality, documentation of data definitions and data lineage.
• Design, build, and optimize ETL/ELT pipelines into the data warehouse.
• Develop ETL processes using Stambia; adapt with other tools if needed.
• Implement automated data quality checks.

Conhecimentos

Advanced SQL

Power BI

Data modeling

ETL development

Stambia

Python

Unix scripting

French & English

Banking domain knowledge

Formação académica

Bachelor's/Master's in CS/DS/Statistics/Finance

Ferramentas

Stambia

Talend

Informatica

SSIS

dbt

Descrição da oferta de emprego

Bpce Si in Portugal seeks a data-focused professional to collaborate with business stakeholders, translating needs into data models and technical specifications for the Data Engineering team.

You will design robust data models (star/snowflake) optimized for analysis and reporting, and design, build, test, and optimize ETL/ELT pipelines into the data warehouse using Stambia or other tools.