Kreg Tools Business Intelligence Engineer in Huxley, Iowa

Business Intelligence Engineer


Huxley, IA

Job Id:


of Openings:


Kreg Tool continues to grow!

Kreg Tool is an employee owned company that manufactures a wide variety of tools, accessories, and equipment for woodworkers and do-it-yourselfers. Our products are available throughout North America and in the nation’s major Home Improvement stores such as Lowe’s, Home Depot, and Menards. Our core focus is to make our customers raving fans, contribute positively to the community & economy, and assist employees in achieving personal growth and success.

Headquartered in Huxley, IA (just off I-35 between Des Moines and Ames), we offer an entrepreneurial environment, casual dress code, and a competitive compensation package which includes base pay, semi-annual bonuses, and full benefits. We are experiencing rapid growth and employ over 190 employees. Kreg Tool is an Equal Opportunity Employer. Successful completion of a criminal background check and pre-employment drug test are required to be qualified for employment. We currently have the following position open:


The Business Intelligence Engineer is a key member of the Information Technology team building business intelligence, data warehousing, and analytics capabilities across Kreg Tool. The role utilizes a broad skill base in business intelligence, software development, data warehousing, analytics, and data visualization.

Essential Job Functions:

  • Responsible for the architecture, design, implementation, operations, and ongoing management of multiple BI tools and related systems within the enterprise data warehouse.

  • Effectively maintain and manage the data warehouse reporting environments (Development and Production) including: installation, configuration, patching (software and security), maintenance, user management, and report management.

  • Collaborate with business customers to gather and document business requirements for reporting, business intelligence, programming and analytical needs.

  • Provide leadership in data architecture, modeling, schema design, ETL and universe design

  • Create, maintain, and support complex reports, dashboards with multipart formulas, stored procedures, custom tables and customized functions.

  • Define and create ETL mapping and process flows, as well as provide daily production support to report processes and end-user community.

  • Mentor other team members on data integration, design, and report/dashboard development.

  • Respond to user ad-hoc requests for data, advising and assisting with options for providing relevant information.

  • Assist to create mockups and prototypes that conform to the best practice information architecture and user interface design.

  • Write and maintain technical specifications.

  • Document and research production issues and coordinate timely resolution.

  • Assist with special software development and integration projects as needed.

  • Provides support services for management staff.

  • Utilizes computer for data entry, word processing, and research as needed.

  • Non-material handling may include reaching at all levels to desk, cupboards, file cabinets, etc. for supplies; squatting and bending to stock paper in copier or put away supplies; climbing stairs to other departments.

  • Material handling may include putting away supplies such as boxes of paper and office supplies.


  • Technical/Professional Knowledge

  • Technology Savvy

  • Quality Orientation

  • Planning & Organizing

  • Managing Work

  • Decision Making

  • Continuous Learning

  • Adaptability

  • Customer Orientation

  • Building Partnerships

Education and/or Experience:

  • Bachelor’s Degree in Engineering, Computer Science, Management Information Systems/Science required or similar combination of education and experience.

  • 5+ years of data warehousing and analytics experience required, preferably using Microsoft SQL Server, SQL Server Reporting Services (SSRS), Tableau, SAP Business Objects Enterprise.

  • 5+ years of experience with dimensional data modeling & schema design in Data Warehouses

  • 5+ years of data integration experience with ETL and APIs.

  • 3+ years experience with multiple programming languages (Python, Java, R)

  • Experience with a variety of web service technologies (REST, SOAP, XML, JSON)

  • Thorough understanding of SQL development, stored procedures, functions, and ETL (SSIS, SAP Data Services).

  • Experience and understanding of database administration and standardized Data Warehousing Concepts.

  • Experience with SAP Business Objects Enterprise administration.

  • Experience with XML, Business Intelligence Tools, Dashboards, analytical manipulation and interpretation of large databases.

Other Skills and Abilities:

  • Good time management and organizational skills; ability to complete multiple reports for multiple projects on time and in scope.

  • Possession of excellent analysis and data gathering skills.

  • Possession of excellent oral and written communication skills.

  • Good at face-to-face customer service.

  • Projects self-confidence, enthusiasm, and a positive, can do attitude.

  • Excellent problem solving, troubleshooting, organization, time management and communication skills

  • Must be able to respond flexibly to changing circumstances.

  • Self-motivated and able to prioritize requests and take ownership of tasks from origination to resolution.

  • Availability to work during off peak work hours when necessary to insure smooth operations during office hours may include on-call support.

  • Committed to company values.

  • Must be committed to the success of the entire organization.