Jack C. Email & Phone Number

Manchester, Gb

Manchester Area, United Kingdom

Greater Manchester, England, United Kingdom

- Mentored engineering team to improve development culture while allowing them to take on more responsibility- Collaborated with product managers and client teams to deliver solutions tailored to strategic priorities- Built and deployed ELT pipelines with Airflow and DBT, packaging custom extraction processes into Docker containers and using DBT for data cleaning and transformation- Optimised existing ELT SQL queries and implemented a number of BigQuery features to help reduce costs (such as partitioning and predicate filters)- Led the migration of existing infrastructure into terraform in order to improve platform stability and reduce development time- Developed a framework for replicating data from our production environment into UAT in real time by utilising Cloud Functions and BigQuery table clones- Designed and built multiple applications in Python and Go to increase functionality across the platform. This included REST APIs for ingesting data into GCP, GCS event file replication, GCS dag trigger and various CLI tools

London, United Kingdom

- Designed and implemented new ETL pipelines to support the migration of the analytics warehouse to BigQuery, optimising data flows to improve efficiency and reduce latency- Developed interactive Tableau dashboards to monitor CRM marketing campaign performance, in order to improve the decision making process taken by stakeholders- Contributed to the successful migration of the SAS platform to Vertica on AWS, utilising Glue for data integration and transformation. The project, completed in 2018, achieved over £200k in annual costs savings while enhancing scalability and performance- Redesigned developer framework for engineers by integrating Docker and Git commit hooks in order to enforce environment, testing and linting standards - this improved code consistency and reduced errors

London, United Kingdom

HMRC Connect Account - a data mining platform that cross references tax records with other sources of data to help identify tax fraud- Created interactive SAS stored processes in order to simplify complex data analysis tasks for business users, reducing their reliance on manual queries- Decreased the time required to execute data transformations by optimising existing SAS ETL scripts, resulting in a 20% reduction in data processing times- Published technical documentation and user guides for new SAS processes in order to support the HMRC team maintain consistent standards and onboard new analysts more efficiently- Developed deployment scripts to support the SAS version upgrade migration, ensuring straightforward transitions and minimising disruptions to existing workflows

London Area, United Kingdom

In house graduate software engineering scheme- Analysed software requirements for client projects with the guidance of senior engineers by conducting data analysis and stakeholder interviews- Participated in peer code reviews to uphold quality standards and promote collaborative learning among the team- Assisted in the creation of technical documentation for software modules, improving standards for developers and stakeholders- Implemented automated testing for a Flask application using Python’s unittest framework which help to identify critical bugs early in development

Bristol, United Kingdom

- Compiled and analysed data into reports from financial information provided from over 70 sites around the UK- Regularly travelled to various sites around the UK to attend meetings and performance reviews with clients- Helped to implement new labour management software developed by our own IT department at various sites

Bachelor'S Degree, Physics, 2:1

A Level, Maths, B

A Level, Physics, B

A Level, Chemistry, C

As Level, English Literature, C