Senior Data Warehouse (Databricks)

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

Resumo da oferta

act digital in Lisbon is looking for a skilled data professional to design and develop data models, ETL pipelines, and ensure data integration processes. Candidates should have at least 5 years of experience in data warehousing and strong knowledge in SQL Server, Databricks, and Power BI.

This role involves implementing data quality checks and optimizing processes in a collaborative IT environment. Fluency in both English and Portuguese is required, and Spanish is a plus.

Qualificações

• Minimum 5 years of professional experience in an enterprise environment or 7 years in any industry sector.
• Strong expertise in SQL Server and performance optimization.
• Proficiency in developing and tuning Power BI dashboards.

Responsabilidades

• Design and develop data models and ETL pipelines.
• Ensure data warehouse process precision and efficiency.
• Implement data quality checks and governance standards.
• Define and implement best practices for data handling.

Conhecimentos

Data warehousing

Public Cloud

CI/CD pipelines

Git

DevOps practices

Databricks

ETL processes

SQL Server

Fabric

PostgreSQL

Power BI dashboards

Fluency in English

Fluency in Portuguese

Spanish language knowledge

Formação académica

Secondary school qualification (A-Levels or equivalent)

Descrição da oferta de emprego

What You’ll Be Doing As part of our collaborative IT team, you will:

• Designing and developing data models, ETL pipelines and data integration processes by integrating data from various sources (databases, APIs, streaming platforms, etc.)
• Ensuring every DWH process precision, efficiency and scalability through monitoring, tuning and optimizing the platform.
• Help expanding data models of our Data Warehouse and our Data Marts by designing robust structures, tables, and objects.
• Implement data quality checks, monitoring, and governance standards.
• Design and build impactful Power BI reports and dashboards (Operational, Strategic & Analytical).
• Define and implement best practices, guidelines, and repeatable processes to drive efficiency and quality.
• Deliver insights that help the business monitor KPIs and make informed, data-driven decisions.

What We’re Looking For (Hard Skills)

• Solid understanding of data warehousing, data lakes, and Modern DWH architecture.
• Public Cloud experience (great understanding of Compute, Storage, Networking, Identity, etc).
• Experience with CI/CD pipelines, Git, and DevOps practices.
• Professional experience of configuring and running Databricks on any public cloud (Azure is preferred).
• Strong experience with ETL processes dealing with big amounts of data.
• Strong expertise with SQL Server and performance optimization.
• Good knowledge and experience with Fabric and PostgreSQL are strong differentiation points.
• Proficiency in developing and tuning Power BI dashboards.
• Minimum 5 years of professional experience in an Enterprise environment OR 7 years in any industry sector.
• At least a secondary school qualification (A-Levels or equivalent).
• Fluency in English and Portuguese. Spanish language knowledge is a big plus.

What Will Make You Stand Out (Soft Skills)

• Excellent communication and interpersonal skills, with the ability to collaborate across functions and companies. 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.

Why Join Us?

• Be part of a forward-thinking company where data truly drives decisions.
• Work in a collaborative, supportive, and innovative environment.
• Take on a role with genuine impact, variety, and opportunities for growth.
• Enjoy being based in Lisbon, one of Europe’s most vibrant tech hubs.