Workplace: Lisbon (Hybrid)
Responsibilities:
Develop and implement advanced T‑SQL procedures and functions, ensuring efficiency and scalability; Use Databricks PySpark & SparkSQL to integrate data efficiently into Data Warehouse; Design and build Power BI reports and dashboards (Operational, Strategic, and Analytical) using DAX, Power Query, and advanced data modeling; Define and implement best practices, guidelines, and repeatable processes to promote efficiency and quality; Deliver insights that support the business in monitoring KPIs and making informed, data‑driven decisions; Create complex DAX calculations and measures to support data analysis; Ensure data security and compliance with best practices; Diagnose and resolve issues in Power BI reports; Ensure the reliability and performance of developed reports and dashboards for both internal and external users.<...