Juan

Data Analyst
Male28 y/oIT Support EngineerLive in ColombiaNationality Colombia
Share

Summary

Data Analyst with a master’s degree in World Economy and experience in Business Intelligence and Research. Skilled in econometric modeling, capable of working with multiple statistical software and programming languages such as Python and R. Creative problem solver who is capable of thinking outside of the box when dealing with complex tasks. Also an effective communicator who combines data analysis and presentation skills to build effective BI reports that help leaders on performance tracking and decision making. Overall, someone passionate about working with data, constantly learning new techniques and tools of analysis.

Work experience

Data Analyst

Reelgood
2023.09-Current(a year)
Developed and optimized queries to automate data extraction for recurring processes, including content rankings, service catalogs, and Tableau reports, as well as for specific analyses. ○ Facilitated the initial implementation of Tableau, establishing it as a crucial tool for performance tracking and decision-making. ○ Built and maintained the Marketplace Performance Dashboard to monitor ad-campaign revenue, inventory levels, and contracted deliveries. ○ Provided continuous data analysis, insights, and ad-hoc reports to the Marketing team on streaming industry content availability and performance, contributing to SEO efforts and brand awareness, leading to publications in major US media outlets. ○ Assisted Product Management with web tracking and ad-hoc analysis to understand user behavior, enhancing decisions to drive user conversion and retention. ○ Conducted weekly and monthly reviews of streaming content rankings prior to their public release.

BI & SQL Developer

Now Optics
2022.07-2023.09(a year)
○ Built and provided continuous maintenance and enhancements of Tableau reports to help business managers and executive leaders with decision-making. ○ Continuously validate the accuracy of data in the reports and in the Data Warehouse and assist in improving existing data processes according to business logic. ○ Work with report users to validate business requirements and ensure proper data is available. ○ Write SQL queries, stored procedures and views to pull data from the Data Warehouse and transform the results into structures needed for Tableau reports. ○ Manage Tableau user access (user credentials and row level security) as well as folder management in the Tableau server. ○ Provide support in the Data Governance efforts (updating the data dictionary, developing the metrics catalog, and performing other enhancements in the Tableau server required for this initiative).

BI Analyst

Turia Group
2021.09-2022.07(a year)
○ Built and maintained Power BI reports for multiple areas and companies of the corporate group. Objects of analysis include sales indicators, inventory management, cost control, customer activity, and backlog analysis, among others. ○ Perform data extraction through SQL querying, data modeling through Power BI, and complex DAX calculations to prepare data for dashboard building. ○ Continuously validate the accuracy of data in the reports and in the Data Warehouse and assist in improving existing data processes. ○ Developed econometric time series models to forecast the price of shredded scrap, combining creativity with quantitative methods to identify significant variables and set effective parameters. Models developed included SARIMAX, multivariate regression on the trend, and VAR. ○ Provided general support to other areas of the organization on Power BI report accessibility, row-level security, and fixing report calculations, among other forms of support.

Administrative Assistant

Universidad del Norte
2021.09-2022.06(10 months)
○ Managed the Agenda Cultural, ensuring the smooth development of the activities, which required adequate planning of the events, designating places and dates, coordinating the logistics, and advertising the events through promotional materials, the Agenda Cultural website, and email interactions with the public. ○ Assisted the Language Institute in data analysis work, in most cases reporting on indicators that are relevant for the institute, such as admissions and performance of students across different language programs, and in other cases supporting with analysis for research on more special topics.

Educational experience

Beijing Normal University

World Economy and China
2018.09-2020.06(2 years)
Coursed a Master's degree in World Economy and China. My thesis analyzed the relationship between tax morale, perceptions of the quality of governance, and trust in the government on the size of the hidden economy.

Universidad del Norte

Business Administration
2013.01-2018.03(5 years)
.

Languages

Chinese (Mandarin)
A little
English
Proficient
Spanish
Native

Skills

Excel
SPSS
Stata
Pandas (Python)
Scikit-learn (Python)
Statsmodels (Python)
Tableau
Power BI
AWS Athena
R
Python
SQL
Resume Search
Nationality
Job category
City or country
Jobs
Candidates
Blog
Me