I’m Samuel Falcao Cavalcante, a Freelance Data Analyst and Microsoft Certified Data Analyst with over 5 years of experience in data analytics, BI, and executive reporting. I specialize in advanced SQL (including query optimization) and Power BI, building end-to-end dashboards, KPI frameworks, and DAX models that turn large, complex data into clear, actionable insights for decision-making. I’m known for blending analytical rigor with storytelling and UI/UX best practices to improve dashboard usability and stakeholder adoption. I collaborate cross-functionally with Data Engineering and business leaders, leading requirements gathering, scope alignment, and presenting findings to C-level and investor stakeholders. I also focus on data governance, validation, and thorough technical documentation to ensure accuracy, integrity, and compliance in data warehouse environments.

Samuel Falcao Cavalcante

I’m Samuel Falcao Cavalcante, a Freelance Data Analyst and Microsoft Certified Data Analyst with over 5 years of experience in data analytics, BI, and executive reporting. I specialize in advanced SQL (including query optimization) and Power BI, building end-to-end dashboards, KPI frameworks, and DAX models that turn large, complex data into clear, actionable insights for decision-making. I’m known for blending analytical rigor with storytelling and UI/UX best practices to improve dashboard usability and stakeholder adoption. I collaborate cross-functionally with Data Engineering and business leaders, leading requirements gathering, scope alignment, and presenting findings to C-level and investor stakeholders. I also focus on data governance, validation, and thorough technical documentation to ensure accuracy, integrity, and compliance in data warehouse environments.

Available to hire

I’m Samuel Falcao Cavalcante, a Freelance Data Analyst and Microsoft Certified Data Analyst with over 5 years of experience in data analytics, BI, and executive reporting. I specialize in advanced SQL (including query optimization) and Power BI, building end-to-end dashboards, KPI frameworks, and DAX models that turn large, complex data into clear, actionable insights for decision-making.

I’m known for blending analytical rigor with storytelling and UI/UX best practices to improve dashboard usability and stakeholder adoption. I collaborate cross-functionally with Data Engineering and business leaders, leading requirements gathering, scope alignment, and presenting findings to C-level and investor stakeholders. I also focus on data governance, validation, and thorough technical documentation to ensure accuracy, integrity, and compliance in data warehouse environments.

See more

Language

English
Fluent
Portuguese
Fluent

Work Experience

Data Analyst at Raymond James Ltd.
July 1, 2022 - Present
Architected and standardized the end-to-end BI implementation lifecycle (requirements → development → UAT → release), strengthened data governance and ensured high-quality analytics delivery. Led requirements discovery and scope management with cross-functional stakeholders, translating complex needs into BI epics/user stories for initiatives involving large datasets and advanced data models. Produced technical documentation (BRDs, data definitions, lineage/traceability) to reinforce governance and improve auditability. Authored and optimized advanced SQL queries for data cleansing, transformation, and relational modeling. Automated manual and legacy reporting workflows using SQL + Power BI, reducing cycle time and errors. Served as Power BI SME, delivering executive dashboards and KPI frameworks for leadership. Introduced Agile (Scrum/Kanban) and established Jira/Confluence to improve delivery visibility. Built and optimized DAX measures and data models; designed user-centered d
Business Intelligence Consultant at BRQ
July 1, 2021 - June 1, 2022
Led global stakeholder engagement and served as primary communication bridge between cross-cultural teams. Partnered with C-level leaders to define strategic KPIs and translate executive priorities into reporting requirements and BI roadmaps. Enhanced front-end UI/UX, improving clarity and decision speed, and managed Agile delivery (Scrum) for on-time deployment. Built dashboards for SAP implementation enabling real-time project visibility for directors and teams. Engineered a recursive DAX-based data processing solution to track SIT/UAT approvals, improving data quality and transparency. Optimized reporting performance by refining data models and refresh strategies. Developed semantic models using DAX and Power Query M; collaborated with Data Engineering to align SQL logic and dataset updates; enabled Self-Service BI by publishing curated dataflows and datasets.
Data Analyst / Technical Team Lead (BI) at Tecla T
September 1, 2020 - July 1, 2021
Led a 3-person BI project team, owning backlog management and mentoring analysts. Managed stakeholder alignment end-to-end, translating business needs into actionable BI deliverables. Built and optimized executive and departmental dashboards in Power BI for an Internet Service Provider, delivering decision-grade insights for C-level leaders and external investors. Designed KPI methodologies in collaboration with leadership and contributed to a major data migration consolidating three sources into a unified data warehouse; supported ETL/data integration using SQL; prepared clean datasets for Power BI ingestion. Published dataflows and curated datasets in Power BI Service to enable self-service analytics and improve governance. Enabled near real-time analytics by structuring datasets for Live Connection.

Education

Bachelor of Science in Mechanical Engineering at University of Fortaleza (UNIFOR)
January 1, 2014 - January 1, 2019

Qualifications

Microsoft Certified: Data Analyst Associate (PL-300)
April 1, 2025 - December 29, 2025

Industry Experience

Software & Internet, Financial Services, Professional Services, Media & Entertainment

Hire a Data Analyst

We have the best data analyst experts on Twine. Hire a data analyst in Langley today.