Power BI Consultant

SCI - Serviclients Informatica
10 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
€ 47K

Job location

Remote

Tech stack

Business Logic
Data Governance
Data Integration
ETL
Relational Databases
Online Analytical Processing
Performance Tuning
Power BI
SQL Databases
Enterprise Data Management
Powerquery
Microsoft Fabric

Job description

  • Design, model and maintain data models in Power BI, applying best practices for structuring, relationships, normalization and performance optimization.
  • Develop advanced DAX measures and calculations to build reusable and scalable metrics, KPIs, and business logic.
  • Create and manage Power Query, Dataflows, and ingestion pipelines to transform and prepare data from multiple sources.
  • Implement efficient ETL processes and SQL queries, ensuring data quality, consistency, and governance.
  • Use Microsoft Fabric to orchestrate, transform, model, and serve data within the organization's analytics ecosystem.
  • Optimize the performance of reports and datasets by applying techniques such as DirectQuery, composite models, incremental refreshes, and partitioning.
  • Integrate data from OLAP Cubes and relational databases, ensuring stable connections and structures compatible with Power BI models.
  • Apply data governance, security, RLS/OLS and workspace management policies in Power BI Service.
  • Prepare functional and technical documentation, as well as guides to good practices, standards and procedures for use.
  • Collaborate with business teams, analysts, and technical departments to understand needs, translate them into analytical solutions, and ensure the consistency of the corporate data model.
  • Participate in the continuous improvement of BI architecture and the evolution of advanced capabilities in Power BI and Microsoft Fabric.

Requirements

Do you have experience in SQL?, Do you have a Bachelor's degree?, * 2-3 years experience in Power BI (data modeling, DAX, Power Query, Dataflows).

  • Experience in SQL and ETL processes.
  • Experience with Microsoft Fabric.
  • Experience in performance optimization (DirectQuery, incremental refreshes, scalable models).
  • Familiarity with data integration from OLAP Cubes and relational databases.
  • Knowledge of data governance and security in Power BI
  • Documentation skills and generation of good practices.
  • PL-300 (Power BI) and Fabric (DP-600) certifications are a plus.
  • University degree or similar

Valuable Aspects

  • Certifications: PL-300 (Power BI) and Fabric (DP-600).

Apply for this position