Daniel S. Email & Phone Number

Ottawa, Canada · Remote

- Administered on-premise data model repository environment (Jedox/SQL Server).- Migration of data models and repositories from on-premise platform (Jedox/SQL Server) to new analytics platform (Domo and AWS RDS Postgres).- Developed data integration solutions using APIs to improve report updating processes for stakeholders (data analysts). - Frontend.

Brazil

- Migrated legacy data warehouse system to a new well-structured data lake, using the medallion architecture (layers raw, bronze, silver, and gold) with Spark as the data processing engine and persisting tables in Delta Lake format.- Orchestrated ETL pipelines using Apache Airflow and ran them on a Kubernetes cluster on the AWS cloud, ensuring data feeds.

Remote

- Migrated 10+ ETL built previously in Tableau Prep to data models in BigQuery using SQL (CTEs + Analytic/Window Functions + dbt) orchestrated in Apache Airflow (Cloud Composer).- Improved accuracy of internal address database by integrating geolocation services (OpenStreetMap REST API) using Cloud Functions and Python.- Drafted technical documentation for.

Remote

- Supported the design, building, test and maintenance of Dotz's Big Data and Advanced Analytics platform.- Developed data profiling using PySpark and PyDeequ (AWS Open Source Lib).- Built integration with SFTP servers using Python, Apache Airflow and Secret Manager.- Built pipeline to extract, cryptography and transport data inter-cloud (Azure Blob.

São Paulo, Brasil

- Designed customized data collection models for specific visualization tasks, using Alteryx.- Developed intelligence-sharing dashboards using Tableau, providing company-wide access to collected data.- Responded to specific BI requests from Logistics and Trade personnel, creating data packets with requested information in easily understandable formats..

São Paulo, Brazil

- Migrated over 10 MS Access data flow processes to Alteryx, saving 50+ hours of manual work every month. - Developed an intuitive system for standardized data reporting in customer care.- Prototyped and later implemented a follow-up process that doubled the number of Know Your Client (KYC) and Investment Suitability form fulfillments.- Produced over 20.

São Paulo, Brasil

- Installed, configured, and managed databases in UNIX/Linux environments.- Created roles and users and managed their privileges.- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.- Participated in situation management of incidents to support database operations.