You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Stephen ChurchillSC

Stephen Churchill

Senior Finance Analyst | SQL | Tableau | Excel VBA

€610/day
Angoulême, FR
8-15 years

Average response time: 1 hour

About Stephen

I help finance departments transition from manual spreadsheets to automated, live self-service dashboards


With over 15 years of finance experience, specialising in financial reporting automation and team leadership. I enjoy using SQL, Excel, and visualization tools to simplify and automate reporting, and I am highly experienced in converting raw data into measurable metrics and interactive visualisation


I am a proactive problem solver with a background in managing teams within financial processing departments. I enjoy the challenge of technical innovation and have successfully delivered many custom VBA and SQL solutions to streamline complex business processes and provide new insights

My core technical skills are:
  • Data | SQL, Visual Studio Code, SQL Server Management Studio
  • Visualization | Tableau, Power BI, Advanced Excel (Power Query/Pivot, VBA)
  • Automation | Excel VBA, SQL to Excel integration, Tableau Data Source publication

In my spare time I like to explore my interest in coding through game development. I have built several games using Excel VBA and enjoy experimenting with GameMaker in my spare time. I'm a fan of 90s PC gaming, which originally sparked my interest in how software and databases work

I've played football for years and still play 5-a-side weekly with friends and former teammates

Most of my weekend time is spent with my young family, where we enjoy getting outdoors and exploring together
  • English

    Native or bilingual

  • French

    Basic

Can work on-site
Angoulême (up to 50km)

Experience

  • Irwin Mitchell LLP
    Data & Insights Analyst
    LEGAL
    May 2021 - August 2024 (3 years and 3 months)
    Sheffield, United Kingdom
    Reporting Automation
    I used SQL and Visual Studio Code to modernise our monthly reporting. I built direct data links that pull information straight into Excel, which removed the need for manual exports

    Insight Development
    I used SQL and our complex data sources to develop new, meaningful metrics for the business. A key project was creating a way to accurately measure our pricing and discount levels, which gave visibility of our potential vs realised margins

    Interactive Visualisation
    I developed and published interactive Tableau dashboards to provide stakeholders with live self-service visibility into KPIs and metrics, including profitability, staffing levels, and pricing analysis

    Advanced Forecasting
    I built a forecasting model by embedding SQL queries directly into Excel to help the business budget. This tool allowed us to predict future client volumes and the potential value of each client, which gave the management team a much clearer picture of our projected turnover
    SQL Tableau software Dashboard KPIs Data visualisation
  • Irwin Mitchell LLP
    PI Billing Team Leader
    LEGAL
    October 2009 - May 2021 (11 years and 7 months)
    Sheffield, United Kingdom
    Leadership
    I was promoted to Team Leader in 2017 to manage a team of five. My focus was on making sure we processed billing accurately whilst supporting the team's professional development

    Driving Efficiency
    I used VBA and SQL to build processes and automate several manual tasks. This saved time, allowing the team to focus on accuracy, making our billing process much more reliable

    Process Improvement
    I introduced a new billing instruction framework that ensured our team had the right information from the start, which made life much easier for the team and improved the service we provided

    Knowledge Sharing
    I acted as a regional subject matter expert, travelling to various offices to deliver presentations and training on Finance department protocols and best practices
    Macro VBA Excel SQL Optimisation des processus Reporting & Analysis Reporting financier
  • RAC Auto Windscreens
    Sales Ledger Clerk
    AUTOMOBILE
    May 2007 - October 2009 (2 years and 5 months)
    Chesterfield, United Kingdom
    Focused on high volume query resolution and dispute management using Oracle. Communicating with local offices and processing invoice amendments onto the accounting system
    Oracle

Recommendations

Be the first to recommend Stephen

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • BA (hons) Accounting and Financial Management
    The University of Sheffield
    2006
  • A Levels - Business Studies (B), Mathematics (C), ICT (C), General Studies (B)
    The Dronfield School
    2003

Skill set

Categories