Stanford Pugsley, Developer in Salt Lake City, UT, United States
Stanford is available for hire
Hire Stanford

Stanford Pugsley

Verified Expert  in Engineering

BI, Data Warehouse Developer

Location
Salt Lake City, UT, United States
Toptal Member Since
June 15, 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.

Data Warehouse DesignData AnalysisData CleansingData EngineeringSQLDatabasesMicrosoft SQL ServerPostgreSQLSnowflakeCustomer Relationship Management (CRM)GraphDBData PipelinesOracleJiraGitDimensional ModelingNeo4j

Portfolio

Pfizer - PGS Operations Insights
Data Engineering, SQL, ETL, Data Modeling, PostgreSQL, Linux, Redshift, Cypher...
University of Utah
Databases, Visualization, Modeling
Deloitte
BI Reporting, SQL, Redshift, Tableau

Experience

SQL - 20 yearsETL Tools - 10 yearsData Warehouse Design - 10 yearsMicrosoft SQL Server - 10 yearsMicrosoft Azure - 4 yearsSnowflake - 2 yearsNeo4j - 2 yearsTableau - 2 years

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.

Work Experience

Data Engineer

2021 - PRESENT
Pfizer - PGS Operations Insights
  • Worked for a global pharmaceutical company. Modeled a Neo4j graph database to track Pfizer supply chain movements. Created ETL to load the database.
  • Created coding standards and reviewed the code from other projects.
  • Oversaw the launch of the graph database to 20+ users. Supported production ETL jobs to meet SLA.
Technologies: Data Engineering, SQL, ETL, Data Modeling, PostgreSQL, Linux, Redshift, Cypher, Data Pipelines, Neo4j, Data Architecture, Data Transformation, Python, DevOps, Git, Data Warehouse Design, SAP HANA, Modeling

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

Business Intelligence Engineer

2021 - 2021
Deloitte
  • Designed reports for the internal project management dashboard.
  • Worked with an international team to collect requirements and prototype solutions.
  • Worked with the data warehouse support team to expand and enhance the data warehouse for reporting and analysis.
Technologies: BI Reporting, SQL, Redshift, Tableau

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, ETL, Data Modeling, Data Pipelines, Data Engineering, Data Architecture, Data Transformation, Python, DevOps, Git, Data Warehouse Design, SAP HANA, Visualization

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, ETL, Data Architecture, Data Warehouse Design, SEO Marketing, Social Media Analytics, Visualization

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

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.

Data Engineering for Data Warehouse and Graph DB Projects

Created ETL pipelines and data models for a global pharmaceutical company. The client renewed my contract several times and extended my scope to a lead architect and engineering role. Technologies used included Snowflake, PostgreSQL, Airflow, Python, Neo4j and Redshift.

Languages

Snowflake, SQL, Cypher, Python

Paradigms

Dimensional Modeling, DevOps, ETL

Storage

Databases, Microsoft SQL Server, PostgreSQL, Data Pipelines, Neo4j, Redshift

Other

Microsoft Azure, ETL Tools, Data Modeling, Data Warehouse Design, Data Transformation, Data Engineering, Data Architecture, Data Analysis, Data Cleansing, Social Media Analytics, Analysis, Reporting, Customer Relationship Management (CRM), Data Build Tool (dbt), Visualization, Modeling, GraphDB, Business, BI Reporting, Spanish-English Translation, SEO Marketing

Tools

Jira, Tableau, Git, Microsoft Power BI

Platforms

Oracle, SAP HANA, Linux

2000 - 2002

Master's Degree in Information Systems

University of Arizona - Tucson, Arizona, USA

1991 - 1996

Bachelor's Degree in Chemistry

Brigham Young University - Provo, Utah, USA

AUGUST 2022 - PRESENT

Neo4j Certified Developer

Neo4j

OCTOBER 2020 - PRESENT

Tableau Desktop Specialist

Tableau

MAY 2020 - MAY 2022

Snowflake SnowPro

Snowflake

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