Gavin O'Leary
Verified Expert in Engineering
Solutions Architect and Developer
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.
Portfolio
Experience
Availability
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
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.
Business Intelligence Data Warehouse Consultant
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.
Business Intelligence Data Warehouse Consultant
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.
Experience
Banking Data Framework
Cannabis Cultivation Data Mart
• Databricks machine learning
• Web scraping
• DataOps–automation
Aircraft Flight and Maintenance Data Warehouse with Data Analytics Suite
Executive Dashboard for Project Portfolio Management
Education
Bachelor's Degree in Computer Science
Munster Technological University - Cork, Ireland
Skills
Tools
Business Intelligence Development, Tableau Development, Business Intelligence Development, SQL Server
Languages
SQL, Python, Snowflake
Frameworks
ADF
Paradigms
ETL, Business Intelligence Development, Agile Development
Storage
SSIS, SQL Server, Database, Data Integration, Database, SQL Server
Platforms
Azure Design, AWS, Azure SQL Data Warehouse, Databricks, Oracle Development, Dedicated SQL Pool (formerly SQL DW)
Other
Data Management, Data Architecture, Data Warehouse, Data Engineering, Dashboard, Data Visualization, Team Mentoring, Web Scraping, Computer Science, Data Science, Azure, Data Warehouse, Data Science, Data Science
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