Business Analyst I

Snap-on Incorporated; Kenosha (WI); On-site; USD 60,000 - 90,000; Full time

Job summary

Snap-on Incorporated in Kenosha, WI is seeking a Business Intelligence Analyst I to design, build, and support reporting solutions of moderate complexity. This onsite role partners with business teams to clarify needs, develops Power BI reports and data models, and ensures data reliability for decision-making.

You will translate requirements into specs, create dashboards and datasets, write SQL queries, validate reports, and support data readiness across teams under senior guidance.

Qualifications

• Bachelor’s degree in CS, IS, data science, MIS or related field; equivalent experience acceptable.
• 1–4 years of professional BI, reporting, data analysis, or app development.
• Hands-on experience building Power BI reports and dashboards.
• Working knowledge of SQL for data querying and validation.
• Understanding of basic data modeling concepts (tables, joins, keys, measures, dimensions).

Responsibilities

• Translate business requirements into clear report specifications with metrics and visuals.
• Develop and maintain Power BI dashboards, paginated reports, and reusable datasets.
• Create data models and DAX measures to support reporting needs.
• Write and validate SQL queries to retrieve and transform data.
• Test and reconcile reports against source systems; monitor refreshes and performance.
• Document owned reports and data transformations; collaborate to improve data readiness.
• Partner with data engineering and business teams to resolve data issues.

Skills

Power BI

SQL querying

Data modeling

DAX measures

Stakeholder communication

Education

Bachelor’s degree in Computer Science, Information Systems, Data Science, MIS

Equivalent work experience accepted

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