Rafael Pires

Senior Data Engineer working on large-scale enterprise data platforms in a global consulting environment, delivering Azure-based solutions for analytics, reporting, and decision-making. • Designed and implemented end-to-end ETL and ELT pipelines using Azure Data Factory and Databricks (PySpark), processing millions of records daily • Built and maintained Lakehouse architectures with Delta Lake following Medallion Architecture (Bronze, Silver, Gold), improving data reliability and consumption • Developed and optimized analytical Data Warehouse solutions using Azure Synapse (Dedicated SQL Pool), supporting executive and operational reporting • Reduced data processing time by ~35% by optimizing Spark jobs, partitioning strategies, and data modeling • Enabled self-service BI by delivering curated datasets to analytics teams, supporting dashboards and ad-hoc analysis in Power BI • Implemented CI/CD pipelines and automated data validation using Azure DevOps, reducing deployment errors by ~40% • Acted as technical reference for data engineering, supporting and mentoring engineers across multiple projects • Collaborated with international teams and stakeholders across different regions and time zones

Senior Data Engineer and Tech Lead working on large-scale analytics and data platform initiatives in a consulting environment, supporting executive reporting and data-driven decision-making. • Designed and delivered ETL and ELT pipelines using Azure Data Factory and Databricks (PySpark), processing high-volume operational and analytical data • Built and maintained Lakehouse architectures using Delta Lake, enabling scalable analytics and self-service BI • Developed and optimized Data Warehouse solutions in Azure Synapse, supporting executive dashboards and recurring analytical reports • Led technical design and data modeling initiatives, improving data consistency and analytical performance • Supported real-time and near-real-time data ingestion using streaming pipelines, enabling faster access to operational insights • Reduced data availability time by ~30% by optimizing pipeline orchestration, data transformations, and storage strategies • Acted as Tech Lead, mentoring data engineers and analysts, conducting technical reviews, and defining best practices • Collaborated closely with stakeholders to translate business requirements into scalable data solutions

Senior Data Engineer and Tech Lead responsible for designing and delivering data platforms to support analytics, real-time monitoring, and predictive initiatives in the energy sector. • Designed and implemented ETL pipelines using Azure Data Factory and Databricks (PySpark) • Built Data Lake and Lakehouse architectures to store, process, and curate large volumes of operational data • Developed analytical Data Warehouse models to support financial and operational reporting • Implemented streaming data pipelines using Apache Kafka to ingest real-time sensor and telemetry data • Enabled data science initiatives by delivering high-quality, curated datasets for predictive modeling • Improved operational efficiency and decision-making, contributing to a business revenue increase of ~30% • Led technical discussions, data modeling, and architecture decisions across multiple initiatives

Tech Lead and Data Analyst working on enterprise BI and analytics initiatives, supporting data-driven decision-making across multiple business areas. • Led BI and analytics initiatives, acting as technical reference for data modeling, ETL processes, and reporting solutions • Designed and maintained analytical data models and enterprise reporting structures • Developed and supported ETL pipelines using SQL-based tools and enterprise data platforms • Built dashboards and analytical reports to support executive and operational decision-making • Supported production BI environments, ensuring data quality, reliability, and daily data availability • Improved reporting efficiency and data consistency, reducing manual analysis effort by ~30% • Worked closely with business stakeholders to translate analytical requirements into scalable BI solutions

Data Engineer and BI Analyst working on enterprise data warehouse and analytics projects across multiple industries. • Designed and implemented Data Warehouses and dimensional data models • Developed ETL processes using SQL Server Integration Services (SSIS) and Oracle-based tools • Built analytical dashboards and reporting solutions using Power BI • Supported enterprise BI environments, ensuring data quality, reliability, and performance

User support using the programs, essbase, add-in, Hyperion / Oracle, Financial Reporting Studio, SAP and also the FlashOnline system (Online Sales System).

Development of osklen's websites and its partners such as Jelly and New Order, using HTML, CSS, Javascript, PHP / MYSQL.