Data Engineer (Senior and Middle Level)

Overview

Expleo is a trusted partner for your innovation journey. As a global engineering, technology and consulting service provider, we are ideally positioned to help you achieve your ambitions and future-proof your business. With a smart blend of bold thinking and reliable execution, we’re able to fast-track innovation through each step of your value chain.

We are strategically positioned to build value, with global footprint across 30 countries.We are as global and local as you need us to be, with strong best-in-class pan-European technological centres and unique best-shoring capabilities.

We leverage a network of high value-adding affiliates in consulting and industrial excellence, and leading partners across multiple sectors to provide you with the most comprehensive services and solutions in an ever-changing environment.

Responsibilities

- Definir/evoluir a arquitetura do Data Warehouse- Definir camadas e padrões de integração- Definir framework de ETL- Implementar pipelines ETL/ELT- Garantir performance e qualidade dos dados- Definir modelo dimensional- Preparar a solução para futura migração/evolução para Microsoft Fabric- Rever entregáveis técnicos- Orientar elementos mais juniores- Participar em decisões de arquitetura com cliente e stakeholders

Essential skills

- 6–8+ anos de experiência em Data Engineering- Forte experiência em SQL Server on-premises- T-SQL avançado- Experiência sólida com SQL Server Integration Services (SSIS)- Python aplicado a Data Engineering- Experiência em Data Warehousing

- Experiência com Power BI e/ou Microsoft Fabric

- ETL/ELT

Desired skills

- Modelação dimensional- Kimball- Star Schema- Fact tables- Conformed dimensions- Integração de múltiplos sistemas fonte- Experiência em desenho de arquiteturas de dados end-to-end- Definição de camadas e padrões de integração- Experiência em projetos de consolidação multi-source / multi-ERP- Experiência em liderança técnica