Oriyomi Solaja
Birmingham,West Midlands
Summary
Analytics-focused data professional with 5+ years building the layer between raw source systems and trusted business reporting. Designs dimensional models, builds SQL and dbt transformation layers, and ships cloud pipelines on AWS (Redshift, Glue, S3) and Azure (Synapse, Data Factory). Comfortable owning a dataset end to end — ingestion, modelling, testing, documentation, and the semantic layer that sits on top. Background in finance and audit gives strong instincts for data quality and what a number actually means to the business.
Overview
1
1
Certification
7
7
years of professional experience
Work history
Analytics Engineer
Balfour Beatty
2025.02 - Current
- Built AWS Glue ETL jobs ingesting finance data into Redshift, replacing manual daily downloads with scheduled pipeline and a single trusted source for finance reporting.
- Designed conceptual, logical and physical data models (star schema, facts and dimensions) across finance, sustainability, planning, asset and fleet domains
- Implemented data validation rules and exception tables that surface quality failures to data owners, turning ad-hoc issue reports into a monitored, repeatable process.
- Built Power BI semantic models using Redshift warehouse for plant and fleet reporting, enabling self-service analytics for operations teams.
- Maintained source-to-target mappings, data dictionaries and lineage documentation across ERP and CRM systems to keep the warehouse auditable.
- Facilitated discovery workshops to elicit business, functional, and data requirements, providing analytical advisory to senior stakeholders across finance, assets, and ground engineering domains.
- Defined data requirements, source systems and access controls for a generative-AI pile-design platform, including BPMN process flows and GDPR-compliant approval pathways.
- Collaborated closely with cross-functional teams to define technical requirements for new initiatives.
- Translated complex requirements into structured documentation — BRDs, user stories, process flows, wireframes, and data dictionaries — enabling cross-team alignment and faster delivery.
- Built and maintained data models for Fleet & Plant asset management domain in dbt Cloud with tests, documentation and incremental logic, using Jinja templating (ref and source) to create version-controlled, testable analytics layer over Redshift warehouse.
BI Developer
West Northamptonshire Council
2023.11 - 2025.01
- Delivered near real-time Power BI Service dashboards with row-level security, strengthening SLA tracking and operational visibility across critical council services
- Designed dimensional models (fact and dimension tables) for customer contact, waste collection and complaints data, improving query performance and trend analysis in Power BI.
- Developed end-to-end data ingestion pipelines in Azure Data Factory (ADF) to extract data from REST APIs, landing data into Azure Data Lake Storage Gen2
- Developed data quality reports that flagged bad records back to owning services, driving upstream fixes rather than downstream workarounds.
- Implemented ETL procedures to transform Job data from Azure Data lake to specific schemas in Planning data warehouse , improving data accuracy and consistency.
- Published governed semantic models to Power BI Service, cutting ad-hoc requests to BI team by enabling service leads to self-serve trusted data.
- Designed reusable data models that encoded approved business rules & transformation logic, enabling consistent reporting across teams
- Enhanced data visualisation by creating interactive Power BI dashboards and reports.
- Owned full report lifecycle from requirements, build, test, deploy, maintain — and reduced manual analysis time by 40% through automated reporting workflows.
- Developed scalable ETL/ELT transformations using PySpark and Spark SQL in Azure Databricks, processing 100 of thousands to million records daily
- Analysed complex data sets to enhance business performance.
- Led cross-functional team projects, fostering better collaboration and understanding.
- Implemented Medallion Architecture (Bronze, Silver, Gold layers) in Azure Databricks , standardising raw ingestion, cleansing, and business-ready aggregation across various source systems
Data analyst
Office Of Auditor General
2021.09 - 2023.10
- Wrote SQL to extract, join and transform large financial datasets across client systems for modelling and analysis.
- Built star-schema dimensional models supporting audit excel and power bi dashboards, revenue spend analysis and compliance monitoring
- Integrated API, CSV/Excel data sources into centralised cost datasets, improving data availability for analytics.
- Implemented validation and QA checks that reduced reporting discrepancies and improved stakeholder trust in published figures.
- Mitigated risks by identifying and resolving data discrepancies rapidly.
- Performed statistical analysis on tax billing datasets for gaining market knowledge.
- Created interactive dashboards using Power BI for easy data interpretation and presentation.
- Produced ERDs, data dictionaries and business glossaries aligning financial definitions across audit, IT and finance teams.
- Delivered analysis identifying cost leakage and process inefficiencies, supporting 3%+ annual savings
Junior data analyst
N.S SHO OIL & GAS
2021.01 - 2021.08
- Performed exploratory data analysis on large transactional datasets using Python (Pandas, NumPy) in Jupyter, surfacing patterns in customer behaviour and operational performance.
- Built Tableau dashboards with drill-through visuals using Production allocation data, and supported cash forecasting, performance reporting and long-range planning.
- Conducted detailed data analysis to identify trends and patterns in business performance.
Auditor
Airtel Telecoms
2019.11 - 2020.12
- Conducted financial audits and internal control assessments; identified control gaps and recommended improvements to strengthen financial governance.
- Built HR, budget and personnel reports in Excel and supported SQL database reporting across central data repositories.
Education
Bachelor of Science - Accounting
Caleb University
/2015 - /2019
Skills
Languages SQL (advanced), Python (Pandas, NumPy, PySpark), DAX, Power Query (M)
Transformation & Modelling dbt (models, tests, documentation, incremental), dimensional modelling (star schema, facts & dimensions, SCDs), conceptual/logical/physical modelling, medallion architecture
Cloud & Warehousing AWS (Redshift, Glue, S3, Athena, Aurora, Lambda), Azure (Synapse Analytics, Data Factory), Databricks
Pipelines & Orchestration ETL/ELT design, batch ingestion, API integration, AWS SAM, Azure DevOps CI/CD, Git
BI & Semantic Layer Power BI (semantic models, RLS, Power BI Service), Tableau, Excel
Data Practice Data quality frameworks & validation rules, source-to-target mapping, data lineage, data dictionaries, metadata & governance, GDPR
Certification
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Timeline
Analytics Engineer
Balfour Beatty
2025.02 - Current
BI Developer
West Northamptonshire Council
2023.11 - 2025.01
Data analyst
Office Of Auditor General
2021.09 - 2023.10
Junior data analyst
N.S SHO OIL & GAS
2021.01 - 2021.08
Auditor
Airtel Telecoms
2019.11 - 2020.12
Bachelor of Science - Accounting
Caleb University
/2015 - /2019