Shola Dada
Verified Expert in Engineering
Data Engineer and Developer
Lagos, Nigeria
Toptal member since September 16, 2022
Shola is a senior data engineer with over five years of experience in banking, finance, advertising, and media. His expertise revolves around designing robust data pipelines and data warehouses on-prem and cloud. Shola is highly skilled in several out-of-the-box ETL/ELT tools, such as ODI, SSIS, and Talend, and is fluent in SQL, Python, and PySpark.
Portfolio
Experience
- SQL - 7 years
- Oracle - 5 years
- PL/SQL - 5 years
- Data Warehousing - 5 years
- Data Engineering - 4 years
- Azure Data Factory (ADF) - 3 years
- Python - 3 years
- PySpark - 2 years
Availability
Preferred Environment
Anaconda, SQL, PL/SQL, Oracle, PostgreSQL, Azure Data Factory (ADF), MySQL, Python, Talend, PySpark
The most amazing...
...pipeline I've designed is a rule-based profiling pipeline engine that prequalifies customer salaries for mobile loan applications.
Work Experience
Artificial Intelligence and Business Intelligence Specialist
Intelfort
- Designed and deployed data pipelines for a chatbot using Azure Synapse.
- Orchestrated and deployed workflows using Power Automate to integrate data input for an AI chatbot.
- Reviewed the data maturity for several clients and helped benchmark potential growth areas, leading to a conversion of two of the clients.
SSRS Reports Developer
Syngenta
- Developed and deployed new reports according to the specifications of Figma templates.
- Tracked and fixed bugs using Jira as a reporting tool.
- Redesigned, optimized, and deployed over 25 dashboard reports that accommodated more workloads and report TAT.
Data Engineer
Ringier
- Developed and improved an ontology object, namely a data dictionary that monitors all relevant attributes in the advertising section.
- Tracked and fixed bugs in the pipelines. Conducted analysis using Jira.
- Integrated a new data source, Yieldlove, into the enterprise data warehouse.
- Participated in the GAM (Google Ad manager) migration.
Data Engineer and Data Analyst
UBA Group
- Designed a rule-based profiling pipeline that prequalified income earners for loans, ramping to over 10 billion Nigerian nairas within a year of product launch.
- Created data pipeline APIs and packages for integration with the core banking system. It is the main data API for onboarding new customers on the platform, with over 1 million customers onboarded within two months of launching the product.
- Designed and automated a compliance streaming data pipeline, with daily data transmissions of over 20 million records, ensuring regulatory compliance.
- Designed and deployed data pipelines using Azure ADF/ Synapse for customer risk and customer churn model. Averted approximately 75% loss of the predicted churn customers.
- Designed and migrated low and non-infraction data workload and data pipelines of the data warehouse to Azure.
Business Intelligence Developer and Analyst
Guaranty Trust Bank
- Managed, maintained, reviewed, and ensured optimal execution of already developed ETL pipelines and workflows and designed new data pipelines and workflows per business needs.
- Designed dashboards and reports for several business units, measuring several metrics and performance.
- Managed, maintained, and monitored all business intelligence platforms to ensure 100% uptime availability for users.
- Revamped and designed data pipelines for migrating the on-premise CRM suite to the cloud.
IT Intern
Fast Data Nigeria Limited
- Managed and maintained the firm's network and ensured the uptime of systems and applications.
- Provided support for all OMR machines and performed regular tests and checks.
- Designed and developed graphic walkthrough documentation.
Experience
ClickCredit
Automated Collection System for UBA and CBN
CBN Industry Data Harmonization
UBA Open Digital Banking Platform
Education
Bachelor of Science Degree in Computer Science
University of Ibadan - Ibadan, Nigeria
Certifications
Data Engineering on Microsoft Azure
Microsoft
Skills
Libraries/APIs
PySpark
Tools
Microsoft Power BI, Microsoft Report Builder, Spyder, Slack, Spark SQL, Power Query, GIS
Paradigms
ETL, Automation
Platforms
Windows, Azure, MacOS, Anaconda, Oracle, Oracle Data Integrator (ODI), Talend, Azure Synapse, Linux, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Amazon Web Services (AWS), Power Automate Cloud Flow, Microsoft Copilot Studio
Storage
PL/SQL, SQL Server Reporting Services (SSRS), Data Pipelines, Microsoft SQL Server, Oracle PL/SQL, MySQL, Databases, PostgreSQL, SQL Server Integration Services (SSIS), Azure Storage, SQL Server 2019
Languages
SQL, Python, Scala, T-SQL (Transact-SQL)
Frameworks
Ontology Framework, Spark
Other
Azure Data Factory (ADF), Data Engineering, Data Warehousing, Data Preparation, Pipelines, Data Analysis, Excel 365, Enterprise Resource Planning (ERP), Data Structures, Azure Data Lake, DAX, Data Visualization, Azure Databricks, Networking, Optical Character Recognition (OCR), Foundry, Data Lineage, SSRS Reports, Dashboards, Data Modeling, Data Processing, Oracle Apps
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring