WRAbout Will
I help businesses solve complex data problems with elegant, efficient SQL and automation — reducing manual effort, increasing reliability, and drastically improving performance.
With deep experience across Snowflake, SQL Server, Oracle (PL/SQL) and Sybase, I specialise in untangling slow, over-engineered, or legacy data processes and transforming them into fast, maintainable systems.
Recent example: I re-engineered a process that took over 3 days to run, reducing it to just 3 minutes — purely through smart SQL optimisation, restructuring and JavaScript functions.
What I bring to the table:
Expert-level SQL across multiple platforms (T-SQL, PL/SQL, SQL, etc.)
Performance tuning for stored procedures, Python/JavaScript functions and large datasets
Advanced ETL and automation using SSIS and C# scripts
API integration, JSON/XML data processing, and task automation
Clean, well-documented code and a practical, results-driven approach
I’ve worked with companies of all sizes to design and maintain data warehouses, clean up messy data sets, and build robust pipelines using a mix of legacy tools and modern platforms like Snowflake, Jira and Git.
Typical projects I handle:
Tuning and rewriting slow SQL queries and stored procedures
Migrating Access or Excel-based systems into reliable, centralised databases
Building ETL processes (SSIS, Python, SQL) that are efficient and maintainable
Integrating third-party systems via REST APIs or flat file ingestion
Data modelling and mapping for business-critical reporting systems
If you’re wrestling with slow processes, unreliable data pipelines, or messy legacy systems, I’ll help you sort them out — quickly and reliably.
English
Native or bilingual
Remote only
Primarily works remotely
Experience
- DataAnnotationAI Technical TrainerOctober 2024 - Today (1 year and 8 months)About Working with AI routines, creating technical puzzles for them to solve and marking their solutions to improve results. Skills Used• SQL, JSON, Python, HTML, VBA, Excel, Google Spreadsheets, CSS, JavaScript, APIs Activities• Creating innovative code in various languages, asking the AI to adjust it in specific ways, then grading the results.• Challenging the AI to create complex routines, then grading them.
- St James's Place (SJP)Data AnalystDecember 2023 - Today (2 years and 6 months)About As part of the Consumer Duty (FCA Regulatory Requirements) team, helped create 140 urgently required reports to support SJP in fulfilling requirements to give customers a duty of care. Regulatory Project. Skills Used• Snowflake, SQL, Functions, Procedures, JSON, Python, XML, JavaScript• Business Analysis, Technical Lead Activities• Created an iterative JavaScript MWRR function within Snowflake which calculated all client data for 4 different periods within minutes (previous attempts took days).• Created a process to parse large amounts of XML into JSON using Python within Snowflake allowing the business to join to a data source previously inaccessible.• Acted as Technical Lead for a new reporting project, swapping from a manual Excel report to an integrated Snowflake / PowerBI solution.
- Hargreaves LansdownDatabase Developer & Team LeadMarch 2021 - December 2023 (2 years and 9 months)Worked on creating data interfaces for the Sybase CRM system and Oracle Wealth Management system. Created interfaces to ensure Regulatory Compliance. Skills Used• Oracle 11g, Sybase, SQL, Tables, Views, Procedures, Indexes, JSON• Business Analysis, Leadership, Agile Environment, API Specification, CI/CD Activities• Promoted to team lead due to acknowledgment of strong leadership and interpersonal skills.• Lead team of 10 developers and testers in daily scrums and reported to managers.• Provided business analysis skills, liaising with customers for requirements.• Managed / created Jira tickets for APIs and database development.• Used Git to create / check in branches for SQL code.• Used GitLab to create and peer review merge requests (pull requests).• Created views, tables, indexes, procedures, packages and functions.• Troubleshot performance issues with slow executing SQL.
Recommendations
Be the first to recommend Will
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Business Analysis Python 3 Microsoft Visual C# 2010Business Analysis Python 3 Microsoft Visual C# 2010
- Electronic Engineering Bachelor Degree (BEng)Sussex UniversityElectronic Engineering Bachelor Degree (BEng)