Jacob Cowan

• Developed end to end solution for data integration with high speed telephony data, requiring performant code and scalable data management.
• Performed entirely using legacy SSIS and MSSQL at the employers request.
• Wrote my most descriptive piece of technical documentation for one particular project to date, spanning over 20 chapters detailing operation.

Part-time contract data engineer to a mid-size recruitment agency (weekends).

• Singlehandedly built the entire end-to-end ETL infrastructure from data ingestion via REST, transformation to reporting.
• Use of AWS services such as Glue, QuickSight (BI), Simple Queue Service (Kafka replica), Lambda, Sagemaker and Athena.
• Provide technical mentorship to insight analysts to visualize data using well founded classical statistical techniques.
• Multiple ML projects, the largest vastly improving vacancy/candidate matching rates using modern techniques.
• Multiple automation projects, the largest reducing the time taken for consultants to add a new candidate to the CRM by around 89%.
• Personally research, manage and handle all GDPR governance and security.

Replaced previous contractor to assist in the integration and development process of various PowerBI Dashboards.

• Assisted the learning development of junior and mid level associates in various SQL practices.
• Migrated data sources of multiple dashboards and oversaw the integration process of Oracle based data to an internal DataMart using the star schema.
• Redeveloped previous documentation to suit best practice.

Replaced previous sole data engineer to manage the entire backend ETL environment for a business running over 40 multimillion pound Hotels.

• Maintained and created ETL pipelines for multiple MS Server databases and Azure DevOps to support reporting across the business in Python, SQL and C#.
• Maintained, created and optimized API ingestion integrations to several services used across the business with the use of both REST and SOAP protocols.
• Handled multiple legacy/modern SSIS integrations that run pipelines for substantial organizational entities (J.P. Morgan, PwC, etc).

Working across multiple areas, I handled data for both the IT and Data Science team.

• Worked on large migration project from the legacy on prem Oracle system to AWS.
• Use of Databricks service for data transformation and ML automation.
• Built multiple utility scripts using Bash and Python to test, optimize and apply cost reduction to large data pipelines.
• Use of Tableau for financial data reporting to C-Suite.