Mamoke A

Data Engineer

Santander UK • Tiempo completo

Jan 2026 - Present • 4 mos

- Implemented analyst‑requested data‑filtering features by developing new AWS‑based data columns and writing optimised SQL/CTE logic, then deploying production‑ready code into enterprise data pipelines. - Processed Jira tickets end‑to‑end, translating business requirements into scalable data engineering tasks across AWS, Hadoop, and internal data platforms. - Performed data‑quality validation on PEGA DataFrames using Hadoop and AWS datasets, ensuring accuracy, completeness, and alignment with governance and compliance standards. - Built automated ingestion workflows using Power Automate to replace manual email‑attachment processing, enabling automatic extraction, SharePoint upload, and downstream pipeline triggers. - Designed file‑lifecycle automation (archiving, monitoring, movement of processed files) using Power Automate, reducing operational overhead and improving reliability of document‑driven data flows. - Collaborated with analysts, data teams, and stakeholders to refine requirements, optimise SQL logic, and deliver scalable, maintainable data solutions. - Contributed to production stability by applying robust testing, documentation, and version‑control practices across AWS and Hadoop environments.

Data Analyst

Nordea Bank • Tiempo completo

May 2024 - Dec 2025 • 1 yr 7 mos

• Optimized statistical sampling models using hypergeometric distribution, reducing quarterly sample sizes from 182 to 121 and cutting FTE workload by 30% while maintaining full investigator coverage. • Automated ETL pipeline for transactional data using SQL (ODBC), Hadoop, Power Automate, and Power Query — reducing processing time by 50% (4 hrs → 2 hrs). • Migrated the sampling process from SQL to Python, using pyodbc to extract data, pandas for cleaning and transformation, and Excel export for seamless integration into SharePoint Lists via Power Automate — improving data quality, accuracy, and extraction speed by 50% (2 hrs → 1 hr). • Designed a Python script combining for loops, if statements, os for directory access, and pandas to merge multiple files into a unified production transaction dataset for correspondent banking — allowing data to be collated into one place instead of scattered files, significantly improving efficiency and cross-functional accessibility. • Designed advanced Excel review framework with Power Query and complex formulas, streamlining data validation and quality assurance. • Developed Power BI dashboards for KPI monitoring and automated quarterly reporting using DAX, Excel, and Power Query — enhancing reporting accuracy and timeliness. • Implemented a secure centralized data warehouse (Hive + SharePoint integration), improving governance, access control, and compliance reporting. • Led development of scalable data models to support sampling logic, investigator coverage forecasting, and operational reporting — aligned with statistical rigor and compliance requirements. • Built a dynamic capacity planning tool that provided stakeholders with visibility into quarterly, monthly, and weekly FTE requirements — enabling proactive resource allocation and improved operational efficiency. • - Delivered monthly and quarterly reports to cross-functional stakeholders, translating complex data into actionable insights for compliance, operations, and lea

Graduate Data Analyst (BUK CISO)

Barclays UK • Tiempo completo

Oct 2022 - Apr 2024 • 1 yr 6 mos

Reduced medium-severity flaws by 25% (20,000 → 15,000) and increased cyber compliance from 90% → 98% by implementing mitigation plans, collaborating with stakeholders, and building Tableau/Excel dashboards for vulnerability tracking. Enhanced visibility of cyber flaws by automating Tableau dashboards, creating intuitive Excel tools, and delivering weekly security reports and analyses to key teams.