09/17/2026 updated
100 % available
Senior Data Analyst / Analytics Engineer
Braga, Portugal
Only remote
MSc Information Management - Business Intelligence, NOVA IMS, Lisbon, PortugalAbout me
I'm a Senior Data Analyst and Data Engineer, I build business intelligence solutions on the Microsoft and Databricks stack. I specialized in Power BI, Microsoft Fabric and Databricks holding certifications for all 3. I have 10+ years of hands-on delivery across Brazil, China, and Portugal.
Application Programming Interfaces (APIs)Data AnalysisBusiness IntelligenceBusiness Intelligence DevelopmentSoftware as a ServiceData GovernanceData TransformationDatabase AnalysisDatabase QueriesData IntelligenceMicrosoft Business IntelligenceOracle Business Intelligence Enterprise EditionMicrosoft Power BISQL DatabasesBusiness Intelligence Development Studio
Power BI & Business Intelligence
Expertise in end-to-end Power BI development including DAX, Power Query, Semantic Models, RLS and Data Modeling. Delivery of BI solutions for international clients across pharmaceuticals, media, finance and manufacturing sectors.
Microsoft Fabric & Data Engineering
Hands-on experience with Microsoft Fabric components including Lakehouse, Warehouse, OLS, DDM, Deployment Pipelines, Data Pipelines and Data Governance. Proficiency in SQL, Python, PySpark, Spark SQL, KQL, ETL and ELT processes.
Automation & Integration
Strong background in automation using Power Automate, VBA, REST APIs and Advanced Excel. Track record of automating data pipelines, reporting processes and database ingestion workflows to eliminate manual steps.
Databricks AI/BI
Certified Databricks Data Analyst with practical experience using Databricks AI/BI as part of the broader Microsoft and Databricks stack for analytics solutions.
Data Modeling & Semantic Models
Deep knowledge of data modeling principles, semantic model design and implementation of Row-Level Security (RLS) for enterprise-grade reporting solutions.
Python & PySpark
Applied use of Python and PySpark for data engineering tasks, including building monitoring reports and automating data processing workflows within Microsoft Fabric environments.
Power Apps Development
Development of Power Apps mobile applications, including factory-floor QC inspection tools that replaced paper-based processes and integrated with automated reporting via Power Query.
Advanced Excel & VBA
Advanced proficiency in Microsoft Excel and VBA for building production tracking tools, automating sales data processes and creating reporting templates adopted across business areas.
SaaS Product Development
Design and end-to-end development of a financial management SaaS product (Fluxo) for Brazilian companies, covering OFX/Excel ingestion, AI-based transaction categorisation, dashboards and multi-company data isolation.
Expertise in end-to-end Power BI development including DAX, Power Query, Semantic Models, RLS and Data Modeling. Delivery of BI solutions for international clients across pharmaceuticals, media, finance and manufacturing sectors.
Microsoft Fabric & Data Engineering
Hands-on experience with Microsoft Fabric components including Lakehouse, Warehouse, OLS, DDM, Deployment Pipelines, Data Pipelines and Data Governance. Proficiency in SQL, Python, PySpark, Spark SQL, KQL, ETL and ELT processes.
Automation & Integration
Strong background in automation using Power Automate, VBA, REST APIs and Advanced Excel. Track record of automating data pipelines, reporting processes and database ingestion workflows to eliminate manual steps.
Databricks AI/BI
Certified Databricks Data Analyst with practical experience using Databricks AI/BI as part of the broader Microsoft and Databricks stack for analytics solutions.
Data Modeling & Semantic Models
Deep knowledge of data modeling principles, semantic model design and implementation of Row-Level Security (RLS) for enterprise-grade reporting solutions.
Python & PySpark
Applied use of Python and PySpark for data engineering tasks, including building monitoring reports and automating data processing workflows within Microsoft Fabric environments.
Power Apps Development
Development of Power Apps mobile applications, including factory-floor QC inspection tools that replaced paper-based processes and integrated with automated reporting via Power Query.
Advanced Excel & VBA
Advanced proficiency in Microsoft Excel and VBA for building production tracking tools, automating sales data processes and creating reporting templates adopted across business areas.
SaaS Product Development
Design and end-to-end development of a financial management SaaS product (Fluxo) for Brazilian companies, covering OFX/Excel ingestion, AI-based transaction categorisation, dashboards and multi-company data isolation.
Languages
EnglishFluentPortugueseNative speakerSpanishBasic knowledge
Project history
SaaS that takes financial management out of spreadsheets for Brazilian companies. Ingests OFX bank statements or Excel files, detects transfers between accounts, removes duplicates and categorises transactions using AI combined with user-defined rules. Feeds a dashboard with revenue, expense and result KPIs, category analysis, a simplified P&L (DRE), hierarchical chart of accounts, monthly budget control and CSV/Excel/PDF export. Designed and built end to end.
Responsible for end-to-end delivery of BI and analytics solutions on the Microsoft stack. Delivered Power BI and Microsoft Fabric solutions for clients including Galp, Bauer Media Group, Ferring Pharmaceuticals, ABANCA, NOS, CIN, Sonae Sierra and Amorim Luxury. Acted as informal tech lead and main client contact across projects. Built a tenant-wide Fabric monitoring report using PySpark and Power BI. Built internal tooling including C# scripts for Tabular Editor and custom RLS. Mentored junior analysts on Tabular Editor scripting, TMDL, data modeling and GitHub integration.
Self-founded educational platform dedicated to Microsoft Excel with tutorials, articles and tools, continued at rodrigoavf.dev covering Power BI, Microsoft Fabric and the wider data stack. 140+ published articles, 100K+ monthly pageviews, 18K+ YouTube subscribers.