Lecturer
2021 - PRESENTUniversity 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, ModelingSenior Consultant and Data Architect
2017 - 2021Eide 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 ToolsVice President
2013 - 2017Brighton 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 ServerSenior Director, Analytics and Data Warehouse Consultant
2005 - 2013iCrossing- 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, OracleBusiness Intelligence Analyst
2002 - 2005HP- 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
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
- University of UtahDatabases, Visualization, Modeling
- Eide Bailly Technology ConsultingSQL, ETL Tools
- Brighton Homes UtahCustomer Relationship Management (CRM), Microsoft SQL Server
Experience
- Analysis 14 years
- ETL Tools 10 years
- Microsoft SQL Server 10 years
- BI Reporting 5 years
- Microsoft Azure 4 years
- Snowflake 2 years
- Tableau 2 years
- Microsoft Power BI 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.
Employment
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, SQLParadigms
Dimensional Modeling, DevOps, ETLStorage
Databases, Microsoft SQL Server, Data PipelinesOther
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, ModelingTools
Jira, Tableau, Git, Microsoft Power BIPlatforms
Oracle, SAP HANA
Education
- Master's Degree in Information Systems2000 - 2002University of Arizona - Tucson, Arizona, USA
- Bachelor's Degree in Chemistry1991 - 1996Brigham Young University - Provo, Utah, USA
Certifications
- Tableau Desktop SpecialistOCTOBER 2020 - PRESENTTableau
- Snowflake SnowProMAY 2020 - MAY 2022Snowflake
