Image of Nicholas D.

Nicholas D.
Data Engineer

Sql
Python
Bio

With over four years of professional experience in the data field, a solid career path has been established with a focus on data engineering and business intelligence. The career commenced as a Business Intelligence Analyst, instrumental in structuring the data environment with a concentration on the Microsoft ecosystem to generate critical sales reports. Responsibilities included developing ETL processes while utilizing advanced tools like SQL Server, SQL Integration Services, SQL Analysis Services, and Power BI. These efforts involved direct participation in the evolution and optimization of processes, leading to enhanced agility and system improvements.

Subsequently, transitioning to a role as a Data Engineer entailed the creation of solutions centered on sales, customer acquisition, and retailer support. This role encompassed the creation and optimization of data pipelines by integrating various sources such as MongoDB, PostgreSQL, Amazon S3, and APIs via tools like Pentaho, Spark, Python, Prefect, and Airflow. This period also included leading the implementation of solutions, collaborating closely with internal teams and stakeholders to ensure the successful migration to BIGDATA environments using Airflow, Spark Hadoop, and Metabase, resulting in significant efficiency savings for the organization.

Contributions extended beyond technical responsibilities, encompassing leadership roles that involved close collaboration with multifunctional teams consistently driven towards innovation. Emphasizing effective solutions and operational excellence were key elements that positively impacted project success and enabled the organization to make strategic decisions based on precise data analysis.

  • Data Engineer
    8/1/2021 - 4/1/2024

    In the role of a data engineer, proactively designed solutions targeting sales segments, acquisition, and support for merchants. Responsibilities encompassed basic integrations to advanced BIGDATA solutions. Developed data pipelines consolidating various sources, including MongoDB, PostgreSQL, Amazon S3, and multiple APIs. Utilized tools such as Pentaho, Spark, and Python, using Prefect and Airflow for data processing and transformation into datasets. Played a significant role in developing dashboards with MicroStrategy and Metabase.

  • Business Intelligence Analyst
    11/1/2019 - 8/1/2021

    In the role of Business Intelligence Analyst, developed and structured the data environment utilizing Microsoft technologies, focusing on the sales sector. Managed ETL (Extract, Transform, Load) processes and generated comprehensive reports. Utilized advanced tools such as SQL Server, SQL Integration Services, SQL Analysis Services, and Power BI. Demonstrated proficiency in DAX for data analysis and visualization. Delivered a complete range of reports catering to both operational and managerial needs, ensuring data-driven decision-making across the organization.

  • Production Engineering at Western Paulista University
    2014 - 2018

  • Supply Chain Management at Maringá University
    2019 - 2020

  • Python 3 - World 1 at Curso em vídeo
    3/1/2024

  • Data Engineering for Analytics Bootcamp with AWS, Pentaho & Co. (Power BI, Qlik Sense, QuickSight, and Tableau) at Openin Big Data
    11/1/2021

  • Data Science: Analysis and Data Visualization at Alura
    3/1/2021

  • ETL Models: Pentaho Data Integration at Alura
    3/1/2021

  • Multidimensional Queries: MDX with SQL Server at Alura
    1/1/2021

  • Report Analysis with Power BI: Generating Business Reports at Alura
    12/1/2020

  • Power BI Desktop: Load, Analyze, and Visualize Data at Alura
    12/1/2020

  • ETL with Integration Services: Data Transformation at Alura
    11/1/2020

  • Git and Github: control and share your code at Alura
    10/1/2020

  • ETL with Integration Services: Data Model at Alura
    10/1/2020

  • Business Intelligence: Introduction to Business Intelligence at Alura
    10/1/2020

  • Power BI - Module 1 at Toledo Prudente Centro Universitário
    10/1/2019

  • Advanced Excel at SENAI - Serviço Nacional de Aprendizagem Industrial
    1/1/2019

Nicholas is available for hire

Hire Nicholas D.
Check icon

All Howdy Candidates are vetted for skills and english proficiency.

Related Articles