Gavin O'Leary, Developer in Vancouver, Canada
Gavin is available for hire
Hire Gavin

Gavin O'Leary

Verified Expert  in Engineering

Solutions Architect and Developer

Location
Vancouver, Canada
Toptal Member Since
June 14, 2022

Gavin is a business intelligence and data warehousing consultant, solution architect, instructor, strategist, mentor, thought-leader, and creative thinker. With 20+ years of experience, he is seen as a trusted adviser and has led and delivered numerous projects across diverse industries, balancing technology, processes, and people. Gavin is a proficient team player and goal-driven professional, passionate about business relationship development and customer satisfaction.

Data WarehousingData EngineeringETLBusiness Intelligence (BI)SQLMicrosoft SQL ServerDatabasesSQL Server Integration Services (SSIS)Web ScrapingAgileAmazon Web Services (AWS)PythonTableauSnowflakeData GovernanceDataOps

Portfolio

GOLTECH Solutions
Data Warehousing, Business Intelligence (BI), Data Science, Data Analytics...
Vancity
Data Management, ETL, Business Intelligence (BI), Azure
TELUS
Business Intelligence (BI), Data Warehousing, Data Architecture

Experience

Data Architecture - 20 yearsSQL - 20 yearsETL - 20 yearsData Warehousing - 20 yearsData Management - 20 yearsBusiness Intelligence (BI) - 20 yearsAgile - 10 yearsAzure - 5 years

Availability

Part-time

Preferred Environment

Azure, Amazon Web Services (AWS), Snowflake

The most amazing...

...project I've worked on was designing and building a DataOps solution to quickly meet business information needs using automation to simplify the data lifecycle.

Work Experience

Senior Data Analytics Consultant

2018 - PRESENT
GOLTECH Solutions
  • Helped organizations become data-driven by enabling information to flow freely across the entire business ecosystem.
  • Designed and developed enterprise-wide data management solutions to support organizational reporting and analytics.
  • Mentored other developers on solving issues, code patterns, and general best practices.
Technologies: Data Warehousing, Business Intelligence (BI), Data Science, Data Analytics, Tableau, Microsoft SQL Server, Data Engineering, Databases

Business Intelligence Data Warehouse Consultant

2011 - 2018
Vancity
  • Pioneered a proposal to modernize the business intelligence and data warehousing (BI/DW) landscape using the latest cloud tools and technologies combined with modern data warehousing techniques and methodologies.
  • Provided technical leadership over the data warehouse team.
  • Designed and developed a data mart to support business intelligence applications for a new loan origination system.
Technologies: Data Management, ETL, Business Intelligence (BI), Azure

Business Intelligence Data Warehouse Consultant

2010 - 2011
TELUS
  • Contributed as the solution architect in the agile delivery process.
  • Assessed the informational needs of the business by conducting a detailed requirements analysis, liaising with the business, and translating business requirements into BI/DW project deliverables.
  • Designed and implemented an executive information dashboard using Oracle source systems, the Microsoft SQL Server 2008 Data Warehouse staging and presentation layers, SSIS ETL tool, and SSRS and SharePoint web enterprise tools.
Technologies: Business Intelligence (BI), Data Warehousing, Data Architecture

Banking Data Framework

The data framework was a multi-year program to move the organization toward a more modern enterprise intelligence ecosystem supported by robust data governance operations that overcome BI delivery challenges and support current and future digital transformation needs.

Cannabis Cultivation Data Mart

Designed and built a cannabis cultivation data mart using the Azure Platform. Automated the ingestion process of various data sources using Azure Data Factory (ADF). Designed and developed a data automation framework to ingest any data source in ADF. This project supports various data management projects:
• Databricks machine learning
• Web scraping
• DataOps–automation

Aircraft Flight and Maintenance Data Warehouse with Data Analytics Suite

As the data warehouse architect, I was responsible for assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of the data warehouse. I established the development strategy, technical architecture, and the short-term scope for a multi-phased data warehouse effort.

Executive Dashboard for Project Portfolio Management

Designed and implemented the executive information dashboard using Oracle source systems, the Microsoft SQL Server 2008 Data Warehouse staging and presentation layers, SSIS ETL tool, and SSRS and SharePoint web enterprise tools.

Languages

SQL, Python, Snowflake

Frameworks

ADF

Paradigms

ETL, Business Intelligence (BI), Agile, Data Science

Storage

SQL Server Integration Services (SSIS), Microsoft SQL Server, Databases, Master Data Management (MDM), SQL Server Analysis Services (SSAS)

Other

Data Management, Data Architecture, Data Warehousing, Data Engineering, Web Scraping, Computer Science, Data Governance, Azure Data Lake, Data Warehouse Design, Data Analytics

Tools

Tableau, IBM Cognos, SQL Server BI

Platforms

Azure, Amazon Web Services (AWS), Azure SQL Data Warehouse, Databricks, Oracle, Dedicated SQL Pool (formerly SQL DW)

1994 - 2000

Bachelor's Degree in Computer Science

Munster Technological University - Cork, Ireland

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