Skills and Services

Technical Skills:
  • Power BI – building data models, dashboards, DAX columns, and measures
  • VBA (Excel & Access) – creating financial models, reports, and automation workflows
  • Python scripting – for data analysis and ETL processing
  • Streamlit app development – building interactive dashboards linked to databases, CSVs, and dynamic charts
  • SQL Server – designing databases, creating tables, views, stored procedures; optimising queries with indexing and statistics
  • ETL pipeline design – from manual scripts to cloud-based workflows (Azure Data Factory)
  • Relational database design – using transactional and star schema models
  • Excel-based MI tools – leveraging pivot tables, charts, and VBA-driven forms
  • Microsoft Access – supporting legacy systems: building tables, queries, forms, reports, and exporting to Excel
Business Skills:
  • Understanding of finance & operations – experience with financial models, MI reporting, and business intelligence
  • Knowledge of the trade lifecycle – from trade execution through to settlement
  • Insurance business knowledge – familiar with premiums, claims processing, and actuarial models used for pricing and reserving
  • Business engagement – confident and collaborative when working with both technical teams and business users to shape outcomes
  • Process improvement – skilled at identifying inefficiencies and building tools to streamline and automate workflows
  • Agile delivery – experienced in sprint-based environments, balancing scope, priorities, and delivery timelines
  • End-to-end ownership – from initial scoping and data sourcing to build, delivery, documentation, and handover
Soft Skills:
  • Clear communicator – able to translate complex technical concepts into language business users can understand
  • Solution-focused – bring a positive, can-do approach to challenges, with strong focus on delivery and value
  • Self-directed – work well with minimal supervision, often taking initiative to build solutions beyond what was requested
  • Analytical and curious – naturally inquisitive, with a tendency to dig into root causes and improve underlying systems
  • Calm under pressure – maintain focus and clarity when navigating tight deadlines or shifting requirements
  • Collaborative mindset – enjoy working with others, sharing knowledge, and building relationships across teams