Sam Woolerton
Verified Expert in Engineering
Data Engineer and Developer
Hamilton, New Zealand
Toptal member since December 6, 2022
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
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
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.
Analyst
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.
Experience
16 Data Pipelines
Education
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring