Mid-Level Data Analyst @ BMW Group Official Partner Data analysis in the automotive sector across Brazil and Central/Latin America. Development of SQL queries (PrestoDB) to retrieve and manipulate data directly from AWS Athena's structured database. Analysis of data pipelines using AWS Glue, AWS DataBrew, and AWS Step Functions. Data storage using Amazon S3. Version control with Git (GitHub). Creation of interactive dashboards in Tableau and AWS QuickSight, including data preparation processes, multi-source maintenance, and versioning. Use of Python libraries for data manipulation and statistical analysis in Jupyter Notebook (Pandas, NumPy, Sci-kit Learn, Matplotlib), as well as interactions with the AWS SDK interface (boto3). Use of Windows Linux Subsystem (WSL) and Unix Bash for system interactions. e-HUB Leader @ Zallpy Requirements gathering for projects in the North America operation, involving teams from various sectors and diverse clients (Discord and Microsoft Teams). Creation and segmentation of operational and strategic intervention tasks for operational teams (ClickUp). Stakeholder alignment. Supervision of activity progress.

BEMOBI | Jul 2022 - Apr 2024

Junior Data Analyst

Development of SQL queries for retrieving and manipulating data directly from the structured Redshift database (AWS) and Spark. Construction of Directed Acyclic Graphs (DAGs) in Apache Airflow to feed specific informational data on demand. Version control using Git (Atlassian Bitbucket). Creation of interactive dashboards in Tableau, Looker, and Looker Studio, including processes for data preparation, maintenance of multiple sources, and versioning. Use of Python libraries for data manipulation and statistical analysis in Jupyter Notebook (Pandas, NumPy, Sci-kit Learn, Matplotlib). Implementation of K-Means clustering along with the RFM+A clustering model for customer segmentation. Additionally, conducted chargeback analyses related to the Utilities product.

Vivadí | Oct 2021 - Dec 2022

Data Analyst

Worked as a Data Analyst with a focus on creating and evaluating objective psychometric instruments in a survey model for measuring Socioemotional Skills. I analyzed data from assessment processes built within the survey tool itself, using SQL queries to structured databases (PostgreSQL). Data visualizations were created using Looker Studio, and inferential investigations were conducted using the R statistical programming language. Additionally, I contributed to the User Journey process, participated in the development of pedagogical and informational content for the application, and conducted meetings with clients to explain the assessment process of the developed instruments.

UNIVERITAS | Feb 2022 - Aug 2022

Auxiliary Teacher

Courses Ministred: - Learning and Development Psychology - Biostatistics - Objective Testing 1

Celso Lisboa University Centre | Aug 2018 - Jul 2022

Auxiliary Teacher

Undergraduate Auxiliary Teacher at Psychology Department: Ministered Courses: - Psychometrics - Statistics I & II - Objective Tests - Psychological Evaluation

Iniciativa FIS | Mar 2021 - Oct 2021

Data Analyst

Design and construct data collection questionnaires via SurveyMonkey to assess audience characteristics for persona building, business intelligence (BI), and other institutional research. Develop Ecological and Non-Ecological data collection strategies and boost questionnaire via social media (Facebook and Instagram). Build a dashboard on Looker Studio to track metrics, KPIs, and other vital information.

VOA Education | Sep 2020 - Oct 2021

Data Analyst

Assisted in developing a self-assessment instrument for Socioemotional Skills (HSE) targeted at high school students and the second segment of Elementary School. Constructed Constitutive and Operational definitions for VOA Methodology's measurement instruments. Refined the hetero-relate instrument for HSE teachers. Utilized Z-Scores to create flag heuristics for identifying children in need of attention in HSE development. Reviewed and integrated technical-scientific material to support measurement and methodological work. Conducted advanced Exploratory and Confirmatory Factor Analysis, instrument refinement, and Structural Equation Modeling. Employed PostgreSQL queries in Azure Cloud using TablePlus. Created and maintained dashboards and data sources using Looker Studio for Key Performance Indicators (KPIs), user metrics, and other information. Utilized the R Programming Language for problem-solving in business, including data exploration, cleaning, transformation, and exporting in .csv format.

FutureME | Oct 2020 - Sep 2021

Data Analyst

Adaptation and validation of major self-report assessment instruments for BIG5 Personality Theory and Holland's Vocational Interests model (RIASEC) using the public domain item base of IPIP. Construction of the Vocational/Professional Orientation Journey, including psychometric assessment instruments and evaluation dynamics based on literature and gold-standard instruments. Conduct interviews for pilot application of psychometric instruments and investigation of user UX and Design attributions. Perform advanced Exploratory and Confirmatory Factor Analysis, instrument refinement, and Structural Equation Modeling.

Barkus Educational | May 2019 - May 2020

Data Analyst

Worked as a Data Analyst with a focus on creating and evaluating psychometric instruments in a survey model for measuring Personality, Financial Literacy, and Delay of Gratification. Also worked on constructing educational material for elementary school students on Financial Education.

Humanidados | Dec 2017 - Jan 2020

Owner Partner

N/A

My Education

Take a look at my formal education

phD in Data Science & Artificial IntelligenceUniversidade Federal do Estado do Rio de Janeiro | 2028

BSc. in StatisticsCentro Universitário FMU | FIAM-FAAM | 2027

Associate Degree in DatabasesFIAP | 2022

Master Degree in Statistics applied to PsychologyUFRJ - Universidade Federal do Rio de Janeiro | 2020

BSc. in PsychologyUFRJ - Universidade Federal do Rio de Janeiro | 2017

About Me

Gabriel hasn't filled in a bio text

Create Your Data Portfolio for Free