PEDRO HENRIQUE LINHARES FERNANDES
About
Detail
Analytics Engineer
São Paulo, State of São Paulo, Brazil
Résumé
Jobs
verified_user
0% verified
Senior Analytics EngineerAliceJun 2023 - Current (3 years 1 month)- Architected and developed company-wide data models covering key health and financial metrics, enabling unified and reliable analytics across teams. - Designed and maintained scalable ELT pipelines using dbt, Airflow, and Amazon Redshift, ensuring data consistency and traceability across multiple domains. - Collaborated closely with business, analytics, and engineering teams to translate domain needs into robust data structures and reusable transformations. - Led initiatives to improve data quality and performance, reducing pipeline execution times and standardizing data modeling practices. -Mentored junior engineers and contributed to best practices in documentation, testing, and CI/CD for data workflows. Focused on ensuring that the com- Analytics EngineerAliceOct 2022 - Jun 2023 (9 months)-Transitioned from data analytics to analytics engineering to help structure the company’s data foundation and automate key operational processes. -Developed and maintained dbt models supporting critical business domains, ensuring data consistency and scalability for analytics and reporting. Partnered with stakeholders from operations, finance, and product teams to identify data needs and translate them into reliable data models. Contributed to the modernization of the company’s data stack, helping establish version control, documentation standards, and good practices for analytics code. This role allowed me to bridge analytics and data engineering, deepening my skills in pipeline architecture, data modeling, and workflow orchestration.
- Business OperationsAliceJul 2021 - Sep 2022 (1 year 3 months)Responsible for the business KPIs and strategy on primary healthcare squads: Nutrition, Physical Activity and Psychology. Main projects: - Developed and implemented new model for Psychologists scheduling, reducing inneficient appointment slots by 16% and improving CSAT; - Developed and implemented model and automated process for health professionals variable payments using SQL, python and sheets script; This led to 19% reduction in monthly costs accross the 3 squads
- Business AnalystNubankSep 2020 - Jul 2021 (11 months)Analyst on Credit Strategy team, responsible for continuous improvement in our Valuation model and refactoring our Initial Credit Lines policy.
- LTransport Planning AnalystLOGITJan 2019 - May 2020 (1 year 5 months)Main projects: •Transport operational planning for 2019 Pan American Games: -Sport venues demand forecasting model - Design of different stakeholders' transport systems (athletes, judges, workforce and press) -Traffic and transport demand managing -Coordination of field team for monitoring operation •Urban mobility planning: -Mixed traffic/public transit microscopic simulation -Pedestrian accessibility microscopic simulation -Traffic safety analysis and policy planning -Active transportation network development
- LLogistics InternLOGITJan 2018 - Jan 2019 (1 year 1 month)Employee transportation optimization for 12 sugarcane mills located in the states of São Paulo and Minas Gerais.
Education
verified_user
0% verified
- Exchange Program, Civil and Environmental EngineeringUniversity of StrathclydeJan 2016 - Dec 2017 (2 years)International Exchange Program in association with University of São Paulo Main courses related to transport planning, financial modelling and water management
- Engineer's degree, Civil EngineerUniversidade de São PauloJan 2013 - Dec 2018 (6 years)•Award Ernesto Vargas Baptista for the best thesis focused in sustainability intituled "Demand on Public Transport at University of São Paulo (CUASO)" •Technological initiation project on Intelligent Transport Systems (ITS). Product delivered was a 5-step case study of Semaforic Coordination for Public Buses in a bus lane, using GPS datapoints and Microscopic traffic simulation.
- Engineer's degree, Civil EngineerUSP Universidade de São PauloJan 2013 - Dec 2018 (6 years)•Award Ernesto Vargas Baptista for the best thesis focused in sustainability intituled "Demand on Public Transport at University of São Paulo (CUASO)" •Technological initiation project on Intelligent Transport Systems (ITS). Product delivered was a 5-step case study of Semaforic Coordination for Public Buses in a bus lane, using GPS datapoints and Microscopic traffic simulation.
Projects (professional or personal)
verified_user
0% verified