Looking for a job

Bryan Lemmer

@bryanlemmer

Senior Data Engineer at Umpqua Bank building Snowflake and multi-cloud data platforms across AWS and Azure.

At Umpqua Bank, I designed a Snowflake warehouse orchestrated by Azure Data Factory, with governed ingestion from Oracle, SQL Server, files, Blob Storage, and ADLS. I built Bronze, Silver, and Gold processing and automated CSV ingestion into Azure Databricks Delta tables.

I also designed AWS Glue pipelines and S3 data zones for Amazon Redshift analytics, and maintained Azure DevOps repositories and YAML release pipelines. Previously, at UTi Worldwide Inc., I supervised a global ETL team across three countries and delivered operational data stores for operations and Oracle Financials.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Engineer

Current

Umpqua Bank

Mar 2023 - Present (3 years 7 months)

Designed and implemented a Snowflake warehouse orchestrated by Azure Data Factory, reducing data latency by 4%. Built Bronze, Silver, and Gold processing layers and automated Python ingestion into Databricks Delta tables.

Snowflake Azure Data Factory Azure Databricks Delta Tables Unity Catalog Python AWS Glue S3 Amazon Redshift AWS Lambda Azure DevOps YAML SQL ETL ELT Data Warehouse

Enterprise Data Engineer IV

Umpqua Bank

Aug 2019 - Mar 2023 (3 years 7 months)

Developed enterprise data pipelines and fraud-system processing, improving production workflow reliability. Migrated SQL Server databases and SSIS packages to SQL Server 2017 and led source-control migration to Azure DevOps and Git.

SQL Server SSIS Snowflake Azure Azure DevOps Git TVC TFC ETL Data Pipelines Fraud Detection Reporting

SQL/ETL Developer

Umpqua Bank

Aug 2018 - Aug 2019 (1 year)

Built SQL Server and SSIS ETL processes for CECL regulatory processing and email marketing analytics. Produced and consumed CSV files through SSIS, connected with Moody's, and scheduled production execution through JAMS.

SQL Server T SQL SSIS JAMS CSV ETL Data Marts CECL Marketing Analytics

Data Warehouse Lead ETL Lead

UTi Worldwide Inc.

Jul 2011 - Dec 2017 (6 years 5 months)

Supervised a three-country ETL team across the US, India, and South Africa. Designed DataStage and SQL Server ETL frameworks and delivered two ODS platforms for operations and Oracle Financials.

IBM DataStage SQL Server ETL Data Warehouse ODS SOX JAD Team Leadership Finance Revenue Recognition

ETL Developer

UTi Worldwide Inc.

Mar 2009 - Jul 2011 (2 years 4 months)

Enhanced Oracle PL/SQL packages and functions and developed IBM Cognos Data Manager jobstreams, reducing batch runtime by 4%. Created fact and dimension models from analytical requirements.

Oracle Pl SQL IBM Data Manager Cognos Report Studio SQL Data Warehouse ETL

IT Consultant

GoodConnection Ltd

Dec 2008 - Jan 2009 (1 month)

Developed separate Data Access and Business Logic layers for a web application, centralizing database operations and validation rules and improving maintainability by 5%.

Data Access Layer Business Logic Web Applications Database Operations Validation

Web Applications Developer

Digital Response Media

Apr 2006 - Sep 2008 (2 years 5 months)

Built an order-management application for order creation, tracking, PDF quotations, revenue views, and threshold-based approvals, reducing manual sales-administration effort by 8%. Developed a webservice for lead-generation submissions and the Cloud9 self-service reporting portal.

Web Applications Order Management PDF MDX SQL Server VBScript MS Access Web Services