Bi Data / Analytics Engineer | Porto, Portugal / Swindon, Uk | Ir 116

Emagine; Almada; Híbrido; EUR 40 000 - 60 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Híbrido (Porto/Swindon)

Formação profissional disponível

Banho de chá/coffee grátis

Programa Refer a Friend

Ambiente de escritório flexível e acol

Resumo da oferta

A Emagine está a recrutar para a área de Business Intelligence, integrada na equipa de IT. O(a) candidato(a) será o manter da data warehouse, assegurando dados limpos e disponíveis para análise externa, com foco em BigQuery e visualização em Power BI.

Reportando ao Commercial Finance Manager no UK, a função envolve ETL, modelação com dbt, orquestração com Dagster e desenvolvimento de dashboards para várias áreas da empresa, com possibilidade de formação adicional.

Qualificações

• Interpretação e escrita avançadas de SQL.
• Experiência com data warehouse, de preferência BigQuery.
• Experiência com Power BI ou similar para dashboards.
• Experiência com ferramenta ETL e pipelines ETL.
• Conhecimento de Python para script de ETL/transformação.
• Experiência com dbt ou ferramenta semelhante de modelação/transformação.
• Experiência com ferramenta de orquestração (Dagster/Airflow).
• Controle de versão com Git.

Responsabilidades

• Gerir o data warehouse em BigQuery, assegurando organização e qualidade dos dados.
• Extrair, transformar e carregar dados a partir de APIs e bases relacionais para BigQuery.
• Desenvolver modelos de transformação em dbt com testes e documentação.
• Orquestrar jobs de ETL/Dagster e solucionar falhas e drift de schema.
• Gerir soluções de visualização de dados no Power BI e atualizar guias de utilizadores.
• Comunicar com equipas de TI sobre requisitos técnicos e de sistema.

Conhecimentos

SQL

BigQuery

Power BI

ETL pipelines

Python

dbt

Dagster

Git

MySQL

Ferramentas

HubSpot

Sage HR

Descrição da oferta de emprego

Descrição do cargo

• Full-time- IT- Porto, Portugal / Swindon, UK

This position is open to candidates who are currently based in Portugal or the United Kingdom and who have the legal right to work in the relevant country. Due to the operational and legal requirements of the role, we are currently unable to consider applications from candidates residing outside Portugal or the United Kingdom.

As part of our IT team and a member of our Business Intelligence unit, you will play a pivotal role in developing the data maturity of our business and establishing a culture of data-driven commercial decision making across the organisation.

Reporting to the Commercial Finance Manager in the UK, you will build a holistic view of the context behind and commercial importance of our new and existing data solutions, and your role will focus on ensuring the underlying data is neatly stored, accurate, reliable, and readily available in the appropriate format for external analysis and reporting.

As the steward of our new data warehouse, you will also be the main source of knowledge for all data-related queries, and you will be responsible for troubleshooting any issues with our existing datasets.

There may also be opportunities to develop your skills through relevant training or professional certification where these align with your career ambitions and support business objectives.

From day 1, you will therefore be a highly-valued, core enabler of the continued growth of our business.

Your responsibilities in this role will include :

• Reporting to the Commercial Finance Manager and attending weekly meetings with the IT team and Business Intelligence unit, providing progress updates on your live projects and helping to shape the roadmap for future projects;
• Managing our data warehouse in BigQuery, ensuring data is stored methodically and any data challenges or inconsistencies are addressed promptly;
• Extracting, transforming, and loading data from our software stack, including pre-packaged software and bespoke in-house platforms, into BigQuery – both for our core business and any new businesses that we acquire;
• Writing and maintaining Python-based ETL connectors to extract data from APIs (e.G. HubSpot, Sage HR) and relational databases (e.G. MySQL) into BigQuery;
• Building and maintaining data transformation models in dbt, including testing and documentation, to ensure trusted, analytics-ready datasets;
• Orchestrating and monitoring ETL / transformation jobs using Dagster, including troubleshooting pipeline failures and schema drift;
• Using Git for version control and collaborating on changes to the ETL codebase and dbt project;
• Managing a portfolio of data visualisation solutions in Power BI, and continuously updating user guides to help stakeholders navigate these solutions effectively;
• Developing new data visualisation solutions in Power BI at the request of various departments, liaising with key stakeholders to understand their specifications and reacting to changing priorities in line with business needs;
• Proactively communicating with your IT colleagues to discuss any technical or system-related considerations underpinning your projects.

The candidate must meet the following essential criteria :

• Advanced proficiency in interpreting and writing SQL;
• Prior experienceof working with a data warehouse, ideally BigQuery;
• Prior experienceof working with Power BI or an equivalent data visualisation platform (e.G. Tableau) for developing new dashboards;
• Prior experiencewith an ETL tool and managing ETL pipelines;
• Proficiency in Python for building and maintaining data extraction and transformation scripts;
• Prior experiencewith dbt or a similar data modelling – transformation tool;
• Prior experiencewith a workflow orchestration tool (e.G. Dagster, Airflow);
• Proficiency withGit or another version control system.

It would also be desirable for the candidate to meet some or all of the following :

• Prior experience in managing a portfolio of data products / solutions;
• Prior experienceof working with financial data;
• Prior experienceof working in a multi-geography organisation with cross-border colleagues;
• Prior experienceworking with cloud platforms (e.G. GCP), including secret / credential management;
• Prior experiencewith Linux and bash scripting for managing data infrastructure.

Personal attributes / characteristics :

The ideal candidate for this role must demonstrate the following :

• Advanced proficiency in English reading and writing;
• Strong organisation skills, and able to manage and progress multiple live projects at once;
• Flexible and agile, and able to seamlessly re-balance priorities in line with business needs;
• Confident, proactive and vocal in challenging data integrity / assumptions;
• Strong level of initiative in creating inventive, time-saving solutions that will achieve the same desired output;
• Good level of commercial acumen and business literacy, or a keen desire to build on this knowledge.

Flexible thinking – Level 3

• Paid leave on the afternoons of Christmas Eve and New Year’s Eve.- Discretionary annual bonus based on company and individual performance.- 24 / 7 Employee Assistance Programme.- Refer a Friend Programme.- Hybrid working, subject to local arrangements and business needs.- Full training.- Free tea and coffee and option to bring dogs to work.- Great team spirit in the office and comfortable office environment- Multi-cultural team and colleagues based globally.- One additional day of annual leave after three years of service and a further additional day after ten years of service.- Birthday off, if it falls on a working day

United Kingdom

• 25 days’ annual leave plus public holidays and service-related additional days.- Pension : UK Employee 4% and Employer 5%. The employer contribution increases with a step change % of 1% increase every 3 years to a max of 10%.- Maternity / Adoption Leave : 16 weeks company maternity leave / pay- Vision Testing : Eye care voucher for eye testing UK.- Parking- Electric Car Scheme : UK Salary Sacrifice (after 1 year of service)

Portugal

• 23 days’ annual leave plus public holidays, increasing to a maximum of 25 days with service.- Company-paid health insurance for permanent employees.- Reduced-rate health insurance option for temporary employees.- Coverflex benefits allowance and discounts.- Location : Central city location (Porto) near public transportation.

J-18808-Ljbffr