Description

Financial services and technology professional/

Data engineering and Data analytics solution architect/ experience delivering complex data analytics solutions for global private and public sector institutions ranging from large cap insurance to Engineering. Experienced developer proficient in tools including powerbi and Microsoft Azure, adept in languages including Python, SQL, Spark and powershell. Successfuly delivered business critical projects across multiple regions and cultures at pace. Experienced managing teams of up to 8 developers. Articulated in data architecture and technical solution design. Strong background and fluency in data warehouse design and development. Cloud certified and experienced consultant. SCRUM certified and experienced agile project management.

Industry field of expertise

Languages

English
Native or bilingual
French
Conversational

Workplace preferences

Remote only

Primarily works remotely

Telefónica Tech
Senior Data Consultant
DIGITAL AND IT
October 2021 - Today (4 years and 8 months)
London, United Kingdom
Azure data warehouse design and development.
Data platform design and development.
Data analytics and Business intelligence.
Experienced technical lead managing teams of up to 8 data engineers.
Delivered multiple complex data projects always meeting strict timelines for multiple global large cap institutions from Insurance to Engineering.
Microsoft Azure Microsoft Power BI SQL Python Databricks
Clearbank
Business intelligence specialist
BANKING AND INSURANCE
June 2020 - September 2021 (1 year and 4 months)
London, United Kingdom
Key Achievements
• Created new data department within technology innovation
• Delivered essential tools/systems to Financial Crime Investigations teams
• Developed ClearBank software for efficient client account creation, transferred to client management
• Introduced Microsoft Power BI enterprise-wide; designed, developed, and maintained reporting solutions; trained users in BI tools (Tableau, Power BI, Databricks). Enabled treasury to accurately monitor and manage liquidity
• Attended industry conferences (Microsoft) to set reporting standards, improving BI efficiency and accuracy

Responsibilities
• Created data lake models; updated and documented core banking database systems
• Built and maintained Azure data catalogue system
• Managed persistent RDBMS SQL Azure (cloud and on-premises) across multiple business lines; updated stored procedures, refactored scheduled tasks
• Translated business requirements to technology teams for data-driven solutions
• Participated in regulatory environment with regular FCA compliance training
• Collaborated with Financial Crime Investigations/Intelligence teams to produce automated transaction analysis system
• Engaged senior Fin Crime stakeholders to enhance AML and KYC efficiency
• Worked with executive committee and department heads to interpret BI requirements for informed decisions
• Conducted regression analysis of transactional volumes using Python to predict high-volume periods and auto-scale computing resources, reducing costs
• Ongoing development/management of information systems

Technical Skills
• Advanced Python programming: object-oriented design, pandas, NumPy
• Expert SQL: querying, database/table creation, CRUD operations, stored procedures
• Knowledge in FX, commodities, and rate settlements

(1,998 characters)
Microsoft Azure Databricks SQL PowerBI Data analysis
Clearbank
Data architect
BANKING AND INSURANCE
January 2020 - June 2020 (6 months)
London, United Kingdom
-Mapped out technical architecture diagrams and documentation on all relational database systems (RDBMS).
o Design, build, test and maintenance of new Azure SQL database systems.
o Model data requirements from business into Azure Databricks Data Lake architecture, using Scala, SparkSQL and Python.
o Extensive use of Azure data catalogue to document multiple data sources and create lineage profiles for interaction with other development teams. Understand business needs for operational and financial data and model appropriate data solutions.
Data modelling Databricks Python Data architecture Sparksql