Kayode Oyerinde

Kayode Oyerinde

Data Engineer
Canada
Full-time Remote

About Me

Experienced Data Engineer with 9+ years designing and optimizing enterprise data warehouses, improving reporting efficiency and data accuracy by 35%. Built and automated ETL pipelines using Azure Data Factory, SSIS, and …

Experience

Data Engineer

Centennial Optical Limited · Buckingham , Ontario , Canada
Aug 2019 - Present · 7 years 2 months

<p>Managed SQL Server data warehouses, ensuring reliable reporting and 99% system availability.</p><p> Built ETL pipelines with Azure Data Factory and PySpark, reducing processing time by 40%.</p><p> Designed star schema models in Azure Synapse, improving query speed by 35%.</p><p> Optimized stored procedures and indexing strategies, reducing query latency by 30%.</p><p> Led cloud migration from SSIS to Azure Data Factory, improving scalability by 45%.</p><p> Developed data validation scripts using Python and SQL, improving data accuracy by 25%.</p><p> Collaborated with analysts and stakeholders, delivering scalable data solutions on time.</p>

Business Intelligence Analyst

VSF Consulting Inc · Adstock , Ontario , Canada
Jul 2018 - Jul 2019 · 1 year

<p>Designed enterprise data warehouses using SQL Server and Azure Synapse, improving data access by 35%.</p><p> Built interactive dashboards in Power BI and Tableau, supporting executives and improving decisions by 40%.</p><p> Developed ETL workflows with SSIS and SQL, ensuring data accuracy and reducing errors by 30%.</p><p> Modeled tabular solutions in SSAS using DAX, enabling analysts to improve forecasting accuracy by 25%.</p><p> Collaborated with stakeholders to define KPIs and deliver scalable BI solutions on schedule.</p><p> Optimized report performance using indexing and incremental loads, reducing refresh time by 45%.</p>

Senior Business Intelligence Analyst

Quest Advisory Services Limited · Acton , Ontario , Canada
May 2016 - Jun 2018 · 2 years 1 month

<p>Gathered business requirements using use cases and workshops, improving stakeholder alignment by 35%.</p><p> Engaged stakeholders using opportunity matrix, ensuring smooth EDW process integration.</p><p> Created SSIS ETL packages, loading operational data into EDW with 99% accuracy.</p><p> Implemented control frameworks and conformed dimensions, improving warehouse consistency by 30%.</p><p> Applied slowly changing dimensions, preserving legacy data history with full integrity.</p><p> Developed Power BI and Tableau dashboards, improving KPI visibility and decision speed by 40%.</p>

Business Intelligence Analyst

Albert and Benjamin Ross · Acton , Ontario , Canada
May 2013 - Apr 2016 · 2 years 11 months

<p>Developed SSIS packages using Lookup and SCD, improving ETL efficiency by 35%.</p><p> Implemented SSRS lifecycle processes, delivering reliable reports and improving user access by 30%.</p><p> Created dashboards in Tableau and Power BI, improving business decision speed by 40%.</p><p> Built standardized KPI dashboards, strengthening financial transparency by 25%.</p><p> Designed user-friendly reports in SSRS and Power BI, improving staff productivity by 30%.</p>

Skills

SSIS Azure Data Factory Azure Databricks Python PySpark Power BI SSRS Tableau MicroStrategy SAS Jet Reports T-SQL Teradata DAX VBA Azure Data Lake Azure Blob Storage Azure Synapse Microsoft Fabric Requirement Gathering Stakeholder Communication Agile Methodologies SQL Server Data Modeling Query Optimization Multi-Dimensional Cubes Tabular Models KPI Dashboards
Report this Profile?