Senior ETL Developer

act digital; Lisboa; Presencial; EUR 40 000 - 60 000; Tempo integral

Resumo da oferta

act digital in Lisboa is looking for a skilled SQL Developer to create and implement advanced T-SQL procedures and manage ETL processes. You will design robust database structures and develop impactful Power BI reports to drive data-driven decision-making.

Applicants should have at least 3 years of experience in an Enterprise environment or 5 years in any industry sector. Strong skills in T-SQL, SQL, and proficiency in English and Portuguese are required. Join us to contribute to impactful projects!

Qualificações

• Minimum 3 years of professional experience in an Enterprise environment OR 5 years in any industry sector.
• Fluency in English and Portuguese.

Responsabilidades

• Develop and implement advanced T-SQL procedures and functions, ensuring efficiency and scalability.
• Write optimised SQL queries to integrate with other applications.
• Design robust database structures and tables.

Conhecimentos

T-SQL

ETL processes

Power BI

SQL

DAX

Python

C#

Formação académica

A-Levels or equivalent

Ferramentas

Excel

Descrição da oferta de emprego

What You’ll Be Doing

• Develop and implement advanced T‑SQL procedures and functions, ensuring efficiency and scalability.
• Write optimised SQL queries to integrate with other applications and manage end‑to‑end ETL processes.
• Design robust database structures, tables, and objects.
• Define and implement best practices, guidelines, and repeatable processes to drive efficiency and quality.
• Design and build impactful Power BI reports and dashboards (Operational, Strategic & Analytical) using DAX, Power Query, and advanced data modelling.
• Deliver insights that help the business monitor KPIs and make informed, data‑driven decisions.
• Ensure the reliability and performance of developed reports and dashboards for both internal and external users.
• Work with Excel, Power BI, and PivotTables to extract, transform, and analyse data effectively.
• Strong expertise in T‑SQL (advanced level) and performance optimisation.
• Solid experience with ETL processes.
• Proficiency in developing and tuning Power BI dashboards, datasets, DAX, and SQL for optimal performance.
• Basic knowledge of Python and C#.
• Minimum 3 years of professional experience in an Enterprise environment OR 5 years in any industry sector.
• At least a secondary school qualification (A‑Levels or equivalent).
• Fluency in English and Portuguese.

What Will Make You Stand Out (Soft Skills)

• Self‑motivated, proactive, and autonomous.
• Strong analytical and critical thinking abilities.
• A commitment to quality and testing excellence.
• A team player, focused on achieving results.
• Excellent communication and interpersonal skills, with the ability to collaborate across functions.