Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Leandro Carvalho Silva

Brasília,DF

Summary

Results-driven Data Engineer with over 9 years of proven experience in Business Intelligence, data modeling, ETL pipeline development, data warehousing, and cloud solutions. Recognized for leading complex projects from requirements gathering to the delivery of end-to-end data solutions in both on-premise and cloud environments.

Expert in Python, AWS (EC2, S3, RDS, Lambda, Glue, Athena), data pipeline orchestration with Apache Airflow, and Infrastructure as Code using Terraform and CloudFormation. Skilled in CI/CD for continuous data delivery and proficient in managing Oracle 12c, MySQL databases, and BI tools such as Oracle Data Integrator, Informatica PowerCenter, OBIEE, Power BI, and PowerDesigner.

Advanced expertise in developing dynamic, interactive dashboards and reports using Power BI, enabling data-driven decision-making across business units. Comfortable in Windows and Linux environments, with strong scripting and automation skills. Known for delivering scalable, high-performance data solutions with a strategic business focus.

Overview

12
12
years of professional experience

Work History

Data Engineer

CASTGroup
01.2016 - Current
  • Spearheaded the end-to-end development and upkeep of complex analytical projects focused on in-depth studies, research initiatives, and performance evaluations related to the Brazilian Educational System.
  • Played a pivotal role in the analysis and interpretation of data within the Integrated System of Financial Administration of the Federal Government (SIAFI) to derive valuable insights and drive data-informed decision-making.
  • Leveraged a comprehensive toolkit of Oracle technologies, including Oracle Database, Oracle Data Integrator (ODI), and Oracle Business Intelligence Enterprise Edition (OBIEE), to design and optimize data-driven solutions.
  • Developed and maintained interactive and visually compelling dashboards and reports using PowerBI, enhancing data visualization and making complex data more accessible for stakeholders.
  • Collaborated closely with cross-functional teams to identify data requirements, design data models, and implement ETL processes, ensuring data accuracy and consistency in analytical projects.
  • Acted as a subject matter expert in data integration and transformation, ensuring the seamless flow of data from disparate sources into a unified, structured format for analysis.
  • Assumed ownership of data quality and integrity, conducting data validation, cleaning, and transformation processes to mitigate errors and discrepancies in the datasets.
  • Designed and implemented data-driven solutions that provided actionable insights into the educational system's performance, leading to data-backed recommendations for improvement and decision-making.
  • Contributed to the development of key performance indicators (KPIs) and metrics to monitor the effectiveness and efficiency of educational programs and financial administration processes.
  • Collaborated with stakeholders to understand their data requirements, facilitating the creation of customized reports and analytics to address specific research and evaluation needs.
  • Maintained up-to-date documentation of data processes, data models, and report specifications to ensure clarity and ease of future reference for the team and other stakeholders.
  • Collaborated with cross-functional teams to define data requirements and specifications.
  • Implemented data governance practices ensuring compliance and security standards.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.

Data BI and DW Engineer

SEA Tecnologia
01.2015 - 01.2016
  • Spearheaded the development of multidimensional models, applying in-depth analytical insights to address complex challenges in the field of regulatory and sanitary control, both at the national and international levels.
  • Collaborated closely with Anvisa (the National Health Surveillance Agency) to provide valuable analytical inputs and recommendations for the regulation of sanitary control standards, ensuring compliance with both domestic and international regulations.
  • Conducted comprehensive business analysis to gain a deep understanding of the client's operational needs and objectives, establishing a foundation for the creation of highly effective multidimensional models.
  • Worked collaboratively with stakeholders to identify key performance indicators (KPIs) and metrics that are critical to the regulation of sanitary control, helping to align data-driven insights with regulatory standards.
  • Designed and implemented analytical solutions that harnessed multidimensional data models, enabling the extraction of actionable insights essential for improving regulatory processes.
  • Leveraged advanced analytical tools and techniques to evaluate data, monitor compliance, and recommend data-informed decisions that had a direct impact on regulatory processes.
  • Kept abreast of emerging trends and developments in the field of regulatory and sanitary control, ensuring that the solutions provided remained aligned with the latest industry best practices and global standards.
  • Actively contributed to the development of comprehensive reports, dashboards, and analytical insights that were instrumental in supporting the regulatory decision-making process.
  • Fostered a collaborative environment with the client and team members, ensuring the exchange of knowledge, insights, and expertise for the advancement of regulatory objectives.
  • Upheld the highest standards of data security, privacy, and compliance in the handling and analysis of sensitive regulatory data, in accordance with relevant national and international regulations.

Data BI and DW Engineer

CDS – Condominio De Soluções
01.2013 - 01.2015
  • Orchestrated the end-to-end development and maintenance of intricate ETL (Extract, Transform, Load) processes using Oracle Data Integrator (ODI), ensuring the seamless flow of data within a financial institution and across internal projects.
  • Skillfully prepared and curated visually engaging and insightful dashboards utilizing the OLAP (Online Analytical Processing) tool, OBIEE (Oracle Business Intelligence Enterprise Edition). These dashboards served as valuable decision support tools, providing critical insights into financial data and internal project performance.
  • Collaborated with cross-functional teams to understand data requirements, design ETL workflows, and implement data transformation processes. This ensured that data was cleansed, integrated, and structured appropriately for analysis and reporting.
  • Demonstrated expertise in maintaining data accuracy, integrity, and consistency throughout ETL processes, guaranteeing that financial institution data and internal project information were reliable for critical decision-making.
  • Actively engaged in the continuous improvement and enhancement of ETL processes, staying updated on emerging data engineering best practices and leveraging the full capabilities of Oracle Data Integrator to optimize data workflows.
  • Contributed to a data-driven culture by providing stakeholders with real-time access to meaningful information through OBIEE dashboards, empowering them to make informed decisions and improve financial strategies and internal project management.

Education

Bachelor’s Degree - Computer Science

UniCEUB
Brasilia

MBA – Business Intelligence - undefined

IESB
01.2018

MBA - CIÊNCIA DE DADOS E BIG DATA ANALITYCS

Cruzeiro Do Sul
Brasília, Federal District, Brazil
03-2025

Skills

  • MySQL, Python, AWS, Airflow, Data Engineering, ETL, Data modeling
  • SQL, PL/SQL, XML, Oracle Data Integrator, PowerCenter
  • Data governance
  • NoSQL databases
  • Data integration
  • Business intelligence
  • Data analytics
  • PowerBI

Timeline

Data Engineer

CASTGroup
01.2016 - Current

Data BI and DW Engineer

SEA Tecnologia
01.2015 - 01.2016

Data BI and DW Engineer

CDS – Condominio De Soluções
01.2013 - 01.2015

MBA – Business Intelligence - undefined

IESB

Bachelor’s Degree - Computer Science

UniCEUB

MBA - CIÊNCIA DE DADOS E BIG DATA ANALITYCS

Cruzeiro Do Sul

Similar Profiles

CREATE PROFILE
Leandro Carvalho Silva