Ryan Lind, Developer in Montreal, QC, Canada
Ryan is available for hire
Hire Ryan

Ryan Lind

Verified Expert  in Engineering

Data Modeling Developer

Location
Montreal, QC, Canada
Toptal Member Since
October 8, 2021

Ryan has over 10 years of experience in data engineering, database development, data warehousing, business intelligence, and reporting. He has a passion for bringing data together for analysis to support data-driven decision-making. Ryan strongly believes in supporting data quality and maintaining a source of truth for organizations.

Portfolio

Unity
Google Cloud, SQL, BigQuery, Docker, GitHub Actions, Looker, Analytics...
SSENSE
Python, Apache Airflow, Amazon Web Services (AWS), Spark, SQL, Amazon Athena...
CareSource
SQL Server Integration Services (SSIS), SQL Server 2016, Azure SQL...

Experience

Availability

Full-time

Preferred Environment

Windows, Visual Studio, SQL Server Management Studio (SSMS)

The most amazing...

...project I've worked on was delivering a fully functional data warehouse from scratch with ETL from a source system developed in parallel.

Work Experience

Senior Data Engineer

2021 - 2024
Unity
  • Developed pipelines to ingest data from Google Analytics for internal product analysis.
  • Migrated integration workflows from Jenkins to GitHub Actions.
  • Performed research and analysis on various data sources to create a consolidated analytics view.
  • Built CI/CD workflows for data scientists and developers for robust and reliable deployments.
Technologies: Google Cloud, SQL, BigQuery, Docker, GitHub Actions, Looker, Analytics, Dashboards, SQL DML, Data Queries, SQL Performance, Performance Tuning, Python, PySpark, Kubernetes, Google Kubernetes Engine (GKE), PostgreSQL, Data Management, Web Scraping, Data Visualization, Data Processing, English, Snowflake, Data Architecture, Unstructured Data Analysis, Databases, Agile, Data Science, Data Structures, APIs, Data Pipelines, Teamwork, ELT

Data Engineer III

2021 - 2021
SSENSE
  • Built new pipelines for ingesting data from pub/sub-topics and APIs into our data lake.
  • Developed a data quality framework for proactively automating checks and flagging potentially harmful data.
  • Constructed a pipeline for automating monthly tasks that saved business users several hours of manual work every month.
Technologies: Python, Apache Airflow, Amazon Web Services (AWS), Spark, SQL, Amazon Athena, AWS Glue, Windows Subsystem for Linux (WSL), Docker, Kubernetes, Jenkins, MySQL, T-SQL (Transact-SQL), SQL DML, Data Queries, SQL Performance, Performance Tuning, Data Management, Databricks, Data Processing, English, Data Architecture, REST APIs, Unstructured Data Analysis, Databases, Data Integration, Agile, Data Structures, APIs, Data Pipelines, Teamwork, ELT

ETL Team Lead

2020 - 2020
CareSource
  • Managed a team of developers handling core data marts used by the business for reporting.
  • Planned and managed sprints as part of the software development lifecycle in agile.
  • Collaborated with upstream teams to coordinate changes, remove potential blockers, and ensure smooth delivery of code.
Technologies: SQL Server Integration Services (SSIS), SQL Server 2016, Azure SQL, Microsoft SQL Server, SQL DML, Data Queries, SQL Performance, Performance Tuning, T-SQL (Transact-SQL), Indexing, Data Management, Data Processing, English, Data Architecture, Database Performance, Databases, Database Migration, Database Architecture, Agile, Data Structures, SQL Server DBA, Data Pipelines, Teamwork

Data Modeler

2019 - 2020
Houston Astros
  • Developed a player-matching framework that allowed us to identify data matches for the same player from different data vendors and link the data together. Provided automated linking for sufficient quality matches.
  • Built several pipelines for ingesting data from various sources such as APIs, spreadsheets, and FTP and making the data available to analysts for querying.
  • Created a database deployment mechanism that allows us to manage database schema changes across different environments and reliably deploy the changes similar to code changes.
Technologies: SQL, Python, APIs, C#.NET, ETL, Data Validation, Data Quality, Git, Windows PowerShell, Data-tier Application Component Packages (DACPAC), Microsoft SQL Server, SQL DML, Data Queries, SQL Performance, Performance Tuning, T-SQL (Transact-SQL), Indexing, Data Management, Web Scraping, Data Visualization, Dashboards, Data Processing, English, Database Administration (DBA), Data Architecture, Data Warehouse Design, Database Performance, Database Replication, REST APIs, Databases, Database Migration, Data Integration, Database Architecture, Agile, Data Structures, SQL Server DBA, Data Pipelines, Teamwork

Data Team Lead

2013 - 2019
LGM Financial Services
  • Built a complete data warehouse and custom reporting solution from the ground up in parallel with a source system launched on the same data.
  • Architected a classification engine for the actuarial team to automate the classification of cars to serve as an important actuarial input.
  • Led a team of 5–10 developers and provided advice and decision-making to manage operational growth.
Technologies: SQL Server Integration Services (SSIS), SQL, Team Leadership, People Management, Mentorship, SQL Server Reporting Services (SSRS), Business Intelligence (BI), Data Warehousing, ETL, Octopus Deploy, TeamCity, Microsoft SQL Server, SQL DML, Data Queries, SQL Performance, Performance Tuning, T-SQL (Transact-SQL), Indexing, Data Management, Microsoft Power BI, Data Visualization, Data Processing, English, Database Administration (DBA), Data Architecture, Data Warehouse Design, Database Performance, Database Replication, Sharding, Tableau, Databases, Database Migration, Data Integration, Database Architecture, Agile, Data Structures, SQL Server DBA, Data Pipelines, Microsoft Excel, Visual Basic, Teamwork

LGM HUB

http://lgmhub.ca
A ground-up in-house built web application for selling warranties to end customers and administering the warranties.

This project included a complete data conversion from the previous application, including all modeling and validation, along with a complete data warehousing solution and operational reports. We launched the web application in parallel with an ETL into our data warehouse, and automated reports were sent out after the first day of sales on the new system.

LGM Hub DW

http://lgmhub.ca
Optimized query-intensive reports from our data warehouse for financial reporting used monthly, quarterly, and annually. Designed and optimized data structures for both canned reports and ad hoc analytics.

Languages

SQL, SQL DML, T-SQL (Transact-SQL), Python, Snowflake, C#.NET, Visual Basic

Paradigms

ETL, Business Intelligence (BI), Database Design, Database Development, Agile, Kimball Methodology, DevOps, Data Science

Platforms

Windows, Amazon Web Services (AWS), Docker, Kubernetes, Databricks

Storage

SQL Server Management Studio (SSMS), SQL Server 2016, SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Performance, Database Administration (DBA), Database Performance, Databases, Database Migration, Data Integration, Database Architecture, SQL Server DBA, Data Pipelines, SQL Server Integration Services (SSIS), Data Validation, Database Replication, Data-tier Application Component Packages (DACPAC), Azure SQL, MySQL, Google Cloud, PostgreSQL

Other

Data Warehousing, Data Modeling, Data Engineering, Data Queries, Performance Tuning, Indexing, Query Optimization, Web Scraping, Data Processing, English, Data Architecture, Data Warehouse Design, Data Structures, Teamwork, Microsoft Azure, Data Conversion, APIs, Data Quality, Dashboards, Data Management, Data Visualization, Data Analysis, Unstructured Data Analysis, ELT, Web Development, Windows Subsystem for Linux (WSL), Software Development, Team Leadership, People Management, Mentorship, Octopus Deploy, GitHub Actions, Analytics, Google BigQuery, Sharding

Libraries/APIs

REST APIs, PySpark

Tools

Visual Studio, Microsoft Power BI, Apache Airflow, Amazon Athena, AWS Glue, Git, TeamCity, Jenkins, BigQuery, Looker, Google Kubernetes Engine (GKE), Tableau, Microsoft Excel

Frameworks

Spark, Windows PowerShell

2005 - 2009

Bachelor of Computer Information Systems Degree in Computer Science

Okanagan College - Kelowna, BC

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