Jorge is available for hire
Hire JorgeJorge Andrés Silva Rodríguez
Verified Expert in Engineering
Data Engineer and Developer
Bogotá - Bogota, Colombia
Toptal member since September 20, 2023
Bio
Jorge is a Microsoft Certified: Data Analyst Associate and Azure Data Engineer Associate with Power Platform and Power BI certifications. He specializes in data analytics, business intelligence, data science, and SQL. Jorge has solid experience as a Power BI administrator and developer working for various enterprise clients in banking, finance, oil & gas, and business services.
Portfolio
Guggenheim
Azure, DAX, Microsoft Power BI, Power Query, Power Query M, SQL, SQL Server BI...
Schlumberger
Azure, DAX, Microsoft Power BI, Power Query, Power Query M, SQL, SQL Server BI...
Simetrik
Amazon QuickSight, Snowflake, SQL, Amazon S3 (AWS S3), Microsoft Excel...
Experience
- Microsoft Power BI - 4 years
- Power Query M - 3 years
- DAX - 3 years
- Power Pivot - 3 years
- SQL - 3 years
- Datasets - 3 years
- Dashboards - 3 years
- BI Reports - 3 years
Work Experience
Power BI Administrator & Developer
2022 - 2023
Guggenheim
- Optimized the Power BI environment. Upgraded gateways, managed gateway connections, and finetuned admin portal settings.
- Streamlined the report development workflow. Created data models, developed reports, and established deployment pipelines.
- Enhanced data analysis efficiency. Conducted report analysis, maintained SQL Server Management Studio jobs, executed Transact-SQL queries, and managed SQL Server Integration Services packages.
Technologies: Azure, DAX, Microsoft Power BI, Power Query, Power Query M, SQL, SQL Server BI, Microsoft Excel, Dashboard Development, Reporting, Data Analysis
EDP-BI Operations Analyst
2021 - 2022
Schlumberger
- Streamlined and managed Power BI enterprise gateways, including creating and maintaining connections for diverse data sources such as SQL, Azure Analysis Services (AAS), and SAP.
- Improved Power BI reports through ServiceNow tickets by optimizing Data Analysis Expressions (DAX), addressing Power BI connection issues, and resolving Power BI service and desktop problems.
- Managed and supported seamless application upgrades and downtimes for critical Azure services, including AAS, Azure Data Factory, and Synapse, ensuring uninterrupted service availability.
Technologies: Azure, DAX, Microsoft Power BI, Power Query, Power Query M, SQL, SQL Server BI, Windows, Azure Data Factory (ADF), SQL Server Analysis Services (SSAS), Azure SQL, Microsoft Excel, Dashboard Development, Reporting, Data Analysis
Technical Implementator
2021 - 2021
Simetrik
- Established and maintained finance reconciliations for multiple clients.
- Leveraged cloud services, including EMR, S3, and Snowflake SQL, to optimize data processing efficiency.
- Utilized Amazon QuickSight as a data visualization tool to create interactive dashboards and reports.
Technologies: Amazon QuickSight, Snowflake, SQL, Amazon S3 (AWS S3), Microsoft Excel, Dashboard Development, Reporting, Data Analysis
Data Analytics Consultant
2020 - 2021
BexTechnology
- Orchestrated the data governance policy's implementation within Ministerio de Defensa Nacional's Power BI service tenant.
- Spearheaded the design, maintenance, and development of dashboards, reports, and datasets for various clients.
- Oversaw the end-to-end data lifecycle, encompassing the data preparation, data modeling, visualization, analysis, and administration of dashboards, reports, and datasets.
- Adapted to different project and client requirements by working with various data connection modes, including DirectQuery, live, and import mode connections to SQL Server, AAS cubes, and Excel file data sources.
- Leveraged the power of the DAX language to create custom measures and harnessed Power Query for efficient extract, transform, and load (ETL) processes.
Technologies: Azure, Microsoft Power BI, Azure SQL, DAX, Power Query, Power Query M, SQL, SQL Server Analysis Services (SSAS), SQL Server BI, Windows, Microsoft Excel, Dashboard Development, Reporting, Data Analysis
Project History
Power BI Reports Portfolio
A compilation of some of the reports I've created using Power BI combined with the DAX language to create measures and calculated columns and Power Query M to perform ETLs. The compilation contains reports related to eCommerce, banking, finance, and surveys.
Power BI eCommerce Report
A Power BI report I created to help a food delivery eCommerce company make intelligent, informed decisions according to orders, products, and users. The report consists of five pages, providing managers with an overview and detailed analysis of how operations work in the cities they operate. I also added a basket analysis by product.
Power BI Sales Report
A Power BI report I developed to help a corporation's sales team inspect and interpret their sales. It's a 5-page report that allows the team to analyze the profit, revenue, number of sales, and trends by region, country, and priority order.
Power BI Golf Bays Availability Report
A Power BI report I created for the manager of a sports entertainment company. The objective was to check the golf bays available during the day in one of their locations worldwide. When a bay is booked, it becomes available after 2 hours and 15 minutes.
Top 10 International Bootcamp Report
https://www.youtube.com/watch?v=aINq1rRCbFMCreated one of the top 10 reports for the Power BI Zoom Factor – Microsoft competition, an international digital bootcamp for Power BI report creators and the business community. The report shows sales information from a fictitious company.
Education
2013 - 2018
Bachelor's Degree in Aeronautical Engineering
Universidad de San Buenaventura - Bogota, Colombia
Certifications
AUGUST 2022 - PRESENT
Data Analyst in SQL Career Track
DataCamp
FEBRUARY 2022 - PRESENT
SQL (Advanced)
HackerRank
JUNE 2021 - JUNE 2024
Microsoft Certified: Azure Data Engineer Associate
Microsoft
MARCH 2021 - PRESENT
Advanced DAX
Maven Analytics
MARCH 2021 - PRESENT
Power BI Specialist
Maven Analytics
FEBRUARY 2021 - PRESENT
Microsoft Certified: Azure Data Fundamentals
Microsoft
FEBRUARY 2021 - PRESENT
Microsoft Certified: Azure Fundamentals
Microsoft
JANUARY 2021 - PRESENT
Microsoft Certified: Power Platform Fundamentals
Microsoft
SEPTEMBER 2020 - SEPTEMBER 2024
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
SEPTEMBER 2020 - SEPTEMBER 2024
Microsoft Certified: Data Analyst Associate
Microsoft
Skills
Tools
Microsoft Power BI, SQL Server BI, Power Query, Power Pivot, Amazon QuickSight, Microsoft Excel
Languages
SQL, Power Query M, Snowflake
Platforms
Windows, Microsoft Power Platform, Azure, Microsoft, Azure IaaS, Azure PaaS
Storage
PostgreSQL, SQL Server Analysis Services (SSAS), Azure SQL, Amazon S3 (AWS S3), Azure Blobs
Other
DAX, BI Reports, Datasets, Dashboards, Dashboard Development, Reporting, Data Analysis, Azure Data Factory (ADF), Azure VDI, Reports, Data Visualization
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.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
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