Santiago Páez Data Analyst | Power Bi Developer | Marketing consultant | BI

Power BI Consultant

Ch2 Solutions

Sep 2024 - Current (1 year 10 months)

I am a power bi consultant, so I work with the Azure suite ensuring best practices from the connection. These reports (mostly in Power bi and some in Tableau) are uploaded ensuring security, so I manage roles. I am in charge of controlling the good practices of traceability in reporting and that each report explains the story it should tell for decision making. As a consultant developer for this Arizona company, I am in charge not only of suggesting optimizations, business intelligence but also that end users have interactive, tested (A/B) and concrete dashboards at their fingertips.

QA Tester and Power Bi Developer

Banco Santander

Mar 2024 - Aug 2024 (6 months)

As a QA Tester for mobile, email, and web campaigns in Banco Santander's digital services, responsible for conducting comprehensive quality and security testing with high automation using tools like Selenium and Pega, ensuring proper functionality across platforms and collaborating closely with development and marketing teams to address identified issues, data managment, maintaining campaign standards, and performing load and performance testing to ensure digital service stability during peak demand periods. Also knowing ceratin programming languages, such as SQL or NoSql. As I worked closely with the engineering and procurement teams, I had to learn about software development concepts to be able to give clear insights and provide much stro

I

Web Analyst and Power BI Developer

Inchcape DDC

Jul 2023 - Jul 2024 (1 year 1 month)

As a busines analyst, I oversee regional data traffic for all Inchcape brands, setting up dashboards to provide insights to brands like Mercedes Benz or Mazda, proposing visualizations for team metrics, and optimizing database structures and connections using tools such as Salesforce, Google Search Console, .NET, Python, NoSql, SQL, Azure Databricks, GA4, Google Ads, and Facebook Ads, Tableau, Power bi (DAX and M Query). Additionally, I develop quality control tools to assess database usability and provide global support for data-driven marketing strategies, maintaining contact with data ingestion teams in Latin America.

M

Marketing Data Analyst

Nagarro, Merck Co

Feb 2023 - Jun 2023 (5 months)

In the pharmaceutical sector, I conducted social listening analysis for Merck Oncology, writing valuable insights and managing global clients with dynamic processes, utilizing tools like Talkwalker and Traackr, collaborating with a diverse team across New York, Germany, and India, while also creating specific queries and data management I also applied knowledge in DBT, Python (4 years), Data Warehouse, M Query, Meta Ads, C# (4 years), A/B, JavaScript (3 years), M Query, R (2 years), SQL (5 years), Tableau, Java (2 years), C++ (1 year), DAX (4 years), Power Bi Data Visualization (DAX and M Query). We used agile methodologies and Scrum strategy to manage projects.

Marketing Science Analyst

OMD Colombia, Kimberly Clark

Feb 2023 - Feb 2024 (1 year 1 month)

As a senior analyst, I led and founded the Data Army team, merging paid media, social listening, e-commerce, business analysis and website metrics to bolster campaign and brand strategies for Kimberly Clark products. I coordinated and wirted analysis and insights formulation in the Feminine and Adult Care sector across Brazil, Argentina, Colombia, Peru, and Chile, guiding continental marketing initiatives and data management. I also applied knowledge in Python (4 years), Tableau, C# (4 years), JavaScript (3 years), R (2 years), M Query, SQL (5 years), Java (2 years), Data warehouse, Meta Ads, C++ (1 year), DAX (4 years), Power Bi. We used agile methodologies and Scrum strategy to manage projects. As the leader of my analysis, I was the prod

B

Digital marketing Data analyst

BV Studio

Oct 2022 - Jul 2023 (10 months)

I spearheaded digital data analysis, utilizing tools like Firebase, Google Play Console, Salesforce, App Store Connect, Meta Ads and BigQuery to produce comprehensive reports. Advising esteemed brands like Oye de J Balvin, recognized by the UN for mental health services, I engaged in benchmark analysis using programming languages like SQL, data warehouses and tools such as Talkwalker. This contributed to tailored communication strategies and mobile app development, culminating in an award-winning project at the UN, showcasing advanced business intelligence capabilities across all stages of data handling from collection to visualization and data management. I also applied knowledge in DBT, Python (4 years), Tableau, C# (4 years), JavaScript

Data analyst

United Nations Volunteers

Mar 2022 - Jun 2022 (4 months)

As a Data Analyst, I developed a platform to streamline refugee application processing, implementing a logical and narrative framework to enhance user experience and efficiently manage requests, as well as to register and consolidate biodata of applicants and beneficiaries into a database, ensuring cybersecurity of sensitive data. I also applied knowledge in DBT, Python (4 years), Data Warehouse, M Query, C# (4 years), JavaScript (3 years), R (2 years), SQL (5 years), Tableau, Java (2 years), M Query, C++ (1 year), DAX (4 years). As I worked closely with the engineering and procurement teams, I had to learn about software development concepts to be able to give clear insights and provide much stronger analysis with data from software or to

M

Senior Data and Community Manager

Meca 360

Feb 2022 - Oct 2022 (9 months)

As a Senior Data and Business Analyst, I oversaw all stages from data collection, connection, analysis, to visualization in digital, marketing, sales, sustainability, and social management for client brands. I provided guidance on narratives, community management, content creation, branding, and business models, while leading technological and social listening services to impact audiences and stakeholders. I utilized advanced Excel, GA4, Talkwalker, Power BI, Salesforce, Python, and more softwares related to data analyisis and data management. I also applied knowledge in DBT, Python (4 years), C# (4 years), JavaScript (3 years), R (2 years), SQL (5 years), Java (2 years), C++ (1 year), DAX (4 years), M Query. As I worked closely with the en

Social and Data Analyst - Environment and Agriculture Leader

Desjardins Group

Jan 2022 - Mar 2022 (3 months)

I led the environmental analysis in the Colombian Coffee Region as part of a project proposal preparation for Strengthening the economic autonomy of women entrepreneurs in Colombia. I coordinated focus groups and semi-structured interviews in the field with regional stakeholders. I conducted discourse analysis and georeferencing studies based on fieldwork findings, aimed at strengthening women's productive projects in the region and ensuring their smooth transition into the financial sector. We used agile methodologies and SCRUM strategy to manage projects. I designed a tool to collect the information clearly and then visualize it in findings. I worked on business intelligence and generated insights for the digital marketing strategy by dev

Data analyst - Participation field leader

Ministerio de Cultura

Oct 2020 - Mar 2021 (6 months)

As Participation Field Leader I supported the Regional Development Directorate in organizing, analyzing, and contextualizing the Diagnostic Phase of the update of the National Culture Plan - PNC (2022-2032). I analyzed nearly 5,000 citizen participations to create and write an initial diagnosis and proposal regarding the needs of the culture sector, both in dialogue spaces and digital responses. Additionally, I created dynamic reports that also functioned as data tools to strategically characterize and provide further analysis tools for the PNC applying data management. I also applied knowledge in Python (4 years), C# (4 years), JavaScript (3 years), R (2 years), SQL (5 years), Java (2 years), C++ (1 year), DAX (4 years), NoSQL (1,5 years),

E

Community Manager and Content creator

Egos Media

Jul 2020 - Feb 2021 (8 months)

As Senior Community Manager and Content Creator, I managed the communities of Egos' clients' brands, applying storytelling with data and content creation. I used Hootsuite and a content organization strategy called 'Backgrounds and formats'. I led the definition of communication strategies with an Amec Framework approach, focusing on objective monitoring, and formulated narratives for corporate and political communication strategies. Additionally, I created reports in Power BI (DAX and M Query), sometimes utilizing Python and Machine Learning. I also employed Microsoft Excel to organize insights effectively, which complemented my use of Power BI in showcasing the performance of the creatives, ensuring a comprehensive analysis of our content

C

Teacher in Political Science, History and Philosophy

Colegio Retos

Jan 2020 - Apr 2020 (4 months)

As a Teacher in Political Science, History, and Philosophy, I developed and delivered engaging lesson plans that fostered critical thinking and encouraged student participation. I assessed student performance through various evaluation methods, providing constructive feedback to enhance their learning experience. Additionally, I utilized Microsoft Excel to organize project data and track progress, ensuring that all educational initiatives were effectively monitored and managed. This approach not only streamlined project organization but also contributed to a more structured learning environment for my students.

C

Data analyst

CPAEZH

Jul 2019 - Oct 2019 (4 months)

I traced the context, history, actors, and actions related to the financial intervention of the private sector in climate change adaptation policies and activities. Additionally, I analyzed the challenges and opportunities in public policies and instruments that promote the development of the project's scope, conducting literature and file reviews that complement the project. We used agile methodologies, Power Bi (DAX and M Query), Tableau, SQL, Data Warehouse and SCRUM strategy to manage projects of Digital Marketing. We develop research tools to be able to collect the information and then visualize it.

Storymaker and Data Analyst

buho media

Jul 2019 - Nov 2019 (5 months)

In Buho Stories, I contributed to the creation of narratives for private, political, or public clients, aiming to preserve the value of their brands and manage crises in their sectors through communication strategies tailored to their history and values. I built tools to collect data aligned with corporate or political objectives. Additionally, I trained Buho members in narrative techniques to strengthen recommendations delivered to clients, which resulted from analysis and constant monitoring of their networks and media. This involved employing storytelling with data strategies and developing data warehouses, producing reports in Power BI (DAX and M Query) and Tableau. Furthermore, I utilized Microsoft Excel to organize projects effectivel

Argumentative Styles Teacher

Universidad Rosario

Jul 2018 - Jan 2019 (7 months)

- I built a study plan focused on the transmission of theoretical knowledge regarding the basic and advanced standards of writing as a tool for political, artistic, and scientific expression. - I taught the course on Argumentative Styles II and managed forms of individualized evaluation with second and third semester students of the programs immersed in the Faculty of International, Political, and Urban Studies. - I created original practice material (grammar, reading comprehension, and spelling) for the course of Argumentative Styles II. - I contributed in a transversal way to the pedagogical development of the students in their other subjects, implementing data management techniques to measure student performance effectively. Additiona

HUB Data and market analyst

ANDI - Asociación Nacional de Empresarios de Colombia

Jun 2018 - Jan 2019 (8 months)

I built a PIPELINE type portal to organize all the foundation's projects, enabling tracking of their development, writing insights, and measurement of success KPIs. This tool streamlined the archiving process and project visualization. Additionally, I supported chain, sales, and inclusive creation projects, empowering vulnerable producers to turn their chores into profitable ventures to sustain their livelihoods. I also applied knowledge in Python (4 years), Git, GitHub, C# (4 years), JavaScript (3 years), R (2 years), SQL (5 years), Java (2 years), C++ (1 year), DAX (4 years). We used agile methodologies and Scrum strategy to manage projects. Furthermore, I utilized Microsoft Excel to organize project data effectively and employed Power BI

Classics of Political Thought Teacher

Universidad Rosario

Jan 2017 - Jun 2018 (1 year 6 months)

- I supported the practical exercises of the students in the formulation of solutions for the development of their academic projects. - I accompanied the class chair through the formulation of activities, explanation of the themes of the curriculum, and provided ongoing advice to the students. - I contributed to the development and creation of the Political Theory hotbed together with the head teacher of the chair. Additionally, I utilized Microsoft Excel to organize project data effectively and employed Power BI to track progress, enhancing the overall management of academic projects and ensuring that students had the resources they needed for success.

Santiago Páez

About

Detail

Timeline

Résumé

Santiago Páez new_releases

About

Detail

Santiago Páez