Business Intelligence Analyst I

Snap-On Tools; Kenosha (WI); On-site; USD 60,000 - 80,000; Full time

Job summary

Snap-On Tools is seeking a Business Intelligence Analyst I to create and support reporting solutions at their Corporate Headquarters in Kenosha, WI. The successful candidate will translate business requirements and develop Power BI reports and data models while maintaining high standards of data quality.

This role requires a Bachelor's degree in a relevant field, with 1-4 years of experience in business intelligence or data analysis. Ideal candidates will have strong SQL skills and the ability to communicate effectively with stakeholders.

Qualifications

• 1–4 years of experience in business intelligence, reporting, or data analysis.
• Hands-on experience with Power BI or similar BI platforms.
• Working knowledge of SQL.

Responsibilities

• Translate business requirements into report specifications.
• Develop and maintain Power BI dashboards.
• Write and maintain SQL queries.

Skills

Power BI

SQL

Data Analysis

Communication

Data Modelling

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

SQL

Job description

Overview

This position is onsite at the Corporate Headquarters located in Kenosha, WI.

The Business Intelligence Analyst I designs, builds, and supports reporting and analytics solutions of moderate complexity. This role works with business partners to clarify needs, develops Power BI reports and data models, and helps ensure that data used for decision-making is accurate, timely, and well-documented. The position works with some independence but still receives guidance from more senior analysts on design, standards, and priorities.

Responsibilities

• Translate business requirements into clear report specifications, including metrics, filters, and visual layouts.
• Develop and maintain Power BI dashboards, paginated reports, and reusable datasets following BI team standards.
• Create and optimize basic to moderately complex data models and DAX measures to support reporting needs.
• Write and maintain SQL queries or use existing curated data models to retrieve and transform data for reporting.
• Perform thorough testing and validation of all new and updated reports, including data reconciliation to source systems.
• Monitor report refreshes and usage; assist in troubleshooting performance or data quality issues.
• Maintain documentation for owned reports, datasets, and data transformations, including data definitions and lineage.
• Collaborate with data engineering, application, and business teams to resolve data issues and improve data readiness.
• Contribute to the BI team’s standards, templates, and best practices; participate in peer reviews.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Management Information Systems, or a closely related field.
• A bachelor’s degree in a specifically related field is preferred; equivalent work experience is acceptable in place of this requirement.
• 1–4 years of professional experience in business intelligence, reporting, data analysis, or application development.
• Hands‑on experience building reports or dashboards in Power BI or a similar enterprise BI platform.
• Working knowledge of SQL for querying and validating data.
• Understanding of basic data modeling concepts (tables, joins, keys, measures, dimensions).
• Ability to organize work, manage multiple requests, and communicate clearly with both technical and non‑technical stakeholders.

Preferred Qualifications

• Experience with Power BI semantic models, row‑level security, and performance optimization.
• Exposure to enterprise data warehouse or cloud data platforms.
• Experience working within a structured SDLC, using tools such as Azure DevOps, Jira, or similar.
• Familiarity with data governance concepts and the use of shared or certified datasets.

Core Competencies

• Technical Proficiency – Builds reliable BI solutions using standard tools, patterns, and practices.
• Ownership – Takes responsibility for the quality and timeliness of assigned work and follows through on commitments.
• Customer Focus – Engages with stakeholders to understand needs, clarify requirements, and provide helpful support.
• Communication – Explains data and reporting concepts clearly to non‑technical audiences.
• Continuous Improvement – Looks for opportunities to simplify, standardize, and improve existing reports and processes