Learn Data Skills
Beta
João Lyra

João Lyra

Data Analyst

Migo Money | Brazil

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Track

Associate Data Analyst in SQL (previously Data Analyst in SQL)

My New Course

Introduction to SQL

Quantitative pioneer, venturing into unexplored territories of data exploration.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

DataLab

Analyzing unicorn company data

course

Introduction to SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Joining Data in SQL
Understanding Data Engineering

My Work Experience

Where I've interned and worked during my career.

Migo | Jul 2022 - Apr 2023

BI Analyst

to consumers and small businesses within their own applications. - Analyzed data and created datasets to support analysis and company decision-making process - Identified areas of improvement and develop strategies to increase revenue and reduce costs - Prepared reports and present them to relevant stakeholders - Provided insights to support long-term growth plans - Provided training on how to use business intelligence tools, such as Sigma, Snowflake and SQL - Fostered a culture of data-driven decision making by highlighting the value of data and the insights that can be gained through analysis
Show More

RankMyAPP | Oct 2021 - Jun 2022

Data Analyst

RankMyApp is a marketing intelligence solution for user acquisition on mobile devices. - Supervised results and progress of advertising campaigns for the clients portfolio - Created and executed analyses of traffic quality, user journey and creative piece's performance Managed Data team, overseeing goals, deliverables, prioritizing and coordinating tasks, and managing team projects - Led a team of 4 data analysts overseeing project timelines, staffing needs, and performance evaluations while ensuring timely delivery of high-quality reports to internal and external stakeholders - Leveraged advanced analytics tools including SQL, Python, and Power BI to identify key user behaviors and trends across multiple advertising channels, driving improvements to overall customer engagement metrics

Incognia | Aug 2019 - Oct 2021

Data Analyst

Incognia is a solution built with privacy-by-design that has a base of more than 80 million mobile devices delivering a diverse portfolio of cybersecurity and fraud prevention products. - Collaborated with product teams to analyze user behavior data - Built reports and dashboards to aid in decision-making process - Delivered information on levels of fraud in client applications, revenue, and usage of solution, as well as security insights - Created and presented fraud reports that helped stakeholders make decisions about fraudulent behaviour - Used Redash, SQL and Tableau to create dashboards and reports

CESAR | Jan 2019 - Mar 2019

Summer Job Business Intern

C.E.S.A.R. is an innovation hub that boosts business through design, technology and education. The summer job project is a challenge where teams are connected with companies and are tasked with solving major problems suffered by these organizations by developing solutions using design methodology.. I worked on the design and business model. We worked on the development of a device that tracks productivity on a construction site. I guided interviews with users, gathered requirements, had weekly meetings with the stakeholders, managed tasks and projects and together with designers and software developers built a digital platform for our solution.

CITi UFPE | Jun 2017 - Jun 2018

Sales Consultant

CITi is Brazil’s biggest tech junior enterprise. As a consultant, I executed the sales of a diverse portfolio of apps and web- based products, working on the whole process, starting with the acquisition of new clients, ending with the project’s final delivery. I worked managing customer relations, understanding the client's necessities and expectations and communicating that to the development teams, while also designing and presenting project proposals.

My Education

Take a look at my formal education

Master of Business Administration - MBA, Business Intelligence and Data AnalyticsCentro de Informática UFPE | 2024
Bachelor's degree, Business AdministrationUniversidade Federal de Pernambuco | 2020

About Me

João Lyra

I am a data analyst with extensive experience in the fields of mobile marketing, fraud prevention, and finance. My specialty lies in the ability to transform business challenges into data-driven solutions.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free