Badges
Certifications
jcarnicelli has not earned any certificates yet.
Work Experience
Data Developer
Four Eyes Financial•  November 2023 - Present•  Saint John, Canada
1. Developed and optimized database functions to integrate data with the application, ensuring efficient queries and rapid response times. 2. Created GraphQL API components to access and deliver requested data, enhancing its accessibility and flexibility. 3. Implemented ETL processes using Python and SQL to retrieve, clean, model, and save data according to project requirements. 4. Maintained concise documentation to facilitate future collaboration among team members.
Data Engineer
Dynamicly•  January 2022 - November 2023•  Montreal, Canada
1. Designed and implemented scalable data models to optimize data flow, ensuring high performance and efficient data consumption, while reducing costs and maintenance efforts. 2. Extracted raw data from various sources, including relational and non-relational databases, REST APIs, and cloud storage, to process and load it for further consumption. 3. Developed, tested, and monitored data pipelines to ensure seamless integration with reports, databases, and applications. 4. Utilized DAX and Python to generate metrics and KPIs, facilitating the creation of insightful reports for applications. 5. Conducted client meetings to clarify project requirements and actively contributed to the development of functional specifications. Additionally, engaged in validation processes to ensure the smooth and efficient execution of the projects.
Data Engineer
Mouts IT•  February 2021 - December 2021•  São Paulo, Brazil
1. Designed and created robust data models for the company's data warehouse, ensuring scalability and availability while optimizing cloud costs. 2. Elaborated and validated data pipelines to efficiently feed the data warehouse, ensuring seamless data flow and reliable information. 3. Proficiently debugged and optimized data models and metrics for reports and dashboards, resulting in faster loading times for Power BI visualizations and improved data accuracy. 4. Leveraged DAX to generate metrics and facilitate the creation of compelling visuals in Power BI. 5. Collaborated closely with the team, providing expertise in PySpark, as the technology was new to most members during the company's technology stack migration.
Data Engineer
Via•  July 2020 - February 2021•  São Caetano do Sul, Brazil
1. Developed and maintained efficient data pipelines and ETL processes to automate report generation, routine tasks, and metrics calculation. 2. Successfully migrated processes from SAS to Databricks, enhancing efficiency and correcting unnoticed business logic errors. 3. Designed and tested new databases and analytical base tables (ABT) to facilitate data analysis. 4. Provided support to business analysis and data science teams, addressing their ad hoc demands.
Education
Universidade de São Paulo
Computer Information Systems, BS•  February 2016 - December 2020