11/07/2025 updated

**** ******** ****
100 % available

Data & Visualisation Specialist

Bingham, United Kingdom
Worldwide
MMaths Mathematics & Statistics, University of Oxford
Bingham, United Kingdom
Worldwide
MMaths Mathematics & Statistics, University of Oxford

Profile attachments

Benedict Dyer, Resume .pdf

Agile MethodologyAnalytic ApplicationsData AnalysisAutomationMicrosoft AzureBusiness Intelligence DevelopmentCloud ComputingData ValidationData GovernanceExtract Transform Load (ETL)Data TransformationData VisualizationData WarehousingDevOpsR (Programming Language)Python (Programming Language)PostgreSQLMicrosoft DynamicsMicrosoft VisioMicrosoft SQL ServersOnline Analytical ProcessingVisualizationQuality ManagementMicrosoft Power BISQL DatabasesSQL Server Reporting ServicesSQL Server Integration ServicesSalesforce TableauXPathData ProcessingMicrosoft Power AutomateSnowflakePowerqueryVba Programming LanguageQlikviewGDPRDatabase AdministrationKpi ReportingProgramming Languages
Business Intelligence Development
Advanced expertise in Power BI, GROW BI, and Tableau for creating comprehensive dashboards, data warehouses, and self-serve analytics solutions

Data Analysis and ETL
Proficient in SQL Server, SSIS, SSRS, Python, R, and PostgreSQL for complex data transformation, migration, and analytical processing

Data Visualization and Reporting
Skilled in creating executive dashboards, KPI tracking, and automated reporting systems using Power BI, Tableau, and QlikView

Microsoft Office Suite
Expert level proficiency in Excel VBA, Access, Dynamics 365, Power Automate, Power Platform, and Visio

Database Management
Experience with SQL Server, OLAP, Power Query, Snowflake, and data warehouse architecture

Programming Languages
Competent in PostgreSQL, Python, R, SQL, VBA, and XPath for data processing and automation

Cloud and DevOps
Knowledge of Azure DevOps, Agile methodologies, and cloud-based analytics solutions

Data Governance
Understanding of GDPR compliance, data validation, quality assurance, and enterprise-wide reporting standards

Experience

Professional experience10+ years
Freelancer since2023

Languages

EnglishNative speaker

Project history

Senior BI Analyst

MSC Direct
Architected new data warehouse model for seamless integration with ERP and Salesforce, standardised KPIs, designed OLAP cubes, implemented GROW BI customisation, launched AR dashboard and collections forecast, built inventory dashboard by recasting snapshot totals

BI & Data Analyst

TPT Retirement Solutions
Delivered real-time customer visibility reporting for inaugural front-end D2C platform, launched standards-aligned reporting suite on modern data warehouse, supported ops on ServiceNow and coordinated testing/approvals for clean production deployments

Senior Power BI Developer

Tokio Marine Kiln
Automated quarterly CEO & Board reporting packs reducing manual errors, built FCA Consumer Duty reporting regulatory requirements, led enterprise-wide data governance and reporting strategy, modernised the stack by replatforming on-prem SQL reporting to Snowflake

Temporary Senior BI Analyst

Brit Insurance
Delivered Power BI rollout for newly acquired department replacing legacy reports, enabled auto-monitoring of policy portfolios identifying sanctioned-country risks, worked in Agile using Azure DevOps maintaining full project visibility

Data Warehouse & Reporting Developer

Rate Validation Service Ltd
Replaced spreadsheet/VBA with cross-department Power BI suite enabling self-serve analytics, engineered SSIS pipelines for new data sources, defined reusable semantic models/patterns, partnered with stakeholders to troubleshoot data quality issues, designed VBA solution for client bespoke documents

Data & Analytics Specialist

CNA Hardy
Built and maintained executive Tableau dashboards for C-suite live views of premiums and core KPIs, standardised extraction/enrichment with SQL + Alteryx consolidating disparate sources, delivered rapid ad-hoc analyses and incident dashboards, partnered cross-functionally to integrate data and deliver complementary Power BI reports

Project Manager

iPipeline
Led multi-vendor programmes end-to-end coordinating launches, managed year-long legacy PAS migration as PM and lead analyst enforcing rigorous data validation, led team of three as lead analyst/PM on project awarded Best Individual Life Insurance Product, ran on-site training/workshops and product demos

Business & Systems Analyst

TCP LifeSystems
Delivered executive suites in Tableau & Power BI for premiums and core KPI visibility, standardised extraction/enrichment with SQL, Alteryx, and SSIS feeding central MI engine, architected 50-table 3NF interim store, advanced anonymisation procedures for GDPR compliance, coordinated third-party integrations and enforced single SIT/UAT go-live sign-off path

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in