Lucas William da Silva

DataAnalyst / Data Scientist

Dev.Pro

Mar 2024 - Current (2 years 5 months)

Utilized Snowflake SQL for scalable data extraction, transformation, and analysis in support of reporting and analytics. Built well-structured data models using LookML, optimizing data pipelines and enhancing performance across Looker dashboards. Designed dynamic, stakeholder-oriented dashboards in Power BI, integrating advanced DAX calculations to deliver deep, customizable insights. Automated complex data workflows using Apache Airflow, improving data pipeline reliability and reducing latency across processes.

Data Engineer

A-Players

Nov 2022 - Nov 2023 (1 year 1 month)

Extracted, transformed, and analyzed large datasets using SQL, providing data-driven insights to guide business strategies. Mapped and integrated data from SAP ERP and JDE systems, ensuring consistency and alignment across enterprise platforms. Developed and optimized ETL pipelines with Pentaho to efficiently populate an AWS Redshift data warehouse, improving query performance and scalability. Built and maintained Power BI dashboards, incorporating DAX logic to support dynamic filters, calculated KPIs, and advanced metrics tailored to business needs.

DataAnalyst

Cirion Technologies

Jun 2022 - Nov 2022 (6 months)

Conducted in-depth SQL-based data analysis to uncover actionable insights from large and complex datasets. Designed interactive dashboards in Power BI, implementing complex DAX expressions to enable advanced reporting features such as custom time periods, conditional metrics, and dynamic aggregation. Collaborated closely with stakeholders to deliver tailored visualizations that aligned with strategic goals and operational performance.

I

DataAnalyst

ICL South America

Jan 2020 - May 2022 (2 years 5 months)

Led data gathering and model development initiatives using SQL to derive strategic insights for decision-makers. Developed interactive Power BI dashboards using complex DAX formulas to support business logic, dynamic scenarios, and in-depth performance analysis. Automated recurring processes with Power Automate, reducing manual effort and ensuring consistent report delivery. Implemented end-to-end data pipelines via Azure Data Factory to streamline data integration and transformation across systems. Partnered with business teams to translate needs into impactful dashboards, ensuring real-time data availability and usability.

N

Strategic Planning Intern

NSK Brazil

Jul 2018 - Mar 2019 (9 months)

Analyzed operational and sales data to support strategic planning and optimize production workflows. Led automation projects and implemented BI reporting solutions, significantly improving efficiency and reporting cadence. Created interactive dashboards in Power BI, integrating calculated columns and measures using DAX to support scenario analysis and key planning metrics.

Lucas William da Silva

About

Detail

Timeline

Résumé