Mike Hamilton

Mike Hamilton Email and Phone Number

Lead Data Engineer @ PXC
Manchester, GB
Mike Hamilton's Location
Manchester, England, United Kingdom, United Kingdom
About Mike Hamilton

I love what I do. I am a Senior Data Engineer currently working with Azure Synapse, Azure Data Factory, Databricks, Python, PySpark, SQL and Power BI. I work in a Lead Technical role for a key data team for the largest Tech Company in the North of England TalkTalk (PXC). I design and develop end to end data solutions and the supporting architecture and take a lead role in deciding our processes and policies. I work with a vast array of structured and semi structured data managing it's definitions, storage & transformation to user appropriate reporting. Previously I have working across a wide variety of projects including platform migrations. I spent over a decade with GE Capital Fleet Services - the global gold standard in our sector and my other experience includes a well know international research & media consultancy and a £38M Credit Union Transformation project. My curiosity, inventiveness and insatiable desire to solve problems and improve things has taken me on a fantastic journey, taught me a great set of skills and allowed me to work with some wonderful people.

Mike Hamilton's Current Company Details
PXC

Pxc

View
Lead Data Engineer
Manchester, GB
Website:
pxc.co.uk
Employees:
648
Mike Hamilton Work Experience Details
  • Pxc
    Lead Data Engineer
    Pxc
    Manchester, Gb
  • Talktalk
    Senior Data Engineer
    Talktalk Sep 2020 - Present
    Salford, England, Gb
    Working in a Controls Development Team for the Core Finance function. We have a wide scope of work, we transform requirements into pipelines, data structures and visualisations, often working with complex semi-structured data. Our visualisations are in Power BI, we are in the process of migrating from IBM Netezza to Azure Synapse Analyics (ADW) and are migrating from a legacy PhixFlow platform to Data Factory for our pipelines. We work in predominatelyin SQL, use the Power Platform and also Python. Part of my role is to give coaching and support to other Engineers.
  • Engine | Transformation
    Data Engineer
    Engine | Transformation Jul 2019 - Sep 2020
    London, England, Gb
    Working with predominantly in Python and TSQL for our Employee Research Product Development Team going through the initial stages of a major platform modernisation, taking multiple legacy systems to an AWS/Postgres/Databricks. Our project methodology is supported by Confluence, Jira, Slack, Jupyter/Databricks and Trello. I delivered the data elements of projects collaborating with researchers and customers as well as developing specific products. I have been building data pipelines on Python and SQL, modernising legacy systems and solving the problems these systems present. We are rolling out Python as a core language and I am working on our best practice, developing my team and building up our Github repository. My greatest pleasure is working with my team mates to develop a shared vision into a reality or solving complex problems, best of all is helping others to develop their skills and learning new ones from them.
  • Cornerstone Mutual Services Ltd
    Management Information Specialist
    Cornerstone Mutual Services Ltd May 2017 - Jul 2019
    Developed a multiplatform management information service for a banking platform transformation project. Crystal Reports, SQL db2, Agility, QlikView. This was a uniquely challenging and historic project for the sector, involving a high degree of complexity and ability to deliver under pressure.Designed and delivered a full data and BI solution for an automated lending desicion product using Tableau, Python, VBA and SQL Server. I was responsible for all elements from planning, requirement & data gathering, ETL & Data Warehouse to analysis, distribution, Self-Service Analytics and Visualisation. This platform processed around 1M consumer applications for a group of 60 clients.I also delivered several automation projects in Python and delivered advanced Excel, SQL & Crystal Reports training.
  • Ge Capital
    Asset Management Analyst
    Ge Capital Aug 2014 - Dec 2016
    Norwalk, Ct, Us
    Providing Business Intelligence and Data Governance for £120M of vehicle assets to a wide array of KPIs for a broard range of stakeholders. Oracle, Access, Informatica, QlikView, VBA, Workflows
  • Ge Capital
    Portfolio Analyst
    Ge Capital Oct 2013 - Sep 2014
    Norwalk, Ct, Us
    Building Workflows, Automation and Management Information for the portfolio optimisation of a fleet of 40,000 fleet vehicles. Working with high value clients in multi tier relationships. Resolving complex queries across all aspects of Fleet Portfolio Management, identifying root causes and building solutions.
  • Ge Capital
    Risk Analyst/ Project Co-Ordinator
    Ge Capital Jul 2010 - Oct 2013
    Norwalk, Ct, Us
    Leading the project activities of the Credit Collections team, I applied deep domain expertise, innovation, collaboration, change management and energy to exceed targets.Providing analysis, building solutions, planning & reporting, presenting to senior leadership and delivering new methodology relating to intelligent management & reconciliation of credit notes.
  • Ge Capital
    Project Analyst
    Ge Capital Oct 2009 - Jul 2010
    Norwalk, Ct, Us
    Provided vital technical support & credit control expertise to the Fleet Delinquency Project Team.Created new reconciliation tools, reporting solutions & macros, saving 100s of hours in manual reconciliation.Go-to point for the project team for fleet billing and account reconciliation queries.Delivering radical reduction in delinquency on my own book of GE's internal company accounts.
  • Ge Capital
    Portfolio Optimisation Specialist / Project Analyst
    Ge Capital Jan 2009 - Oct 2009
    Norwalk, Ct, Us
    Selected for key role, supporting all aspects of the hugely successful Fleet Optimisation project. This was GE Fleet Services 1st line response to the financial crisis of 2008 which delivered a £36M saving.
  • Ge Capital
    Integration Analyst
    Ge Capital Mar 2007 - Nov 2008
    Norwalk, Ct, Us
    Selected to integrate & develop the role of Senior Fleet Manager for a large bank as part of a company acquisition.Responsible for developing new processes, overseeing all day to day activities/queries,increasing orders, developing car policy & advising account manager on strategic direction of the account.

Mike Hamilton Skills

Microsoft Excel Microsoft Access Fleet Management Account Reconciliation Business Process Improvement Credit Control Financial Planning Finance Lease Contract Rewiting Accounting Billing Solutions Risk Analytics Inventory Control Asset Management Report Writing Portfolio Management Change Management Oracle Applications Qlikview Portfolio Optimization Fleet Services Risk Management Project Support Profitability Enhancement Forecasting Visual Basic For Applications Regulated Industry Team Motivation Credit Financial Services Crystal Reports Credit Unions Loans Python Tableau Data Warehousing Strategic Planning Sql Ibm Db2 Team Building Unstructured Data Visualization Macro Visual Basic Data Collection Transact Sql Data Governance Business Intelligence Data Analysis

Frequently Asked Questions about Mike Hamilton

What company does Mike Hamilton work for?

Mike Hamilton works for Pxc

What is Mike Hamilton's role at the current company?

Mike Hamilton's current role is Lead Data Engineer.

What skills is Mike Hamilton known for?

Mike Hamilton has skills like Microsoft Excel, Microsoft Access, Fleet Management, Account Reconciliation, Business Process Improvement, Credit Control, Financial Planning, Finance, Lease Contract Rewiting, Accounting, Billing Solutions, Risk Analytics.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.