Data Engineer and Business Intelligence Developer with 7+ years’ experience delivering end-to-end solutions across SQL Server and Microsoft Fabric. Specialist in building scalable Lakehouse and Data Warehouse platforms using medallion architecture, ETL/ELT pipelines and dimensional modelling, with a focus on performance, maintainability and rapid delivery. Proven track record of delivering enterprise reporting solutions in Power BI and SSRS, supporting 1,000+ users across public sector and commercial organisations.
Notice period: Immediate
Experience
Career history
Business Intelligence Developer ·Private company
• Led the design and migration of the entire data estate from on premises to Microsoft Fabric using medallion architecture (Bronze/Silver/Gold). • Designed ETL/ELT pipelines, improving performance and enabling accurate reporting for 1,000+ academic and operational users. • Built a dimensional data warehouse, establishing a single source of truth for reporting and analysis. • Delivered statutory and executive reporting in Power BI and SSRS, covering metrics such as funding, Ofsted, UCAS, performance review, achievement, attendance, teaching quality and student satisfaction. • Eliminated the need for 100+ ad hoc requests per year by designing a student survey cohort framework that protected data integrity and prevented manipulation of KPIs. • Led cross-department analytical investigations identifying drivers of student performance. • Mentored junior team members and led structured knowledge-transfer sessions.
Data Analyst ·Private company
• Developed Power BI dashboards monitoring adult social care KPIs for senior stakeholders. • Gathered requirements directly from service managers and translated into scalable reporting models. • Supported migration to a new source system, validating data integrity and redesigning reporting structures. • Managed report subscriptions, security roles and workspace governance.
Business Intelligence Developer ·Private company
• Generated datasets in T-SQL and developed reports using SSRS, Crystal Reports and Report Builder. • Managed 1000+ scheduled SSRS reports, including executive summaries, emissions, turnover, booking summaries and invoices. • Identified inefficiencies in ticketing workflows, contributing to £500+ additional daily revenue. • Conducted a thorough audit of reporting services in accordance with GDPR/ISO standards. • Monitored SQL Server performance, backups and agent jobs.
Education
Learning history
Private institution
BSc, Physics
• Final-year project: Monte Carlo simulation and regression modelling of financial time series. • 91% in computational Theoretical Physics module (MATLAB modelling of nonlinear systems).
FreeCashTracker.com
Created a full-stack personal finance web application in Django (Python), React and PostgreSQL which allows users to track their net worth over time by submitting…