Jake Pullen Profile Image

Jake Pullen

Data Engineer

Transformational Data Engineer: Driving Business Growth through Data-Driven Insights

Results-driven professional with a proven track record of tackling complex data challenges across multiple industries.

With a passion for harnessing the power of data to inform strategic decision-making, I deliver actionable insights that drive business growth and unlock hidden opportunities.

Skilled in designing and implementing scalable data architectures, I excel at collaborating with cross-functional teams to bridge gaps between data science, business strategy, and technical execution.

Work Experience

Consultant Data Engineer at Aiimi

May 2024 - Present

As a trusted data engineer, I leverage my expertise to design, develop, and optimize data systems that unlock valuable insights for businesses. My primary focus is on transforming raw data into actionable intelligence, driving informed decision-making and business growth. By delivering high-quality data solutions, I help clients stay ahead in their industry.

  • I design, develop, and maintain scalable data products that integrate various data models and datasets, delivering actionable insights to drive business decisions.
  • I developed a comprehensive data validation framework, empowering teams to create robust and repeatable tests, ensuring data quality and confidence in their data pipelines.
  • I built an automated documentation tool that generates detailed documentation for complex data models, including markdown files and interactive mermaid diagrams for visualizing lineage, impact analysis, and entity relationships.

Data Engineer at The Access Group

April 2021 - May 2024

As the primary data engineer for finance in the healthcare sector, I played a critical role in driving financial reporting, forecasting, and invoice generation. Additionally, I led complex patient data migrations to support onboarding new clients and maintained the integrity of our data warehouse reporting layer.

  • I developed and maintained a comprehensive financial forecasting tool that Integrated Care Boards (ICB) used to report to the NHS England
  • I led patient data migration efforts for new clients, guaranteeing accurate and timely importation of vital patient information into our systems.
  • I created a secure data deletion solution that ensured GDPR compliance by removing client data from our multi-client database. The application logged all deletions and operated within specified timeframes to balance data erasure with system performance.
  • I enhanced the existing invoice generation system, significantly reducing error rates and incorporating advanced debugging capabilities for faster troubleshooting.

Service Desk Analyst at CDW

July 2020 - April 2021

Serve as the primary point of contact for technical support issues across a diverse portfolio of clients. Manage and facilitate access to secure Data Centre facilities, ensuring efficient resolution of technical queries.

  • Successfully interacted with second and third-line teams, on-site engineers, and end-users to provide timely and effective support, ensuring seamless resolution of technical issues and maintaining strong relationships with key stakeholders.
  • Consistently met or exceeded Service Level Agreement (SLA) targets, demonstrating a commitment to delivering exceptional customer service while minimizing downtime and maximizing productivity for our clients.
  • Effectively bridged the gap between technical and non-technical language, translating complex technical concepts into clear, concise explanations that end-users could understand, ensuring effective support and resolution of issues in a rapidly changing technical environment.

Projects

Verity

Very early stage un-named application for financial budgeting, forecasting and planning

  • Early stages of development show strong planning skills.
  • Constraint and Test driven development to show high creativity
  • Large scale project with big goals to show commitment

Data Pipeline for YNAB

I designed and developed a robust data ingestion application, adhering to industry best practices in ETL and Medallion architecture, with a focus on seamless scalability, reliability, and maintainability. The application features comprehensive error handling, logging, unit testing, and proper exit codes, ensuring fast and reliable debugging capabilities, all while leveraging optimal tools such as Polars, YAML, and Parquet files.

  • Improved data handling: This application effectively detects and resolves duplicated data and lost data, reducing unnecessary data transfer and improving load times through its delta-style approach.
  • Accelerated processing: leveraging Rust-built Polars for rapid data processing, and minimizing file sizes with Parquet storage for efficient data transfer.
  • Enhanced transparency: integrated documentation empowers users to quickly understand and debug the application's inner workings, while self-documenting code ensures ease of maintenance and updates.

Advent of Code

Embracing the Advent of Code challenge as an opportunity for growth, I dedicate myself to annually tackle this coding puzzle contest. Through every iteration, I strive to enhance my problem-solving skills, expand my technical knowledge, and cultivate a deeper understanding of computer science concepts.

  • Developed expertise in Python, leveraging its strengths for efficient coding and problem-solving.
  • Refined my ability to break down complex problems into manageable parts, and learned to adapt to unexpected inputs and edge cases.
  • Improved code organization, readability, and maintainability through careful planning, commenting, and testing.
  • Gained a deeper understanding of fundamental algorithms and data structures, including sorting, searching, graph traversal, and dynamic programming techniques.
  • Developed skills in coding best practices, debugging, and version control (Git), ensuring reliable and efficient code deployment.
  • Demonstrated proficiency with various data structures (e.g., arrays, lists, dictionaries) and their applications in solving computational problems.
  • Revisited and reinforced core computer science concepts, including data types, object-oriented programming, recursion, and functional programming.