Business Intelligence Analyst I

Snap On; Wisconsin; On-site; USD 60,000 - 85,000; Full time

Job summary

Snap On in Kenosha, WI is seeking a Business Intelligence Analyst I to design, build, and support moderate‑complexity reporting solutions. You will translate business needs into Power BI reports, data models, and reusable datasets while ensuring data accuracy and timely delivery.

The role collaborates with business partners and data engineers, working with guidance from senior analysts on standards and priorities to deliver reliable BI solutions.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Science, MIS, or closely related field.
• 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 similar enterprise BI platform.
• Working knowledge of SQL for querying and validating data.
• Understanding of basic data modeling concepts (tables, joins, keys, measures, dimensions).

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.

Skills

Power BI

SQL

Data analysis

Data modeling

Education

Bachelor's degree in CS/IS/Data Science/MIS or related field

Tools

Power BI (reports)

SQL queries

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