Nick Maher, Developer in Pisa, Province of Pisa, Italy
Nick is available for hire
Hire Nick

Nick Maher

Verified Expert  in Engineering

Bio

Nick is a senior data scientist and engineer with 15+ years of experience working for industry leaders in adtech (Oracle), fintech (BofA, HSBC, Lloyds), and insurance (Swiss Re). He is highly accomplished in data architecture, modeling, and analysis, leading teams and projects to deliver management insights, business growth, and efficiencies. Nick is skilled in building scalable data pipelines and integrations to transform raw data into valuable information for business stakeholders.

Portfolio

iptiQ Life
Python, SQL, Data Engineering, Dimensional Modeling, Amazon Web Services (AWS)...
Oracle
Oracle BI, Oracle, Microsoft SQL Server, Microsoft Excel, Python, Jira...
TVSquared
Python, R, PostgreSQL, MongoDB, Microsoft Excel, SQL, Pandas...

Experience

  • Analytics - 15 years
  • Business Intelligence (BI) - 15 years
  • SQL - 15 years
  • Data Architecture - 12 years
  • Data Visualization - 12 years
  • Tableau - 10 years
  • Data Engineering - 9 years
  • Python - 8 years

Availability

Part-time

Preferred Environment

Windows, Python, SQL Server BI, MySQL, PostgreSQL, MongoDB, Tableau, Data Build Tool (dbt), Apache Airflow

The most amazing...

...project I've worked on was building out a data warehouse and all the reporting for a new online game entirely from scratch, including 3D models of the maps.

Work Experience

Data Engineer

2022 - 2024
iptiQ Life
  • Streamlined the onboarding process for new partners by producing a common set of data models.
  • Developed standardized tax reports for each country in the region.
  • Built Amazon Athena table on top of thousands of JSON files to allow low-latency analysis of insurance quotes.
Technologies: Python, SQL, Data Engineering, Dimensional Modeling, Amazon Web Services (AWS), Data Modeling, Data Build Tool (dbt), Amazon Athena, Apache Airflow, Git, Linux, Amazon S3 (AWS S3), Data Transformation, Data Extraction, Data Lakes, Amazon Managed Workflows for Apache Airflow (MWAA)

Business Intelligence Manager

2017 - 2022
Oracle
  • Led the front-end business intelligence team with five direct reports located across five different time zones and three continents.
  • Managed delivery of online (Oracle BI) and offline (Excel) reporting for the finance and the go-to-market teams.
  • Implemented a bespoke data mart for reporting. It improved query performance and reduced data latency from weeks to hours.
  • Delivered data science projects around forecasting future revenue and string-parsing for vertical industry classifications of digital audiences, reducing the need for human input in month-end close processes.
  • Re-designed the compensation calculation system to improve the timeliness of the submissions each quarter and reduce errors.
Technologies: Oracle BI, Oracle, Microsoft SQL Server, Microsoft Excel, Python, Jira, Confluence, Excel VBA, SQL Server Analysis Services (SSAS), Alteryx, SQL, MySQL, Data Visualization, Business Intelligence (BI), Excel Macros, Analytics, Data Engineering, ETL, Data Analytics, Data Modeling, Data Architecture, Data Reporting, Data Governance, Amazon Web Services (AWS), Query Optimization, Data Pipelines, Data Warehousing, Dashboards, Databases, SQL Stored Procedures, SQL Server BI, Dimensional Modeling, Apache Airflow, Data Analysis, Git, Digital Marketing, PyCharm, Django, Amazon S3 (AWS S3), T-SQL (Transact-SQL), Data Migration, Data Transformation, Data Extraction, Data Lakes

Data Scientist | Freelance

2015 - 2016
TVSquared
  • Built a prototype machine learning model to provide recommendations for the placement of TV advertising spots.
  • Developed an econometric model to forecast response rates from TV advertising based on customer verticals, competitor spending, and search traffic.
  • Conducted analysis of the impact of advertising during the 2016 NFL Super Bowl and 2016 European Championships Final, which gained media coverage for the company.
Technologies: Python, R, PostgreSQL, MongoDB, Microsoft Excel, SQL, Pandas, Data Visualization, Business Intelligence (BI), Analytics, Data Analytics, Data Reporting, Amazon Web Services (AWS), Databases, Data Analysis, Data Science, Linux, Machine Learning, Azure, Data Extraction

Product Analyst

2013 - 2014
Jagex
  • Prepared and presented weekly KPI packs to the exec team, covering revenue, user metrics, and game balance.
  • Analyzed full user onboarding flow, from an initial website visit to account creation and tutorial completion.
  • Oversaw reporting through the beta launch of the game, selecting users to be invited, and tracking daily changes to metrics.
Technologies: Vertica, Hadoop, Apache Hive, Tableau, MongoDB, SQL, Python, Data Visualization, Business Intelligence (BI), Data Engineering, ETL, Data Analytics, Data Modeling, Data Architecture, Data Reporting, Data Governance, Analytics, Query Optimization, eCommerce, Data Pipelines, Data Warehousing, Microsoft Excel, Dashboards, Databases, SQL Stored Procedures, Dimensional Modeling, Data Analysis, Data Transformation, Data Extraction

Senior Analyst

2006 - 2012
Sumerian
  • Worked with a national bank on the rollout of new customer-facing systems to determine available day one capacity.
  • Scenario modeled customer Voice over IP (VoIP) systems based on suggested network topologies to determine total user constraints.
  • Analyzed batch processes of a major car leasing company to identify potential optimizations and ways to reduce overall processing time.
Technologies: Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL, Data Visualization, Business Intelligence (BI), Analytics, Data Engineering, ETL, Data Analytics, Data Modeling, Data Reporting, Data Pipelines, Microsoft Excel, Dashboards, Databases, SQL Stored Procedures, SQL Server BI, Dimensional Modeling, Data Analysis, T-SQL (Transact-SQL), Data Transformation, Data Extraction

Experience

Data Mart for Sales Data

Building a new data mart for sales and revenue reporting dashboards to replace the existing flat table structure. I built the original proof-of-concept, worked with the rest of the team to replace all the current tables, functions, and stored procedures, and updated the dashboards and OLAP cubes. Overall end-to-end processing time was taken down from over 30 hours to 90 minutes.

Tableau Dashboards for Startup

Building out a suite of dashboards in Tableau online for a startup just beginning to scale.

Previous reports had been done in Google Sheets for a single partner at a time, so I was brought in to build a set of reports that would cover the whole business. I worked with stakeholders throughout the company, from sales leads and account managers to product managers and up to the exec team.

The dashboards became a key part of the day-to-day running of the business.

Analysis of TV Ad Winners of Super Bowl 50

https://adtechdaily.com/2016/02/10/amazons-echo-made-most-impact-following-its-super-bowl-advert-says-tvsquared-infographic/
Analysis of the advertising spots shown during the Super Bowl 50 and their uplift on their search traffic for their respective brands.

I managed data collection for the project, ensuring we could scrape the data we needed within the mandated API rate limits and without any gaps in the data.

Education

2005 - 2006

Master's Degree in Operational Research

University of Strathclyde - Glasgow, UK

2002 - 2005

Bachelor's Degree in Mathematics

University of Warwick - Warwickshire, UK

Skills

Libraries/APIs

Pandas

Tools

SQL Server BI, Tableau, Microsoft Excel, PyCharm, Jira, Confluence, Apache Airflow, Amazon Athena, Git

Languages

Python, SQL, Excel VBA, T-SQL (Transact-SQL), R

Paradigms

ETL, Business Intelligence (BI), Dimensional Modeling

Storage

Microsoft SQL Server, SQL Server Analysis Services (SSAS), Databases, SQL Stored Procedures, MySQL, PostgreSQL, MongoDB, SQL Server Integration Services (SSIS), Data Pipelines, Data Lakes, Vertica, Apache Hive, SQL Server Reporting Services (SSRS), SQL Server Agent, Amazon S3 (AWS S3)

Platforms

Windows, Amazon Web Services (AWS), Oracle, Alteryx, Linux, Azure

Frameworks

Hadoop, Django

Other

Analytics, Data Engineering, Data Analytics, Data Modeling, Data Architecture, Data Reporting, Data Warehousing, Dashboards, Data Analysis, Data Transformation, Data Extraction, Data Visualization, Query Optimization, Digital Marketing, Oracle BI, Google Trends, Excel Macros, Data Governance, eCommerce, Data Science, Data Build Tool (dbt), Machine Learning, Data Migration, Amazon Managed Workflows for Apache Airflow (MWAA)

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