Albus Business Intelligence | DatoData Analyst
Mar. 2022 - Jul. 2023Blumenau, Santa Catarina, Brasil- Developed dashboards for various business areas, focusing on production and accounting to provide a comprehensive view of operations.
- Executed complex ETL processes using Power Query, SQL Server, and REST APIs for data integration, reducing query load and optimizing performance.
- Modeled data to accelerate queries from multiple sources, including SQL, Excel, OracleDB, MySQL, and APIs.
- Automated production reports for TV display with scheduled updates using Power Automate, ensuring data refresh every 5 minutes.
- Applied advanced DAX modeling to calculate custom metrics, enhancing analytical capabilities and delivering reliable insights, especially for non-technical users.
- Collaborated with business teams in alignment meetings to deliver data visualization–driven solutions tailored to operational needs.