Daniel V. D. Silva
São Paulo
Summary
I am a data and analytics professional with over 14 years of IT experience, specializing in data modelling and architecture. I have delivered enterprise data models, dimensional and relational modelling, and data integration solutions across cloud platforms in industries such as telecom, finance, logistics, marketing, and healthcare. Skilled in SQL and NoSQL databases, metadata management, and data normalization, I focus on building scalable solutions that accelerate development, ensure governance, and create business value throughout the data lifecycle.
Overview
15
15
years of professional experience
Work History
Senior Data Engineer & Data Modeller
Tata Consultancy Services
07.2024 - Current
- Designed and implemented enterprise data models for healthcare services, applying dimensional modelling techniques and data normalization principles.
- Integrated data from SAP HANA, APIs, and Salesforce into unified models, ensuring metadata governance and data dictionary maintenance.
- Developed ETL/ELT processes with a strong focus on modelling best practices, contributing to the scalability of the company’s data platform framework.
- Collaborated on analytics projects by applying both relational and dimensional modelling approaches to healthcare and sales data.
- Managed metadata repositories and ensured effective data lifecycle management across AI and LLM applications.
- Designed data models optimized for both transactional and analytical workloads.
Senior Data Engineer
TechInsights
06.2023 - 07.2024
- Administered on-premise data model repository environment (Jedox/SQL Server) with comprehensive metadata management.
- Led migration of complex data models and repositories to a new analytics platform (Domo and AWS RDS Postgres), including schema redesign and optimization.
- Developed data integration solutions with emphasis on data normalization and enterprise data dictionary maintenance.
- Built automated data pipelines via SFTP and APIs using Python on AWS Lambda, ensuring reliable integration with analytical models.
- Managed metadata across the SaaS analytics platform (Domo), strengthening data lineage and governance.
- Technologies: SQL, PostgreSQL, MongoDB, Python (FastAPI, Pydantic, SQLAlchemy), AWS ECS/ECR/RDS.
Senior Data Engineer
A3Data
11.2022 - 03.2023
- Migrated a legacy data warehouse to a modern data lake, implementing the medallion architecture with dimensional modelling applied across layers.
- Designed and developed scalable ingestion pipelines using Spark and Delta Lake to support analytical workloads.
- Built comprehensive data models using both star and snowflake schemas to optimize reporting and analytics.
- Implemented metadata management processes to ensure lineage tracking and governance across the data lake.
- Orchestrated ETL pipelines with Apache Airflow on Kubernetes/AWS, ensuring data model integrity and reliability.
Analytics Engineer & Data Modeller
Leega
12.2021 - 06.2022
- Migrated 10+ ETL processes to BigQuery, redesigning data models using dimensional modelling principles.
- Implemented advanced SQL with CTEs and Window Functions for complex data transformations.
- Created and maintained data dictionaries and metadata documentation for all data models.
- Integrated NoSQL data sources (OpenStreetMap REST API) with relational models using Cloud Functions.
- Developed comprehensive technical documentation for data models, ETL processes, and metadata management.
Data Platform Engineer
Dotz
03.2021 - 12.2021
- Designed and implemented enterprise data models for a Big Data platform with focus on scalability and cross-cloud compatibility (AWS/GCP).
- Developed data profiling processes with PySpark and PyDeequ, capturing key metadata to support governance and quality.
- Built a framework for tracking data lineage and transformations, strengthening transparency across the data lifecycle.
Business Intelligence Engineer
Whirlpool Corporation
São Paulo
01.2019 - 02.2021
- Designed customized data collection models for visualization tasks using Alteryx.
- Developed company-wide dashboards in Tableau to share intelligence across business units.
- Responded to ad-hoc BI requests from Logistics and Trade teams, delivering tailored data packets.
- Built reverse ETL pipelines to power REST APIs, providing customers with real-time delivery updates.
BI Data Analyst
Banco Santander
São Paulo
01.2012 - 08.2017
- Migrated 10+ MS Access data flow processes to Alteryx, saving 50+ hours of manual work monthly.
- Designed an intuitive system for standardized data reporting in customer care.
- Prototyped and implemented a follow-up process that doubled Know Your Client (KYC) and Investment Suitability form completions.
- Produced 20+ reports on business performance and customer satisfaction, presenting findings to stakeholders.
- Collaborated with cross-functional teams to source, extract, and integrate data into delivery solutions.
Oracle DBA Intern
Vivo (Telefônica Brasil)
São Paulo
01.2011 - 06.2011
- Installed, configured, and managed Oracle databases in UNIX/Linux environments.
- Created and maintained roles, users, and access privileges.
- Monitored and analyzed database activity to prevent incidents and improve performance.
- Supported incident management processes for database operations.
Education
BS - Computer Science
Mackenzie Presbyterian University
01.2013
Core Skills
Data Modelling & Architecture: Dimensional Modelling, Relational Modelling, Data Normalization, Enterprise Data Model Design, Data Dictionary Management, Metadata Management, Data Lifecycle Management, ODS Implementation
Databases: SQL, Snowflake, BigQuery, AWS Redshift, SAP HANA, PostgreSQL, SQL Server, NoSQL/MongoDB
Data Engineering: Python, Apache Spark, ETL/ELT Process Design, Data Lakes, Data Integration, API Development, Apache Airflow, dbt, Data Pipeline Architecture
Cloud & Analytics: AWS, GCP, Snowflake, Databricks, Business Intelligence (BI), Domo, Tableau, Power BI, Py Notebooks
Languages
- English, Full Professional
- Portuguese, Native
- Spanish, Limited Working
Timeline
Senior Data Engineer & Data Modeller
Tata Consultancy Services
07.2024 - Current
Senior Data Engineer
TechInsights
06.2023 - 07.2024
Senior Data Engineer
A3Data
11.2022 - 03.2023
Analytics Engineer & Data Modeller
Leega
12.2021 - 06.2022
Data Platform Engineer
Dotz
03.2021 - 12.2021
Business Intelligence Engineer
Whirlpool Corporation
01.2019 - 02.2021
BI Data Analyst
Banco Santander
01.2012 - 08.2017
Oracle DBA Intern
Vivo (Telefônica Brasil)
01.2011 - 06.2011
BS - Computer Science
Mackenzie Presbyterian University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Paula Miranda AlbuquerquePaula Miranda Albuquerque
Attending Pediatric and Neonatal Anesthesiologist at Hospital das Clínicas and Instituto da Criança e do Adolescente of University of São PauloAttending Pediatric and Neonatal Anesthesiologist at Hospital das Clínicas and Instituto da Criança e do Adolescente of University of São Paulo