Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

I'm Lia Gouveia, a passionate Business Intelligence professional with close to a decade of experience delivering data-driven insights. I specialize in turning complex data into clear, actionable dashboards and scalable architectures, always aiming for performance and quality. I thrive in collaborative environments and enjoy driving BI projects from idea to implementation. I have hands-on expertise with Power BI, SQL, DBT, and Azure Data Studio, and I routinely lead teams using Agile/Scrum. My work centers on building robust data warehouses, creating interactive analytics, and ensuring reliable data quality across pipelines.…I'm Lia Gouveia, a passionate Business Intelligence professional with close to a decade of experience delivering data-driven insights. I specialize in turning complex data into clear, actionable dashboards and scalable architectures, always aiming for performance and quality. I thrive in collaborative environments and enjoy driving BI projects from idea to implementation. I have hands-on expertise with Power BI, SQL, DBT, and Azure Data Studio, and I routinely lead teams using Agile/Scrum. My work centers on building robust data warehouses, creating interactive analytics, and ensuring reliable data quality across pipelines.

Lia Gouveia

Data Scientist, Data Visualizer, Web Developer, +2





I'm Lia Gouveia, a passionate Business Intelligence professional with close to a decade of experience delivering data-driven insights. I specialize in turning complex data into clear, actionable dashboards and scalable architectures, always aiming for performance and quality. I thrive in collaborative environments and enjoy driving BI projects from idea to implementation. I have hands-on expertise with Power BI, SQL, DBT, and Azure Data Studio, and I routinely lead teams using Agile/Scrum. My work centers on building robust data warehouses, creating interactive analytics, and ensuring reliable data quality across pipelines.…I'm Lia Gouveia, a passionate Business Intelligence professional with close to a decade of experience delivering data-driven insights. I specialize in turning complex data into clear, actionable dashboards and scalable architectures, always aiming for performance and quality. I thrive in collaborative environments and enjoy driving BI projects from idea to implementation. I have hands-on expertise with Power BI, SQL, DBT, and Azure Data Studio, and I routinely lead teams using Agile/Scrum. My work centers on building robust data warehouses, creating interactive analytics, and ensuring reliable data quality across pipelines.

Available to hire

I’m Lia Gouveia, a passionate Business Intelligence professional with close to a decade of experience delivering data-driven insights. I specialize in turning complex data into clear, actionable dashboards and scalable architectures, always aiming for performance and quality. I thrive in collaborative environments and enjoy driving BI projects from idea to implementation.

I have hands-on expertise with Power BI, SQL, DBT, and Azure Data Studio, and I routinely lead teams using Agile/Scrum. My work centers on building robust data warehouses, creating interactive analytics, and ensuring reliable data quality across pipelines.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Language

Portuguese

Fluent

English

Fluent

Work Experience

Business Intelligence Analyst / Team Lead at BoostInc

October 1, 2025 - Present

Led the BI team in delivering end-to-end analytics solutions using Agile/Scrum methodology. Designed the data model and built a new Data Warehouse architecture from scratch using SQL in DBT and Azure Data Studio, with GitHub for version control and collaboration. Developed a multidimensional Power BI model to enable advanced data analysis and reporting. Implemented automated DBT data quality tests (e.g., uniqueness, not null, relationships) to ensure reliability across pipelines. Migrated legacy reports to the new data model, improving performance, consistency, and maintainability. Created interactive Power BI dashboards using DAX connected to the modernized data warehouse.

Business Intelligence Analyst / Team Lead at PixelFaerie & Freelancer

November 1, 2022 - September 1, 2025

Led the BI team in delivering end-to-end analytics solutions using Agile/Scrum methodology. Designed the data model and built anew Data Warehouse architecture from scratch using SQL in DBT and Azure Data Studio (GitHub used for version control and collaboration). Developed a multidimensional model in Power BI to enable advanced data analysis and reporting. Implemented automated DBT data quality tests (e.g., uniqueness, not null, relationships) to ensure reliability across pipelines. Migrated all legacy reports to the new data model, improving performance, consistency, and maintainability. Created interactive Power BI dashboards using DAX, connected to the data warehouse.

Business Intelligence Analyst / Power BI Developer at FYLD, CGI Dusseldorf / Royal Canin

November 1, 2021 - October 1, 2022

Developed SQL scripts for extracting and transforming data into BI dashboards. Created efficient metrics and enhanced dashboards using Power BI and the Microsoft BI stack. Improved Power BI report performance by optimizing data models, cleaning data, and implementing incremental refresh.

Business Intelligence Analyst / Power BI Developer at Everis Belgium, United Nations

April 1, 2021 - December 1, 2021

Created new HR dashboards covering salaries, contracts, actions, and detailed analyses. Improved efficiency and usability of existing reports through optimization and redesign. Designed reports using DAX, Power BI, Python, and HTML for interactive and insightful visualizations.

Senior BI Consultant / Team Lead at FYLD

September 1, 2019 - March 1, 2021

Integrated data from SAP, PRIMAVERA, and Excel into a Microsoft BI environment. Developed and managed SQL-based Data Warehouse processes using SSIS/SSMS. Created OLAP cubes and visual reports using SSAS, SSRS, and Power BI. Optimized SQL queries, stored procedures, indexes, and tables to enhance performance. Used GitHub for version control and collaborative development of BI solutions. Managed a team of BI developers and coordinated delivery with business stakeholders.

Operational CRM Analyst at NOS

September 1, 2018 - July 1, 2019

Developed campaign management and business analysis processes. Produced key CRM indicators and automated reports using Excel and SAS Enterprise Guide, applying both SAS and SQL for data manipulation and analysis.

BI Analyst at JUMIA

February 1, 2018 - September 1, 2018

Created views for data transformation and extracted data in BigQuery using SQL to generate reports for Central Marketing, Affiliation, SEO, and CRM departments, utilizing Power BI and Google Analytics. Conducted real-time session analysis using Google Analytics and performed TV and Radio campaign analysis using R. Executed cohort analyses in Power BI to assess customer retention and engagement.

Data Scientist at ZAP

March 1, 2017 - November 1, 2017

Produced outbound campaign reports using Excel and Access. Utilized SSIS with SQL scripts for data transformation and preparation. Created and validated predictive models to forecast customer churn using RapidMiner.

HR Intern at FIDELIDADE

January 1, 2017 - March 1, 2017

Supported monthly HR reports using Excel and SAS Visual Analytics. Assisted in HR control processes using SAP.