Mojisola Peters
Vaughan,Canada
Summary
Data professional with over 5 years of experience in data engineering and data analysis across fintech and banking sectors. Skilled in building and automating reporting solutions,transforming complex datasets and delivering actionable insights while building scalable ETL pipelines, leveraging PySpark, AWS, Databricks, and Apache Airflow to deliver reliable, data solutions. Proficient in designing semantic data models and advanced analytics with Power BI and familiar with Tableau, ensuring data quality and improved efficiency through automation. Strong collaborator skilled in translating complex business requirements into actionable technical solutions. Core competencies include SQL, Python,Unix/Linux scripting cloud architecture (AWS), big data ecosystems, and end-to-end data lifecycle management with a proven record of delivering enterprise-wide projects and data products
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Data Engineer
Interswitch
03.2024 - Current
- Designed and deployed AWS Lambda functions integrating Amazon SQS with Databricks landing tables, reducing data ingestion latency by 30% and enabling real-time analytics.
- Automated data extraction pipelines from Oracle, MySQL, and MSSQL databases to AWS S3 and Delta Lake using Databricks notebooks, enhancing pipeline reliability and reducing manual workload by 40%.
- Migrated and refactored Airflow DAGs and associated scripts to transition from Snowflake to Databricks, optimizing ETL workflows, integrating Spark-based processing for enhanced performance, and ensuring smooth execution of data pipelines in the new environment while maintaining data integrity and scalability.
- Migrated legacy data processing scripts from Scala to PySpark, enhancing code maintainability and reducing processing times by up to 20%.
- Engineered automated PySpark data quality validation workflows comparing source data against MapRFS targets, incorporating quarantining and rolling 10-day retrospective checks, achieving improved data accuracy and completeness.
- Developed a centralized configuration system consolidating data paths, credentials, and environment settings, and created reusable Python modules for common tasks like data ingestion, partitioning, and data validation. This reduced development time by streamlining code reuse and enhancing team productivity.
- Created a unified logging framework for all PySpark pipelines, capturing key metrics such as execution times, data quality validation results, processing times, and error details, enabling proactive monitoring, faster troubleshooting, and audit readiness.Built and implemented a centralized logging framework across all PySpark pipelines, capturing execution metadata.
- Orchestrated batch workflows with Apache Airflow, building reusable DAG templates and setting up automated alerts and retries. This proactive monitoring cut operational incidents by 25% and ensured data was delivered to stakeholders on time.
- Built API-driven incremental data ingestion using Change Data Capture (CDC), replacing file-based workflows. This reduced data latency by 30% and improved freshness and accuracy of the data used for analytics.
- Developed interactive Power BI dashboards for real-time monitoring of transaction volumes, payment success rates, and fraud detection metrics, providing actionable insights for decision-making.
- Created DAX measures to calculate KPIs such as transaction success rates, customer acquisition costs, and monthly recurring revenue.
- Designed semantic data models in Power BI to integrate data from multiple payment systems, enabling cross-functional teams to track KPIs effectively.
- Automated daily and monthly adhoc-reporting processes using SQL and Python, ensuring that transaction data was consistently up-to-date for stakeholders.
- Patnered with business stakeholders to translate complex findings into clear data driven strategies for decision making
- Conducted regular code reviews to ensure quality control and maintain high standards of software development.
- Collaborated with cross-functional teams to define data requirements and establish best practices for data governance.
- Designed and implemented scalable data pipelines to support analytics and business intelligence initiatives.
- Optimized ETL processes, reducing data processing time and improving system performance.
- Developed and maintained interactive dashboards for real-time performance tracking across departments.
- Implemented automated reporting solutions that improved data retrieval speed and reduced manual errors.
Data Engineer
Access Bank Plc
04.2021 - 02.2024
- Managed Enterprise Data Warehouse(EDW) pipelines, supporting critical business intelligence and regulatory reporting.
- Developed optimized SQL queries, stored procedures, and views supporting 20+ Power BI dashboards and SSRS reports used bank-wide.
- Reduced manual report generation by 40% through cross-department collaboration and automation solutions.
- Implemented SSIS ETL packages for seamless integration of varied data sources into standardized data warehouse structures.
- Led initiatives to automate repetitive tasks, increasing overall team productivity and reducing manual errors.
- Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
Data Analyst
Access Bank Plc
04.2021 - 02.2024
- Built and maintained comprehensive Power BI dashboards tracking transactional KPIs, customer behavior, and operational metrics, driving informed business decisions.
- Created complex DAX measures and calculated columns to derive actionable insights, including customer segmentation, churn prediction, and revenue forecasting.
- Executed data cleaning, transformation, and validation processes for large, multi-source datasets ensuring integrity and consistency.
- Collaborated closely with business stakeholders to translate analytical findings into strategic recommendations, directly influencing marketing campaigns and product improvements.
- Automated data extraction and reporting workflows using SQL, SAS and Python, reducing manual report generation time by over 50%.
- Developed data governance documentation and analysis process guides, standardizing reporting procedures and improving cross-team collaboration.
Business Data Analyst
Access Bank Plc
04.2020 - 03.2021
- Conducted ad hoc analyses on diverse datasets and presented findings through storytelling and visualizations to senior management, supporting tactical and strategic planning.
- Built semantic data models integrating disparate systems to create unified views of customer behavior and financial transactions.
- Designed and implemented drill-through reports and interactive dashboards for operational teams, increasing user adoption and data accessibility.
- Created various SSIS packages to populate the data from Oracle and flat files into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction-based data).
- Used SSIS project deployment model and deployed the packages using incremental package deployment and used package parts to do custom logging and to reuse parts across all packages.
- Developed and automated SAS programs for processing large datasets, improving data processing efficiency by 30%
- Developed and automated reporting processes using SQL and Power BI, reducing report generation time by 50% and improving data accuracy.
- Collaborated with business team to design and deliver data management best practices,driving consistent reporting processes
Business Data Analyst
Access Bank Plc
04.2020 - 03.2021
- Collaborated with cross-functional teams to define and document comprehensive business requirements, focusing on data-driven solutions for the Compliance Unit and Internal Audit functions.
- Conducted detailed analysis to identify key problems, opportunities, and actionable solutions, ensuring alignment with strategic goals and regulatory standards.
- Prioritized technical and functional requirements for enterprise-wide data projects, including the successful rollout of the Enterprise Fraud Management Solution (EFMS) across all banking channels.
- Supported the development and refinement of requirements for multiple data-centric projects, enhancing data quality and operational efficiency in the Data Management Office
- Collaborated with cross-functional teams and senior stakeholders to gather requirements and deliver data-driven insights, improving decision-making and operational efficiency.
- Created and maintained Excel macros and advanced formulas to support data analysis and reporting needs.
- Led process improvement initiatives for data collection and validation workflows, resulting in a 20% increase in data quality and timeliness.
Digital Product Manager
Access Bank Plc
09.2018 - 03.2020
- Led the launch of Instant Business Loan (IBL), the first fully digital SME lending product, driving 120% growth in loan uptake within 3 months.
- Conducted market research and product analysis to identify opportunities for new lending products tailored to underserved segments.
- Worked with IT and Business teams to drive product enhancements, increasing customer retention by 15%.
- Leveraged data insights to improve loan products, reducing default rates by 15%.
- Led cross-functional teams to define product vision and roadmap for digital banking solutions.
- Conducted market research and user testing to inform product enhancements and drive user engagement.
- Collaborated with IT and design teams to optimize user experience and interface of digital platforms.
- Analyzed KPIs and customer feedback to refine product features and drive continuous improvement initiatives.
- Developed training materials for internal stakeholders to enhance understanding of new digital products.
- Facilitated workshops and brainstorming sessions to foster innovation in product development processes.
- Cultivated strategic partnerships with external vendors, leveraging complementary technology solutions to enhance overall product offerings.
- Enhanced product performance with thorough analysis of usage data, addressing pain points and areas for growth.
- Accelerated feature delivery timelines by breaking down complex tasks into manageable components, prioritizing resources based on impact potential.
- Analyzed customer behavior to derive digital product performance insights and identify areas of potential improvement.
- Drove customer retention through personalized content creation, targeted recommendations, and improved app navigation experiences.
- Spearheaded continuous improvement efforts by refining existing processes and introducing innovative solutions for digital products.
- Fostered a culture of collaboration among team members, promoting open communication and shared ownership of project outcomes.
- Developed data-driven strategies for enhancing product functionality and driving customer engagement.
Education
B.Sc. - Geology
University of Benin
Benin City01.2015
Skills
- SQL Development and Data Wrangling: advanced SQL for cleaning, transforming and analyzing large datasets
- Programming & Query Languages: Python, SQL, DAX, Unix/Linux scripting
- Big Data & Data Processing: Apache Spark, PySpark, Apache Airflow, Hadoop, MapR, SSIS
- Cloud & Infrastructure: AWS (Lambda, SQS, S3), Databricks, Azure Data Services
- Databases & Data Warehousing: Snowflake,SQL Server, Oracle, MySQL, Delta Lake
- Analytics & Visualization: Power BI, SSRS
- Version Control & Devops Git
- Data Integration & Management: ETL, CDC, APIs, Data Lakes, Data Warehouses, Data Quality, Data Governance
Certification
- Data Engineering with Microsoft Azure
- Udacity Data Analyst Nanodegree
- Programming for Data Science with Python Nanodegree
- AWS Certified Solutions Architect – Associate (in progress)
Core Competencies
Data Engineering | Data Analysis, | Product Management | Business Analysis | Data Modeling | Data Governance
Timeline
Senior Data Engineer
Interswitch
03.2024 - Current
Data Engineer
Access Bank Plc
04.2021 - 02.2024
Data Analyst
Access Bank Plc
04.2021 - 02.2024
Business Data Analyst
Access Bank Plc
04.2020 - 03.2021
Business Data Analyst
Access Bank Plc
04.2020 - 03.2021
Digital Product Manager
Access Bank Plc
09.2018 - 03.2020
B.Sc. - Geology
University of Benin