Power BI Developer

act digital; Porto; Sur place; EUR 60 000 - 90 000; Plein temps

Résumé du poste

act digital in Porto seeks an experienced Senior Data Engineer / BI Developer to lead enterprise Power BI dashboards and data models. You design, implement and optimize reporting solutions, ensuring data quality and performance.

The role requires 9+ years in BI/Analytics, deep Microsoft BI experience, advanced SQL and DAX, and mentoring abilities. You will work on data extraction, modeling and governance, delivering actionable insights.

Qualifications

• 9+ years in BI, Data Engineering or Analytics.
• Strong Microsoft BI Stack experience, especially Power BI.
• Advanced SQL with complex queries and tuning.
• Expertise in DAX calculations and time intelligence.
• Experience with Power BI Gateway and RLS.
• Proven ability to mentor teammates and lead peers.

Responsabilités

• Design, develop and maintain enterprise-level Power BI dashboards, reports and data models.
• Translate business requirements into effective data visualization and reporting solutions.
• Develop and optimize complex SQL queries, including joins and aggregations.
• Design dynamic SQL for historical data extraction with date parameters.
• Integrate customized SQL queries into Power BI to optimize data retrieval.
• Develop, maintain and optimize advanced DAX calculations.
• Troubleshoot and improve Power BI performance and refresh times.
• Manage Power BI Service configurations, gateways, RLS and workspaces.
• Ensure data quality and consistency across reporting solutions.
• Provide technical guidance and mentor junior/mid-level developers.
• Promote BI development best practices and performance optimization.

Connaissances

Power BI expertise

Advanced SQL

DAX calculations

Mentoring

Communication skills

Analytical thinking

Outils

Power BI Desktop

Power BI Service

Power BI Gateway

SQL

Description du poste

We are looking for an experienced Senior Data Engineer / BI Developer with strong expertise in Power BI, advanced SQL and DAX to join a challenging data and business intelligence project.

We are looking for a highly experienced professional with a strong background in the Microsoft BI ecosystem, capable of designing complex data models, developing enterprise-level dashboards and optimizing data extraction and reporting processes.

Responsibilities

• Design, develop and maintain enterprise-level Power BI dashboards, reports and data models.
• Translate business requirements into effective data visualization and reporting solutions.
• Develop, write and optimize complex SQL queries, including subqueries, CTEs, JOINs, UNIONs and advanced aggregations.
• Design dynamic SQL queries for historical data extraction, using date parameters and time-series logic.
• Integrate customized SQL queries and dynamic parameters directly into Power BI to optimize data retrieval and performance.
• Develop, maintain and optimize advanced DAX calculations, including time intelligence, filter context manipulation and complex measures.
• Troubleshoot and improve Power BI report performance, dashboard refresh times and underlying SQL queries.
• Manage Power BI Service configurations, gateways, Row-Level Security (RLS) and workspaces.
• Ensure data quality, accuracy and consistency across reporting solutions.
• Provide technical guidance, conduct code reviews and mentor junior and mid-level team members.
• Promote best practices in BI development, data modelling and performance optimization.

Mandatory Requirements

• More than 9 years of professional experience in Business Intelligence, Data Engineering or Data Analytics.
• Strong experience with the Microsoft BI Stack, particularly Power BI.
• Advanced SQL expertise, with proven experience writing, debugging and optimizing complex queries.
• Strong knowledge of subqueries, CTEs, JOINs, UNIONs and aggregation functions.
• Hands-on experience with dynamic SQL queries and historical data extraction using date parameters.
• Advanced DAX skills, including complex calculations, time intelligence and filter context manipulation.
• Strong knowledge of Power BI Desktop and Power BI Service.
• Experience with Power BI Gateway configurations, Row-Level Security (RLS) and workspace administration.
• Proven experience in performance tuning and optimization of BI solutions.
• Strong analytical, problem-solving and critical-thinking skills.
• Excellent communication skills and ability to translate complex data structures into clear business insights.
• Technical leadership skills, including mentoring and supporting other developers.