Senior Business Intelligence Engineer

TP; Lisboa; In loco; EUR 70.000 - 95.000; Tempo pieno

Descrizione del lavoro

TP Portugal is seeking a Senior BI engineer to own the governed semantic layer for our large, diverse workforce. You will define metrics, datasets, and canonical terms in Unity Catalog, and lead migration of Power BI models to Databricks-native equivalents.

You will partner with our HR data architects and engineers, establish development standards, and drive self-service analytics through training, while upholding data governance, lineage and secure access across the organization.

Competenze

• 5+ years in BI/analytics engineering or related data role.
• Databricks Unity Catalog, Delta Lake, SQL Warehouses, Dashboards, Apps and Genie or similar tooling.
• Strong SQL and Python for data prep and automation.
• Data governance, lineage, access control and certified datasets.

Mansioni

• Design and maintain governed semantic models and certified datasets in Databricks Unity Catalog.

Conoscenze

SQL

Python

Dimensional modelling

Data governance

English communications

BI engineering

Stakeholder alignment

Strumenti

Databricks

Unity Catalog

Delta Lake

Power BI

Descrizione del lavoro

Every number that decides something about 14,000 people should mean the same thing to everyone who reads it. Making that true is the job.

At TP Portugal, HR already runs on data — hiring, retention, workforce planning, pay. What it needs now is one governed semantic layer underneath all of it. We’re rebuilding that layer on Databricks, migrating our Power BI models and reports domain by domain, and giving business users a way to explore people data on their own, without waiting for someone to build them a report first.

This isn’t a reporting role. You own the definitions — what “attrition” means, what counts as a hire, which dataset is certified — for one of the largest and most diverse workforces in Europe: 14,000 people, dozens of nationalities. You’ll work alongside our HR data scientists: they build the models, you build the trusted ground those models stand on.

What you’ll actually do

• Design and maintain the governed semantic models — metric views, relationships, certified datasets — in Databricks Unity Catalog that HR and the business treat as the single source of truth;
• Lead the migration of our Power BI semantic models, datasets and reports to Databricks-native equivalents, domain by domain — keeping what already works and redesigning what doesn’t;
• Build Databricks Dashboards and Apps people actually use to decide, not reports that get exported to Excel and forgotten;
• Configure Genie rooms and the business ontology — terms, synonyms, verified answers — so an HR leader can ask a question in plain language and trust the answer that comes back;
• Partner with the Data Architect and the Data Engineering Manager to keep modelling standards and Unity Catalog governance aligned with enterprise architecture;
• Define the BI development standards, reusable components and performance practices the whole function builds on;
• Drive adoption through training and enablement, and use real usage data to keep improving the self-service experience.

What you bring

• 5+ years in business intelligence engineering, analytics engineering or a related data role;
• Databricks experience across Unity Catalog, Delta Lake, SQL Warehouses, Dashboards, Apps and Genie, or comparable BI and ontology tooling;
• Strong SQL, plus working Python for data preparation, transformation and automation;
• Solid dimensional modelling, metric definition and semantic layer design;
• Data governance and cataloguing fluency — ownership, certification, lineage, access control — with the extra care that people data demands;
• Excellent communication and a consulting mindset: you can make semantic modelling make sense to a business audience, because this role sits next to the people who decide, not behind them;
• Professional fluency in English.

Bonus points if you have experience with:

• Migrating BI solutions to Databricks or another lakehouse platform;
• Microsoft Fabric, Azure Synapse or similar cloud analytics platforms;
• CI/CD, version control and DevOps practices applied to BI;
• Databricks or Power BI certifications;
• AI-assisted development tools to speed up delivery and widen self-service.

If you’d rather own the definitions everyone depends on than build one more dashboard nobody opens — this is that role.