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 processes.Responsible for ensuring that technology is properly leveraged, and efficient and robust software release and management processes are followed.Work with product owners, data owners, analysts, functional leadership and scrum/project resources to build solutions that are aligned with business needs.

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 wide variety of data sources using relational, NoSQL, and cloud technologies.Partner with analytics and business to discover opportunities within new data sources and deliver the data.Work with partners including Infrastructure, Applications, and Analytics teams to assist with data-related technical issues and support their data needs.Collaborate with other teams to design and develop data tools that support operational and analytical uses cases.Design and manage data warehouse improvement and growth projects.Identify data discrepancies and data quality issues, and work with data stewards to ensure data consistency and integrity through proper data lineage tracking and governance projects.Diagnose and resolve data warehouse access and performance issues.Execute data warehouse configuration and performance tuning.Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.Develop, implement, and maintain change control and testing processes for modifications to data systems.Document the data architecture and environment in order to maintain a current and accurate view of the larger data picture.Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes.

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 Tableau and Domo reporting tools.Designed, implemented, and maintained a large-scale reporting model which delivered fast and accurate data at multiple grain levels to a dynamic sales force.Implemented dynamic data backend structure to support front end user input experience critical to business success.Delivered new front-end reports for internal and external users with Tableau and Domo reporting tools.

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 comprehensive post promotion analysis in regards to ROI, baseline rises, trends and other quantitative indicators.

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.