Brian Castano Rendon, Developer in Medellín - Antioquia, Colombia
Brian is available for hire
Hire Brian

Brian Castano Rendon

Verified Expert  in Engineering

Power BI Developer

Medellín - Antioquia, Colombia
Toptal Member Since
October 17, 2023

Brian is a Power BI professional with over seven years of experience in data analytics and business intelligence. He has worked for US companies and startups in the real estate, logistics, consulting, wholesale, retail, and manufacturing sectors. Brian specializes in improving teams' analytical capabilities and creating tools that streamline operations, reduce costs, and enhance company performance and profitability.


J.S. Held
Azure SQL, Azure Synapse, Business Intelligence (BI), Power Query M...
Source Alliance Network
Microsoft Power BI, Excel 365, Power Query, Power Pivot, DAX, Data Modeling...
Microsoft Power BI, Azure Synapse, Azure Data Lake, Power Query, DAX...




Preferred Environment

Microsoft Power BI, SQL, Azure SQL, SQL Server Reporting Services (SSRS), Tableau, Qlik Sense, Git

The most amazing...

...thing I've developed was an analytical product that helped companies save millions by tracking inefficiencies across teams.

Work Experience

Senior Business Intelligence Analyst

2021 - PRESENT
J.S. Held
  • Rebuilt several legacy reports into Power BI by adding extra layers of analysis and filtering capabilities, allowing the senior management to access different finance and business development areas in one place.
  • Developed reports to track key business development metrics, such as customer acquisition cost, loan-to-value rates, retention rates, churn rates, and customer latency, directing the development of several marketing and business development efforts.
  • Created several operational reports to monitor the most relevant performance metrics. The reports served as a management tool for directors and practice leaders, assisting them in making informed decisions on a daily basis.
Technologies: Azure SQL, Azure Synapse, Business Intelligence (BI), Power Query M, Microsoft Power BI, NetSuite, Dynamics CRM 365

Senior Data Analyst

2022 - 2023
Source Alliance Network
  • Prepared expense reports for the central procurement department to track the expenses of various private equity portfolio companies. It gave the team a clear view of consolidation opportunities and unnecessary expenses.
  • Developed savings reports to monitor savings achieved by the central procurement department for private equity portfolio companies.
  • Created a main vendor report, allowing the central procurement department to view the vendors associated with the portfolio companies and assess their bids. It helped in evaluating potential consolidation opportunities.
Technologies: Microsoft Power BI, Excel 365, Power Query, Power Pivot, DAX, Data Modeling, Data Visualization

Senior Business Intelligence Analyst

2022 - 2023
  • Developed financial reports and a dashboard for senior management, providing them with a clear overview of the most pertinent financial data for their vast network of over 56,000 retail locations.
  • Prepared a logistical report detailing the company's transactional information with 3rd-party logistical providers like UPS and FedEx. It identified inefficiencies in these partnerships and equipped operational teams with a tool to benchmark results.
  • Created an operational report on merchandising activities across various locations within the retail network, allowing the operations manager to report on these activities and track the achieved results.
Technologies: Microsoft Power BI, Azure Synapse, Azure Data Lake, Power Query, DAX, Power Query M

Head Data Analyst

2017 - 2022
  • Established a new analytical team and built the main analytical architecture, integrating the work of data engineers, data analysts, and machine learning specialists.
  • Developed all major reports and dashboards for every department within the company, including finance, operations, human resources, marketing, and sales. This equipped the department leaders with the necessary analytical tools for daily work.
  • Created external company reports for senior management, the board, and potential investors. The reports covered metrics relevant to the company's strategic goals and internal operations.
Technologies: Microsoft Power BI, SQL, Azure SQL, Azure Synapse, Excel 365, Google Analytics, Google Sheets

Client Dashboard for Consulting Firm
The report showcases significant elements of the client activity for a consulting firm that specializes in diverse areas and serves clients all over the world. The measured elements included:

• Projects and revenue by client, country, region, practice, and contact in the current year compared to the previous year.
• Client interactions by contacts and agents.
• Geographical elements relevant to the client, agents, and projects.
• Retention rates and churn rates.

The data sources in this report originate from SQL databases in Azure, and the model used is a snowflake schema. Other metrics, such as time intelligence, financial, and relevant marketing indicators, can also be found.

Merchandising KPIs for Magazine Distribution Company
The report presents the significant KPIs for merchandising activities that the magazine distribution company carries on a regular basis, including:

• Revenue and draw by store.
• Store efficiency, compliance, and visit metrics.
• Store-specific unit sales and associated timelines.
• Geographical elements pertinent to clients, agents, and visits.

The data sources referenced in this report are from an Excel file located in Azure Data Lake, and the model used is a traditional star schema. The measures developed for the report are primarily operational metrics and relevant marketing measurements.

Missed Visit Tracker for Distribution Company
The report highlights various aspects of store operations and the impact of customer visits on sales. It serves as a valuable tool for regular managers and senior management, enabling them to monitor different variables in processes and gain insights into results and operations. The report tracks many elements, including:

• Scheduled and impulse visits categorized by chain, region, and country.
• Sales behavior in relation to visits.
• Geographical factors and timelines pertinent to these visits.

The data sources referenced in this report come from SQL databases hosted in Azure Synapse, and the model used is based on a snowflake schema. The report offers numerous user-friendly navigation items, including bookmark and drillthrough buttons, to enhance the user experience and facilitate the search for insights.

Revenue Analysis for Distribution Company
The report aims to illustrate how the company's revenue results evolve over time, comparing it with the budget and the corresponding period from the previous year. This comparison helps measure and track the company's weekly performance. Some of the elements tracked in this report include:

• Revenue for the current year compared to the previous year, broken down by week.
• Revenue for the current year compared to the previous year, categorized by retailer and chain.
• Actuals for the current year versus the budget, broken down by week.
• Actuals for the current year versus the budget, categorized by retailer and chain.

The data sources for this report are SQL databases in Azure Synapse, and the model in use employs a star schema. To enhance user experience, the report includes numerous navigation items, such as bookmarks and drillthrough buttons. These features allow users to independently search for the necessary information and draw their own conclusions.
2010 - 2014

Bachelor's Degree in Humanities

University of Salamanca - Salamanca, Spain


Mastering DAX Calculations in Power BI



SQL - MySQL for Data Analytics and Business Intelligence



MS Excel Exam Guide: Analyzing and Visualizing Data



Qlik Sense for Data Science and BI



Microsoft Certified: Data Analyst Associate with Power BI



ZoomInfo Certification in Sales

ZoomInfo University


Creating Dashboards and Storytelling with Tableau



Visual Analytics with Tableau



Essential Design Principles for Tableau



Fundamentals of Visualization with Tableau



Microsoft Power BI, Power Query, Tableau, Qlik Sense, Git, Zoom, Power Pivot, Google Analytics, Google Sheets


Power Query M, SQL


Business Intelligence (BI), Database Design


SQL Server Reporting Services (SSRS), Databases, Azure SQL, Data Pipelines, MySQL, Microsoft SQL Server


Azure Synapse


Critical Analysis, DAX, Data Modeling, Data Visualization, Data Analysis, Descriptive Analysis, Statistical Data Analysis, Statistics, ETL Tools, Data Mining, Excel 365, Office 365, Data Analytics, Azure Data Lake, NetSuite, Dynamics CRM 365

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring