Description
Requirements
Assignment context
Hybrid data-analysis and data-engineering role bridging business requirements, data modelling, reporting and ETL delivery.
Key responsibilities
• Translate business needs into clear data models and technical specifications.
• Design and maintain star and snowflake data models for analytics and reporting.
• Develop high-performance dashboards and reports and maintain data definitions, lineage and dictionaries. • Design, build, test and optimise ETL/ELT pipelines and automated data-quality controls.
• Own delivery from requirements gathering through implementation and stakeholder adoption.
Mandatory requirements
• Advanced SQL, including complex queries, joins, optimisation and stored procedures.
• Relational databases, data warehousing and Kimball modelling principles.
• Experience with Stambia, or strong experience with an equivalent ETL technology such as Talend, Informatica, SSIS, Azure Data Factory or dbt.
• French at minimum B2 for professional stakeholder interaction.
• Fluent written and spoken English.
• Strong communication, analytical thinking, autonomy and ownership.
Preferred / differentiating requirements
• Power BI, including DAX and Power Query / M.
• Banking, finance or insurance data experience.
• Azure, AWS or GCP.
• Python or Unix/Linux scripting.
Experience
3+ years in a comparable dual data-analysis and engineering role
Benefits
Fornecimento de equipamento informático para prestação do serviço
Seguro saúde ao consultor
Formação de idiomas: curso de inglês (ou outro idioma de interesse do projeto)
Suporte jurídico: custos dos *serviços advocatícios* necessários para o processo migratório
PLR – Prêmio anual de atingimento de metas (empresa e contrato)
Suporte contábil: apoio no pagamento de serviço de contabilista
Fatura "fechada". Receber 21 dias sempre, independente de feriados