Experience

Timothy Werner in professional attire

Professional Summary

As a passionate Data Warehouse Architect with a proven track record of crafting and optimizing scalable, cloud-based data solutions, I bring a unique blend of technical expertise and creative problem-solving to every challenge. With a deep understanding of ETL processes, database design, and modern BI tools, I excel at translating complex business requirements into intuitive, actionable data pipelines and presentation layers.

I've consistently delivered high-performance analytics solutions that empower organizations to make smarter decisions. With over a decade spent designing successful, impactful solutions across diverse industries, I'm a lifelong learner and I'm seeking to leverage my skills to drive meaningful impact at a forward-thinking company ready to embrace data-driven success.

Experience Timeline

And beyond!
2025

Analytics Engineer

Feb. 2025 - Present

Building modern data warehouse solutions with Snowflake and DBT, transforming legacy Salesforce reporting into intuitive self-service analytics.

Responsible for silver and gold layers in Snowflake enterprise data warehouse using medallion architecture. Engage with stakeholders to modernize legacy Salesforce reporting into delightful user experiences. Design star schema models in DBT and provide operational reporting through Sigma.

  • Modernized legacy Salesforce reporting infrastructure
  • Implemented medallion architecture in Snowflake
  • Built self-service analytics capabilities with Sigma
2021

Staff Data Warehouse Architect

Oct. 2021 - Feb. 2025

Architected cloud-native data infrastructure for healthcare startup, implementing HIPAA-compliant BigQuery warehouse with automated DBT workflows.

Led design and implementation of BigQuery cloud data warehouse with Looker LookML presentation layer for healthcare software startup. Developed orchestrated data transformations using DBT with CI/CD automation.

  • Architected HIPAA-compliant data lake and warehouse
  • Implemented Infrastructure as Code for environment promotion
  • Automated DBT workflows with GitHub Actions
  • Balanced data freshness with cloud cost optimization
2020

Business Intelligence Engineer

Feb. 2020 - Oct. 2021

Delivered PowerBI solutions for fitness industry clients, implementing Kimball methodology across Redshift and SQL Server environments.

Administered multiple PowerBI workspaces for fitness industry clients. Created DAX measures and data transformations while implementing Kimball star schema methodology across Redshift and SQL Server environments.

  • Designed star schema data warehouses using Kimball methodology
  • Advanced PowerBI model manipulation with Tabular Editor
  • Created BUS matrix and source-to-target mapping documentation
  • Managed offshore development teams
2018

BI Reporting Specialist

Jan. 2018 - Feb. 2020

Internal promotion from previous BI Developer role

Advanced to lead comprehensive BI solutions for enterprise billing platform, creating custom reporting applications with JavaScript and Domo API integration.

Advanced within the company to architect BI reporting solutions for greenfield enterprise billing software project. Built interactive single-page applications using JavaScript/HTML/CSS with Domo API integration.

  • Designed star schemas and ETL processes using Kimball methodology
  • Built custom reporting applications with Domo APIs
  • Implemented multi-tenancy architecture for client data separation
2015

Business Intelligence Developer

Nov. 2015 - Jan. 2018

Developed Oracle-based analytics solutions and PowerPivot models, leading modernization from legacy Access systems to Java web applications.

Developed Oracle SQL queries and Excel VBA code for PowerPivot data models. Led development of Java web application to replace legacy Access-based systems.

  • Automated data pipelines with DAX for enterprise reporting
  • Built Java web application with Oracle data layer
  • Modernized scheduling systems from Access to web-based solution
2013

Software Engineer

Oct. 2013 - Nov. 2015

Specialized in HIPAA-compliant BI reporting for electronic medical records, training clients on SQL and developing financial applications with Spring/Java.

Specialized in DB2 SQL queries for BI reports within electronic medical record application. Conducted client training on SQL and ad-hoc reporting while maintaining HIPAA compliance.

  • Developed HIPAA-compliant BI reports for EMR system
  • Trained clients on SQL basics and ad-hoc report creation
  • Co-developed financial accounting application using Spring/Java
And beyond!
2024

Odd Slots v1 Released

December 2024

Odd Slots version 1 is released on Google Play Store!

Spider Defense Squad v2 Released

April 2024

Spider Defense Squad version 2 is released, entirely rewritten in Godot

2023

Odd Slots Development Begins

August 2023

Godot development of Odd Slots begins

Godot Rewrite Begins

February 2023

Godot rewrite of Spider Defense Squad begins!

2022

Spider Defense Squad v1 Released

September 2022

Spider Defense Squad version 1 is released on Google Play and iOS App Store!

2021
2020
2019
2018

Game Development Journey Begins

January 2018

Started learning game design with Gamemaker Studio and GML

Timothy Werner outdoor portrait

Technical Skills

ETL/SQL

DBT, Snowflake, GCP BigQuery, Data Warehouse, Data Vault, Oracle, NoSQL, IBM DB2, AWS Redshift, Postgres, Pentaho

Business Intelligence Tools

Sigma, Looker, Domo, Quicksight, PowerBI, Excel VBA, DAX, BIRT, Stimulsoft, Sisense, WebFocus

Cloud Computing/Orchestration

GCP, AWS, Azure, Docker, Kubernetes, Airflow

Game Development

Unity, C++, OpenGL, TypeScript, HTML5 Canvas, Flutter/Flame, Godot, Shaders

Programming Languages

Backend:

Python, Java, TypeScript, C++, Spring, Hibernate

Frontend:

Javascript, Jinja, Jquery, HTML, CSS, ReactJS

Business Skills

Accounting, Sprint Planning, Agile, Driving communication to define and deliver a specific solution

Timothy Werner indoor portrait

Education

University of Arkansas at Little Rock

Bachelor of Business Administration - Accounting