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
€ 47KJob 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).