Data Engineer
AYOOLUWA JESUNIYI
Allco Insurance Plc.
Lagos,LA
5
years of professional experience
1
Certification
Summary
Results-driven Data Engineer with 4+ years of experience turning fragmented, siloed data into enterprise-grade intelligence that business teams can act on. At Allco Insurance, architected a Medallion data warehouse from scratch that slashed ETL processing time and eliminated data delivery downtime entirely. Expert in designing modular, tested transformation layers with dbt and BigQuery, orchestrating production workflows in Apache Airflow, and provisioning reproducible cloud infrastructure with Terraform on AWS. Combines deep database expertise across PostgreSQL, MSSQL and Oracle with modern DevOps practices — Docker containerisation, GitHub Actions CI/CD, and infrastructure as code — to deliver pipelines that are reliable, observable, and built to scale. Equally comfortable presenting insights to stakeholders in Tableau as building the warehouse that powers them.
Work History
Data Engineer
3 Years 9 Months- Designed a production-grade Medallion data warehouse (Bronze, Silver, Gold) from the ground up, delivering a single source of truth across the business and reducing ETL processing time by 75% — from 4+ hours to under 50 minutes — directly improving the speed and reliability of business reporting.
- Engineered end-to-end ETL/ELT pipelines integrating relational databases, REST APIs, and web applications into a centralised warehouse, eliminating data silos and enabling consistent, analysis-ready datasets across all business units.
- Deployed fully containerised environments using Docker to standardise Apache Airflow setup across development and production, drastically cutting onboarding and environment configuration time.
- Implemented infrastructure as code with Terraform and automated CI/CD workflows via GitHub Actions, ensuring every pipeline change is tested, version-controlled, and deployed with zero manual intervention.
- Built modular dbt transformation layers with automated data quality tests, enforcing high-fidelity outputs and reducing downstream errors that previously required manual correction.
- Mentored colleagues on analytics engineering best practices and data visualisation, raising the overall data literacy and self-service capability of the team.
Data Analyst
3 Months- Delivered end-to-end data analysis using Python (Pandas, NumPy, SQLAlchemy), translating raw datasets into structured insights that informed programme decisions.
- Automated data collection workflows using BeautifulSoup and Selenium, reducing manual data gathering effort and improving data freshness for ongoing analysis.
- Maintained version control and collaborative workflows through Git, supporting a distributed remote team.
- Remote
Data Quality Officer
6 Months- Streamlined high-volume service request workflows through Excel-based automation, eliminating manual verification steps and significantly reducing processing time for bulk tasks.
Education
Bachelor of Science - Finance
Skills
Metadata management
Data pipeline design
Big data processing
ETL development
Data quality assurance
Data pipeline control
NoSQL databases
Data warehousing
Data integration
Scripting languages
Data modeling
Data governance
Performance tuning
Certification
- Airflow Fundamentals — Apache Airflow
- Microsoft Azure Fundamentals (AZ-900)
Projects
- Mobility Analytics Platform | Link | BigQuery
- Dbt
- Airflow
- Airbyte
- GitHub, Implemented SCD Type 2 snapshots to accurately preserve driver state history at the point of each trip, enabling reliable fraud detection and regulatory audit trails., Automated financial intelligence tracking for net vs. gross margins and personal vs. corporate account splits, delivering self-service profitability insights to business stakeholders., Authored custom dbt data quality tests (e.g. no_negative_revenue) to enforce business logic at the transformation layer, preventing corrupt data from reaching dashboards.
- Supplychain360 — End-to-End Engineering Pipeline | Link | AWS
- BigQuery
- Terraform
- GitHub Actions, Built a multi-source ingestion pipeline using Airbyte (Docker) to consolidate data from Google Sheets, PostgreSQL, and S3 into BigQuery, creating a unified analytical layer for supply chain operations., Provisioned cloud infrastructure via Terraform, including S3 buckets with versioning, encryption, and lifecycle policies, ensuring secure, cost-optimised data storage., Orchestrated daily Airflow DAGs managing incremental dbt mart models, reducing compute costs while maintaining up-to-date operational reporting., Established a full CI/CD pipeline via GitHub Actions with automated testing on feature branches and gated production approvals, ensuring zero untested code reached the production warehouse.
Timeline
Data Engineer
Allco Insurance Plc.
01.2023 - Current
Data Analyst
ALX Africa
05.2022 - 08.2022
Data Quality Officer
Stanbic IBTC Bank
06.2021 - 12.2021
University of Lagos
Bachelor of Science from Finance