About Fergus
My experience includes more than 15 years delivering enterprise data solutions cloud and on prem including tier 1 banks Standard Bank, Nedbank and Investec and also medium to small companies such as Hyve and Batt cables. I have a particular focus on understanding complex business problems through understanding data and engaging with stakeholders and subject matter experts. Then from this deep understanding I have designed and built many data solutions end to end including ELT pipelines, Star schema data models, Data cubes/ Semantic models and Power BI dashboards. I believe having a core understanding of the business and requirements is essential for a successful outcome
English
Native or bilingual
Afrikaans
Conversational
Can work on-site
London (up to 50km)
Experience
- Batt Cables DistributorData Migration EngineerENERGY AND UTILITIESJune 2025 - November 2025 (5 months)Erith, United KingdomData Management• ▪ Finance data migration Great Plains to NetSuite –SQL for data extraction and NetSuite data loads• ▪ Mapping and loading finance data from Great Plains to NetSuite including Chart of Accounts take on and open Accounts Receivable / Accounts Payable documents• ▪ Reporting proof of concept in Python/Power BI Report Builder in MS Fabric• ▪ Microsoft Fabric | Power BI | MS Great Plains | NetSuite | SSIS | DAX | SQL Server 2022| Python | MS Fabric
- Hyve Group Global Events CompanyData and Insights ManagerPRESS AND MEDIAMarch 2023 - January 2025 (1 year and 10 months)• ▪ Microsoft Fabric warehouse implementation for Bett event Community Development Team (CDT) – data lake/ load pipelines / semantic model / Power BI dashboard.• ▪ Manager for data team of two data engineers – recruited one new data engineer to bring the team up to capacity and short-term contractor.• ▪ Snowflake project implementation including CI/CD, Matillion, Tableau and Software procurement with vendor negotiations for weekly sales financial dashboard• ▪ Design and build marketing/sales lead reporting dashboard in Power BI• ▪ Maintained legacy SSIS finance interface - resolved performance and stability issues• ▪ Set up Azure devops board for tracking work and sprits• ▪ Google Sheets to Dynamics CRM365 migration for US event business• ▪ HubSpot Snowflake integration as first step towards attribution calculations
- Investec UKData EngineerBANKING AND INSURANCEFebruary 2019 - February 2023 (4 years)London, United Kingdom• ▪ Envisioned and designed virtualized Kimball style data mart in Azure synapse for Investec Lending business focusing on full balance sheet and Income statement across multiple systems• ▪ Building the above Lending data mart including a medallion and data vault layers• ▪ Configured source feeds for the Ingestion Engine built in databricks and data factory• ▪ Designed and built the Azure Analysis Services cube/Power BI model to sit on top of this mart. Including custom DAX aggregations• ▪ Extended the Securities data warehouse with a virtualized clicks and interactions mart. Built the on premise SSAS cube to sit across this warehouse.• ▪ Worked on the Data Hub client matching engine to derive a single view of the client and its replacement Microsoft Customer Insights• ▪ MapR based Data Governance reporting including training up and handing over to data governance resource.• ▪ Providing SQL training to the analytics team• ▪ Worked on Synapse Dedicated pool performance and other issues with Microsoft
Recommendations
Be the first to recommend Fergus
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
- Dimensional modeling2009Dimensional modeling
- Investec DTL (Investec Developing Team Leaders course)Investec DTL (Investec Developing Team Leaders course)