Freelancer profile translated to English.
Back to original languageAbout Sergio
I turn scattered data into reliable architectures, and those architectures into models on which AI can answer business questions.
Business Intelligence Analyst specializing in theMicrosoft ecosystem: Power BI, Microsoft Fabric, DAX, SQL, and Python.I lead the BI function for a coworking operator with 15 centers in Spain, Andorra, and Portugal, from Finance and serving Operations, Sales, and Marketing.
What I do
- Data Architecture:Medallion architecture (Bronze/Silver/Gold) in Microsoft Fabric with Lakehouses, PySpark notebooks, pipeline orchestration, and Git/GitHub versioning.
- Ingestion and Automation:Connection to REST APIs, ERPs, and CRMs.
- Semantic Model:Star schema, DAX, DirectLake, and KPI dictionary so everyone speaks the same numbers.
- Data Ready for AI:Curated and documented semantic models to ask questions in natural language, without waiting for someone to build a report.
- Data Applications:Interfaces with Fabric Apps on top of the model, to explore data outside the traditional report.
- Visualization:Reports aligned with your brand, with custom visuals in Deneb (Vega-Lite) when native ones aren't enough.
- Business Analysis:Profitability, EBITDA, occupancy, and sales funnel.
How I work
I start with the business question, not the tool:what decision will change with that data.
I integrate AI models and MCP servers into my development workflow to gain speed and quality: code generation and review, documentation, and consistency checks.AI accelerates; validation is always mine.
I deliver documented, versioned in GitHub, and transferable solutions, with training for the team.
Who I fit with
SMEs, startups, and finance or operations teams that have grown using Excel: data in five places, reports that take days, and figures that don't add up.
Do you have data but no answers? Write to me and let's see.
Spanish
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- KubiqXAnalytics Engineer & BI Consultant — FounderCONSULTING AND AUDITSJuly 2025 - Today (1 year and 1 month)Barcelona, SpainBoutique Business Intelligence consulting firm focused on SMEs and startups without their own data team.SERVICES· Data and reporting audit: diagnosis of sources, manual processes, data quality, and inter-departmental consistency, with a prioritized roadmap.· Design and implementation of data architectures in Microsoft Fabric and Azure: medallion architecture, Lakehouses, ingestion pipelines, and ETL.· Data modeling and semantic model development in Power BI: star schema, DAX measures, row-level security (RLS), and incremental refresh.· Development of custom dashboards aligned with the client's brand identity.· Optimization of existing reports: DAX refactoring, relationship review, load time reduction, and cleanup of legacy models.· Advanced visualization with Deneb (Vega-Lite), ECharts, and custom HTML visuals.METHODAlways starting with the business question: what decision will change with that data. From there, the simplest solution that works. Documented delivery, with a data dictionary and a handover session so the client's team can maintain and evolve the solution without external dependency.Development of proprietary products when the project requires it, with a full-stack profile on the team.
- Monday Working SpacesBusiness Intelligence ManagerREAL ESTATEOctober 2024 - Today (1 year and 10 months)Barcelona, SpainHead of Business Intelligence for a coworking operator with 15 centers in Spain, Andorra, and Portugal. Integrated into the Finance team, providing cross-functional service to Operations, Sales, and Marketing.MIGRATION TO MICROSOFT FABRICDesign and implementation of a complete medallion architecture on Microsoft Fabric: three Lakehouses (Bronze, Silver, and Gold) in Delta format, PySpark notebooks for ingestion and transformation, pipeline orchestration, and version control with Git. Replacement of a previous stack based on manual file downloads and Power Query transformations, eliminating monthly manual data consolidation work.INGESTION AND AUTOMATIONIntegration via REST API of operational business sources (coworking management platform Nexudus, CRM, and accounting system), unifying contract, occupancy, billing, and reservation data in a single repository.SEMANTIC MODELConstruction of the corporate semantic model in a star schema on DirectLake, with a DAX measures library, calendar table, center and country hierarchies, and a KPI dictionary agreed upon with department heads to establish a single source of truth.CORPORATE DASHBOARDDevelopment of the executive report in Power BI, with sections on occupancy, profitability per center, sales funnel, meeting room usage, and budget tracking. Design aligned with the corporate brand guidelines.FINANCIAL ANALYSISProfitability models and margin analysis: year-on-year EBITDA comparison per center, unit economics per product type (office, flexible desk, room), and occupancy scenarios.ADVANCED VISUALIZATIONSynoptic dashboards of office occupancy on floor plans, heat maps of room usage, and custom visuals developed with Deneb (Vega-Lite) and HTML for needs not covered by Power BI's native visuals.
- GlobantBI Analyst & Digital Marketing SpecialistCONSULTING AND AUDITSJuly 2021 - October 2024 (3 years and 3 months)Madrid, SpainBusiness and digital marketing analytics for corporate clients in the insurance and telecommunications sectors within multidisciplinary project teams.· Analysis of digital marketing campaign performance: investment tracking, CPA, ROAS, and attribution by channel, with periodic client reporting.· Construction of reports and data models to support decision-making: consolidation of campaign data sources, definition of metrics, and automation of recurring reporting.· Analysis of conversion funnels and user behavior on the web, identifying drop-off points and optimization opportunities.· Presentation of results and recommendations to client stakeholders.
Recommendations
Be the first to recommend Sergio
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- MSc Big Data & DataIEBS Business School2023MSc Big Data & Data
- MScDKS - Digital Knowledge School2019MSc