Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

I am a Senior Data Engineer and BI specialist with 18+ years of experience in the financial services sector. I design, optimize, and implement large-scale ETL pipelines and database solutions, leveraging modern cloud data platforms such as Databricks, Azure Data Factory, and Azure Data Lake, along with SQL Server, SSIS, PostgreSQL, and Snowflake. I thrive on turning complex data challenges into scalable architectures and actionable insights. I collaborate with business stakeholders to translate needs into robust data models and dashboards using Power BI and Tableau, drive performance improvements on terabyte-scale databases through partitioning and tuning, and streamline development with Git, automation, and comprehensive test plans. My goal is to deliver reliable data foundations and intuitive analytics that empower strategic decision-making.…I am a Senior Data Engineer and BI specialist with 18+ years of experience in the financial services sector. I design, optimize, and implement large-scale ETL pipelines and database solutions, leveraging modern cloud data platforms such as Databricks, Azure Data Factory, and Azure Data Lake, along with SQL Server, SSIS, PostgreSQL, and Snowflake. I thrive on turning complex data challenges into scalable architectures and actionable insights. I collaborate with business stakeholders to translate needs into robust data models and dashboards using Power BI and Tableau, drive performance improvements on terabyte-scale databases through partitioning and tuning, and streamline development with Git, automation, and comprehensive test plans. My goal is to deliver reliable data foundations and intuitive analytics that empower strategic decision-making.

Robert Opeshansky

Data Analyst, Data Scientist, Database Developer, +1





I am a Senior Data Engineer and BI specialist with 18+ years of experience in the financial services sector. I design, optimize, and implement large-scale ETL pipelines and database solutions, leveraging modern cloud data platforms such as Databricks, Azure Data Factory, and Azure Data Lake, along with SQL Server, SSIS, PostgreSQL, and Snowflake. I thrive on turning complex data challenges into scalable architectures and actionable insights. I collaborate with business stakeholders to translate needs into robust data models and dashboards using Power BI and Tableau, drive performance improvements on terabyte-scale databases through partitioning and tuning, and streamline development with Git, automation, and comprehensive test plans. My goal is to deliver reliable data foundations and intuitive analytics that empower strategic decision-making.…I am a Senior Data Engineer and BI specialist with 18+ years of experience in the financial services sector. I design, optimize, and implement large-scale ETL pipelines and database solutions, leveraging modern cloud data platforms such as Databricks, Azure Data Factory, and Azure Data Lake, along with SQL Server, SSIS, PostgreSQL, and Snowflake. I thrive on turning complex data challenges into scalable architectures and actionable insights. I collaborate with business stakeholders to translate needs into robust data models and dashboards using Power BI and Tableau, drive performance improvements on terabyte-scale databases through partitioning and tuning, and streamline development with Git, automation, and comprehensive test plans. My goal is to deliver reliable data foundations and intuitive analytics that empower strategic decision-making.

Available to hire

I am a Senior Data Engineer and BI specialist with 18+ years of experience in the financial services sector. I design, optimize, and implement large-scale ETL pipelines and database solutions, leveraging modern cloud data platforms such as Databricks, Azure Data Factory, and Azure Data Lake, along with SQL Server, SSIS, PostgreSQL, and Snowflake. I thrive on turning complex data challenges into scalable architectures and actionable insights.

I collaborate with business stakeholders to translate needs into robust data models and dashboards using Power BI and Tableau, drive performance improvements on terabyte-scale databases through partitioning and tuning, and streamline development with Git, automation, and comprehensive test plans. My goal is to deliver reliable data foundations and intuitive analytics that empower strategic decision-making.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Intermediate

Intermediate

Intermediate

Language

English

Fluent

Work Experience

Data Engineer at TD Bank, TBSM Technology

November 1, 2023 - November 1, 2025

Engineered new ETL pipelines using Databricks Notebooks and PySpark to process hundreds of files from Azure Data Lake, automating liquidity data loads for regulatory reporting. Designed ETL processes using Azure Data Factory and Azure SQL Database. Built complex Power BI dashboards and Dataflows with DAX and Power Query M; created reusable reporting components for business stakeholders. Optimized 64TB SQL Server databases through partitioning, materialized views, aggregated tables, and removal of billions of old records, significantly improving manageability and query performance. Diagnosed and resolved deadlocks and performance bottlenecks using SQL Monitor; tuned T-SQL, SSIS packages, and PostgreSQL code. Built and configured AutoSys jobs using JSON/JIL and custom Pipeline APIs; coordinated deployments with Production Support teams. Accelerated development with GitHub Copilot and advanced Git workflows (Pull Requests, code reviews, branching).Developed Power Apps forms and Power Auto

Senior Data Engineer at Toromont CAT (Contract via Eagle/SiSystems)

January 1, 2019 - April 1, 2023

Re-engineered invoice data ETL processes with incremental updates across DB2 and SQL Server, dramatically reducing load times and resource consumption. Designed Databricks PySpark pipelines to load data from SAP, Excel files and transform it for Power BI reports. Storage was on AWS S3. Built automated pipelines to ingest data from SAP and Excel into Databricks using cloud object storage (AWS S3 / ADLS). Designed Azure Data Factory workflows to ingest daily file drops from Azure Data Lake. Designed process to load data from Databricks into Snowflake Cloud storage. Improved database performance through partitioning, index redesign, and SQL tuning; resolved deadlocks using RedGate SQL Monitor. Built Power BI reports with DAX and Tableau dashboards to monitor job duration and invoice processing metrics. Developed PostgreSQL procedures to transform driver message data for SQL Server consumption and Power BI visualization. Created Python scripts for file validation, automation, and data visu

Senior Database/ETL Developer at Scotiabank

March 1, 2018 - December 1, 2018

Modified ETL procedures in Sybase to support IFRS 9 compliance, incorporating new fields (Days Past Due, Interest Rate, Maturity Date). Optimized long-running queries and reduced transaction overhead through index changes and deadlock resolution using Extended Events and Deadlock Graphs. Built Tableau dashboards and Spotfire reports to monitor daily IFRS data load processes.

SQL Database/ETL Developer at Royal Bank of Canada

April 1, 2017 - December 1, 2017

Designed and implemented incremental load solution for 150M+ trade records using SQL Server ROWVERSION, replacing daily full loads and enabling reports 3–4 hours earlier. Migrated three Sybase databases to SQL Server, including procedures and data. Built SSIS packages with C# script tasks and implemented table partitioning to improve performance. Built SSRS dashboards.

Senior ETL/SQL Developer / Data Migration Specialist / Data Conversion Specialist at Bond Brand Loyalty, TD Wealth, TD Securities, BMO, Golder Associates

January 1, 2013 - January 1, 2016

Designed high-performance ETL processes for reconciliation (SmartStream), FATCA compliance, and Anti-Money Laundering reporting using SSIS, SQL Server, Netezza SQL, and shell scripting. Optimized SSIS packages with parallel processing, threading, and BCP loads; implemented data masking for test environments. Built automated monitoring reports (SSRS, Spotfire, Tableau) and mentored junior developers on tools and workflows.

ETL Architect / Data Migration Specialist at CIBC, Scotiabank, Royal Bank of Canada, TD Securities, Golder Associates

January 1, 2004 - January 1, 2012

Led ETL architecture redesigns, data migrations, data conversions, and performance tuning for market risk, trade finance, and Basel II compliance projects. Migrated legacy DTS/Perl processes to SSIS; designed reusable packages for multiple data feeds (text, XML, queries). Developed SSRS dashboard reports for risk analysis (Interest Rate, Credit, Currency, Commodity Risk).