Scott Hillstrom Email & Phone Number

Delaware, United States

Cottage Grove, Minnesota, US

Technical leadership for data engineering services including data modeling, data warehouse architecture and administration, and ETL pipelinesManage data engineers/developers and drive the technical solutions in support of various business services including analytics, reporting, external data ingestion, data integration, and automation of manual data.

Cottage Grove, Minnesota, US

Lead Data Vault 2.0, warehouse, and pipeline implementation and adoptionLead and mentor junior data engineers on projects and practicesCreate Talend models for Snowflake data warehouse development and/or changes to existing data stores leveraging star schema and data modeling best practices.Build the infrastructure required for optimal ELT of data from a.

Provo, UT, US

• Hire and train a team of data engineers to support 4 business pillars.
• Cross Server migration Microsoft SQL Server to Snowflake.
• Implement automated collection and delivery of data in Snowflake as defined by the business through various ETL tools such as SSIS, AWS S3, Go Anywhere.
• Ensure best practices in data modeling and architecture for long term stability and scalability.

Provo, UT, US

Lead a team of Data Engineers and Analysts on delivering on the data needs of the Commissions/Payroll department.Responsibilities of managed team include: Implementing automation of collection and delivery of data as defined by the business through various ETL tools such as SSIS, Go Anywhere; Designing front end reports for internal and external users with.

Provo, UT, US

Manage a team of Incentive Management admins to develop plans and rules to enable commission pay for 6000+ payees in 6 different lines of business. Designed and implemented SSIS ETL processes to improve performance, saving over hundreds of hours of employee time. Manage SQL, Crystal, and Web Intelligence reports for payees and power users.

Provo, UT, US

Successfully managed a brand new implementation of CallidusCloud with integration into our company’s systems. Did parallel QA between dev and production and did production migration upon business sign off. Innovated business processes and practices for use with the product.

South Jordan, Utah, US

Provides business intelligence for multiple departments and markets throughout the company. Provide weekly analysis reports of multiple ongoing commission based projects. Works closely with Data Services to generate SQL reports for analysis. Performs pre analysis and gives approval for proposed company promotions centered on its commission plan. Performs.

Manages products and items in multiple Oracle Databases. Set up new products and item BOMs (Bill of Material) in multiple organizations throughout the system. Tracks the complete discontinuance of phasing out products. Provides analysis for potential product run out and potential purge costs.

Responsible for commission payment calculation, testing, and adjustments;international and domestic bank transfers. Assists in bank accountreconciliation, government levies and garnishment processing.Job improvements: streamlined job responsibilities, created job specific VBAexcel programs, improved on existing VBA excel programs for department.

Customer support to Chinese speaking customers.