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
Files
Resume Search
Nationality
Job category
City or country
Sort by
Contact way
57****5192
ju**@**om
*****
*****
Membership will unlock the resume
Also view