11/01/2026 updated
100 % available
Data Analyst - Microsoft Fabric, OneLake & Power BI
Peniche, Portugal
Only remote
Bachelor's degree in Accounting - Anhembi Morumbi University (2017-2020)Data AnalysisData ArchitectureData IntegrationMicrosoft Data Access ComponentsMicrosoft Power BISQL DatabasesBusiness Intelligence Development StudioSQL Server Business IntelligenceSAP FioriMicrosoft FabricData Pipeline
Microsoft Fabric & OneLake
Expertise in Lakehouse architecture, OneLake, Delta tables, Dataflows Gen2, Data Pipelines, Notebooks, Capacity Metrics, and on-premises and VNet data gateways. Proven track record of restructuring Fabric capacity and resolving performance issues at production level.
Power BI Development
Proficiency in DAX, semantic modelling, Import and DirectQuery modes, row-level security, and dashboard design. Experience building procurement execution dashboards with hospital-level security in public-sector environments.
Data Engineering with PySpark & SQL
Strong command of PySpark, T-SQL, SQL views and materialisation, and Delta maintenance techniques such as OPTIMIZE and VACUUM. Experience orchestrating ingestion, maintenance and refresh workflows within unified Data Pipelines.
Database Management
Knowledge of SQL, Microsoft Access, and Oracle SQL Developer. Experience maintaining invoicing databases with queries, data corrections and updates.
Automation with Excel & VBA
Skills in Excel, VBA, and Outlook automation. Development of dynamic request forms with rule-based validations and one-click Outlook submission.
Business Systems - SAP Fiori
Familiarity with SAP Fiori as a business system used in operational and procurement contexts.
Procurement & Supply Chain
Background in managing full import and export processes, supplier quotes, customs and duties, clearance, and air and sea freight for corporate clients across international markets.
Invoicing & Accounting
Solid foundation in invoicing, accounting principles, and financial data management, providing contextual understanding of the data beyond technical analysis.
Expertise in Lakehouse architecture, OneLake, Delta tables, Dataflows Gen2, Data Pipelines, Notebooks, Capacity Metrics, and on-premises and VNet data gateways. Proven track record of restructuring Fabric capacity and resolving performance issues at production level.
Power BI Development
Proficiency in DAX, semantic modelling, Import and DirectQuery modes, row-level security, and dashboard design. Experience building procurement execution dashboards with hospital-level security in public-sector environments.
Data Engineering with PySpark & SQL
Strong command of PySpark, T-SQL, SQL views and materialisation, and Delta maintenance techniques such as OPTIMIZE and VACUUM. Experience orchestrating ingestion, maintenance and refresh workflows within unified Data Pipelines.
Database Management
Knowledge of SQL, Microsoft Access, and Oracle SQL Developer. Experience maintaining invoicing databases with queries, data corrections and updates.
Automation with Excel & VBA
Skills in Excel, VBA, and Outlook automation. Development of dynamic request forms with rule-based validations and one-click Outlook submission.
Business Systems - SAP Fiori
Familiarity with SAP Fiori as a business system used in operational and procurement contexts.
Procurement & Supply Chain
Background in managing full import and export processes, supplier quotes, customs and duties, clearance, and air and sea freight for corporate clients across international markets.
Invoicing & Accounting
Solid foundation in invoicing, accounting principles, and financial data management, providing contextual understanding of the data beyond technical analysis.
Languages
EnglishGoodPortugueseNative speakerSpanishGood
Project history
Diagnosed a Fabric capacity peaking at 365% utilisation using the Capacity Metrics app and traced it to five root causes. Restructured the OneLake Lakehouse by splitting ingestion by refresh frequency, materialising SQL views into Delta tables with PySpark, and adding Delta maintenance. Moved semantic models from DirectQuery to Import and orchestrated ingestion, maintenance and refresh in one Data Pipeline. Operated the on-premises data gateway, handled outage incidents end to end, and designed the VNet data gateway setup with IT. Built procurement execution dashboards in Power BI with DAX measures and row-level security per hospital. Built a dynamic Excel/VBA request form with rule-based validations and one-click Outlook submission.
Worked on the bank's invoicing data in a Microsoft Access database. Maintained the system with SQL: queries, data corrections and updates.
Sourced a wide range of goods internationally for corporate clients, from specialised industrial parts to everyday supplies. Managed the full import and export process: supplier quotes, customs and duties, clearance, and air and sea freight. Worked on the commercial side, pricing projects and managing margins.