Sam Woolerton, Developer in Hamilton, New Zealand
Sam is currently unavailable

Sam Woolerton

Bio

Sam is a seasoned full-stack data engineer with more than four years of experience. He uses Python to build data pipelines and integrate APIs, SQL to provide data modeling and data warehousing, and Power BI to create dashboards and reporting. Sam thrives in fast-paced environments and is comfortable working across different data stacks, whether providing end-to-end solutions or focusing on a specific part of them.

Portfolio

Foster Construction
React, Python, APIs, Data Warehousing, Elixir, Functional Programming, CSS...
IT Partners
WordPress, Vue, HTML, CSS, APIs, Microsoft Power BI, Node.js...

Experience

  • Excel 365 - 7 years
  • Microsoft Power BI - 5 years
  • SQL - 5 years
  • Python - 4 years
  • TypeScript - 4 years
  • APIs - 4 years
  • Integration - 3 years
  • Redshift - 3 years

Preferred Environment

Windows, Linux, Visual Studio Code (VS Code)

The most amazing...

...project I've completed is end-to-end data modeling for an NZ-based construction company, including 16 data pipelines, integrations, and reporting.

Work Experience

Data Lead

2020 - 2022
Foster Construction
  • Built 16 data pipelines from a range of APIs and databases to centralize all company data in one data warehouse.
  • Made well-documented data models in SQL for all data pipelines and sources.
  • Worked on extensive reports in Power BI for business users, from operational staff to top management.
  • Built a range of integrations in Python to connect core business systems using the unified data model I had built earlier.
  • Developed several custom web apps to replace complex and time-consuming manual processes. These used the core data model and a mix of full-stack technologies.
  • Created an internal health and safety site attendance web and native app to streamline site inductions and replace a paper-based sign-in and induction process.
Technologies: React, Python, APIs, Data Warehousing, Elixir, Functional Programming, CSS, GraphQL, HTML, Integration, Linux, Git, Microsoft Power BI, Redshift, SQL, REST, TypeScript, Excel 365, Node.js, Scraping, Data Visualization, Data Analytics, Data Analysis, Technical Writing, Data Modeling, Business Intelligence (BI), AWS Lambda, Data, Data Engineering, Data Build Tool (dbt), Pandas, ETL, Singer ETL

Analyst

2018 - 2020
IT Partners
  • Used Power BI to combine data from a range of data sources like web analytics, internal databases, and software APIs and then bring this data to life with rich interactive reporting.
  • Built a series of data pipelines, API integrations, and a live data warehouse to improve data quality and help the company make better decisions faster.
  • Overhauled the company's WordPress marketing site, which had a badly outdated codebase and was very slow as a result. I implemented A/B tests to make data-driven decisions, improved landing page conversions, and removed 8,000 lines of unused CSS.
Technologies: WordPress, Vue, HTML, CSS, APIs, Microsoft Power BI, Node.js, Data Visualization, Business Intelligence (BI), Data, Data Analysis, Data Analytics, Data Modeling

Experience

16 Data Pipelines

Built 16 data pipelines and a pipeline orchestration tool from different SaaS apps into our data warehouse. This involved a range of APIs with varying ways to handle pagination, filtering, and authentication, as well as several different databases. I also optimized many of these pipelines to reduce memory use, bringing down compute costs and enabling them to run faster.

Education

2014 - 2017

Bachelor's Degree in Management Studies

University of Waikato - Hamilton, New Zealand

Skills

Libraries/APIs

React, Xero API, Node.js, Vue, Pandas

Tools

Microsoft Power BI, Microsoft Excel, Git

Languages

Python, SQL, TypeScript, HTML, CSS, GraphQL, Elixir

Paradigms

ETL, Business Intelligence (BI), Functional Programming, REST

Storage

Data Pipelines, Redshift, Microsoft SQL Server

Platforms

Linux, WordPress, AWS Lambda

Other

APIs, Excel 365, Data Engineering, Data, Singer ETL, Integration, Data Visualization, Data Modeling, Data Build Tool (dbt), Full-stack, Data Warehousing, Strategy, Xero Accounting, Economics, Scraping, Technical Writing, Data Analysis, Data Analytics

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring