Hello i'mNicolas SilvaData Engineer / Data Analyst

About Me

Hi, I’m Nicolas Silva, a Data Engineer and Data Analyst based in Ireland. I specialize in Business Intelligence, Data Engineering, and Data Analysis.

Download Resume

Skills

My Skills and Experience
Data Modelling & Engineering
Data Warehouse
Data storage architecture for analytics
Star Schema
Simplified schema for fast queries
Snowflake Schema
Normalized schema for complex queries
BUS Matrix
Data architecture for dimensional models
ETL (Extract, Transform, Load)
Pentaho PDI
Data integration and ETL tool
SSIS
SQL Server Integration Services
Power Query
Data transformation tool in Excel/Power BI
Apache HOP
Open source data integration platform
T-SQL
Transact-SQL for database management
Apache Airflow
Workflow orchestration platform
Data Visualization
Power BI
Microsoft's data visualization tool
SSRS
SQL Server Reporting Services
Tableau
Interactive data visualization software
Google Data Studio
Google's dashboard and reporting tool
Zoho Analytics
Self-service BI and analytics platform
Metabase
Open source BI and analytics tool
Streamlit
Python-based web app framework for data apps
Plotly
Interactive graphing library
Dash
Framework for building analytical apps
Matplotlib
Plotting library for Python
Project Management
Azure DevOps
Cloud service for collaboration on code
Git
Version control system for tracking changes in source code
GitHub
Hosting platform for Git repositories
Agile & Scrum
Agile project management frameworks
Cloud
Azure
Microsoft's cloud computing service
AWS
Amazon Web Services
Google Cloud
Google's cloud computing service
Programming Languages & SQL
Python
High-level programming language
T-SQL
Transact-SQL for managing databases
DAX
Data Analysis Expressions for Power BI
Pandas
Data analysis library for Python
NumPy
Numerical computing library for Python
HTML
HyperText Markup Language for web development
CSS
Cascading Style Sheets for web styling
6Data Analyses (Years of experience)
4SQL (Years of experience)
3ETL (Years of experience)
2Python (Years of experience)

Education

Postgraduate in Business Intelligence and Analytics, with a background in Information Systems and Software Development.

01
Anhanguera University

Post graduate degree of Business Intelligence, Big Data and Analytics
2023- 2023

02
UNIP University

Higher Diploma of Information System and Software Development
2020- 2022

Education is not preparation
for life, education is life itself.

Employment

ICM Computer System LtdData Engineer2022 -Present

Experienced in SQL development, BI data solutions, and ETL processes. Played a critical role in designing and implementing the company’s first data warehouse. Developed a new Python-based web app to replace a legacy SSRS system, and am the leader of Data and Reports.

IT GoalData Analyst2021-2021

Responsible for creating reports, KPIs, and dashboards to enhance and monitor customer leads using tools like SQL, ETL, Power BI, and Google Data Studio. Also skilled in crafting presentations and employing advanced Excel, Zoho Analytics, and Agile methodologies.

TermobrastecData Analyst2018-2020

Developed a dashboard for visualizing operational and financial performance across 10+ locations in Brazil, leading to a 10% increase in service fees. The dashboard supports weekly, monthly, and annual comparisons, aiding ongoing financial and operational management.

PothimarManager2011-2018

Started as a maintenance assistant and advanced to manager, managing two locations with 20+ employees and significant revenue. Responsible for logistics of maintenance parts for 2,000+ containers monthly, financial oversight, and developing reports and dashboards for performance monitoring.

Awards provide powerful encouragement to keep improving, no matter who you are or where you are.

01
SQL
Certified Microsoft
02
Apache Airflow
Certified

Portfolio

Recent Blog

Apache Hop: An Open-Source Alternative to SSIS for ETL Workflows.
Transforming Data with Databricks: The Modern Data Platform for Innovation.