Stanford Pugsley, BI, Data Warehouse Developer in Salt Lake City, UT, United States
Stanford Pugsley

BI, Data Warehouse Developer in Salt Lake City, UT, United States

Member since February 1, 2021
Stanford is an accomplished data warehouse ETL engineer, consultant, and data architect with nearly 20 years of experience building highly scalable data solutions in the cloud and on-premises. He excels in leading client and internal teams through the adoption of business intelligence, integration, data strategy, and data governance programs using agile development methodologies. Stanford shares his knowledge as an adjunct instructor in the University of Utah Information Systems program.
Stanford is now available for hire

Portfolio

Experience

Location

Salt Lake City, UT, United States

Availability

Part-time

Preferred Environment

Snowflake, Microsoft Azure, Jira, SQL, ETL Tools, Tableau, Microsoft Power BI, DevOps

The most amazing...

...project I have delivered was for a non-profit online university. We used data to improve retention and graduation rates for students.

Employment

  • Lecturer

    2021 - PRESENT
    University of Utah
    • Taught since 2019. Promoted in 2021 from adjunct to assistant professor.
    • Instructed classes at the undergraduate level in big data and business analytics.
    • Taught classes in database theory and design at the graduate (master's degree) level.
    Technologies: Databases, Visualization, Modeling
  • Senior Consultant and Data Architect

    2017 - 2021
    Eide Bailly Technology Consulting
    • Served as a hands-on leader for a team of data warehouse architects and ETL engineers.
    • Specialized in cloud data migrations and big-data projects.
    • Focused on technologies including Snowflake, Microsoft Azure SQL, dbt Cloud (Fishtown Analytics), Tableau, and PowerBI.
    • Performed Kimball data warehouse star-schema modeling for reporting and analysis.
    Technologies: SQL, ETL Tools
  • Vice President

    2013 - 2017
    Brighton Homes Utah
    • Acted as the head of technology, marketing, and client services.
    • Implemented ERP and CRM software. Oversaw data integration and reporting.
    • Built sales and pricing processes, managed purchasing and configured IT systems to enable growth of real estate development business from new startup to over 100 homes a year.
    Technologies: Customer Relationship Management (CRM), Microsoft SQL Server
  • Senior Director, Analytics and Data Warehouse Consultant

    2005 - 2013
    iCrossing
    • Served as architect and product manager for a SaaS business intelligence product for data integration and reporting.
    • Implemented data warehouse design and ETL coding using Kimball Methodology in star schema designs.
    • Managed up to 15 client-facing resources across four offices to deliver analytics and recommendations.
    • Led over 50 data integration and analysis projects. Clients include LG, Pfizer, Hilton, AAA, and Vail.
    Technologies: BI Reporting, Databases, Oracle
  • Business Intelligence Analyst

    2002 - 2005
    HP
    • Designed and implemented a data warehouse design to extract, transform, and load data (ETL).
    • Created reports for business users; specified and reviewed SQL code for offshore engineers.
    • Used technologies such as Oracle RDBMS, Informatica, and Business Objects.
    Technologies: ETL Tools, SQL

Experience

  • Student Analytics at Independence University

    I architected and created the ETL process for a data warehouse and reporting solution for higher education. The goal was to develop 360-degree awareness of student recruiting, onboarding, retention, and graduation. We created pipelines from five applications into the Snowflake-based data lake, then ETL transform scripts to a data warehouse.

  • SAP HANA and Tableau - Architecture and Reporting Project

    One of the world's largest professional services firms contracted me to design and build a "single source of truth" dashboard for their marketing department. With over 1,000 active users, the Tableau dashboard is highly visible and mission-critical for planning and measuring results for marketing campaigns.

Skills

  • Languages

    Snowflake, SQL
  • Paradigms

    Dimensional Modeling, DevOps, ETL
  • Storage

    Databases, Microsoft SQL Server, Data Pipelines
  • Other

    Microsoft Azure, ETL Tools, Data Modeling, Data Warehouse Design, Data Transformation, Analysis, Reporting, Customer Relationship Management (CRM), Data Build Tool (DBT), Business, BI Reporting, Matillion ETL, Spanish-English Translation, Visualization, Modeling
  • Tools

    Jira, Tableau, Git, Microsoft Power BI
  • Platforms

    Oracle, SAP HANA

Education

  • Master's Degree in Information Systems
    2000 - 2002
    University of Arizona - Tucson, Arizona, USA
  • Bachelor's Degree in Chemistry
    1991 - 1996
    Brigham Young University - Provo, Utah, USA

Certifications

  • Tableau Desktop Specialist
    OCTOBER 2020 - PRESENT
    Tableau
  • Snowflake SnowPro
    MAY 2020 - MAY 2022
    Snowflake

To view more profiles

Join Toptal
Share it with others