INFRA · 1 month ago
BI Analyst
Saint Paul, MN
Full-time
Hybrid
Entry, Mid Level
$65K/yr - $95K/yr
2+ years expINFRA is seeking a skilled Business Intelligence (BI) Analyst to join our grocery industry service association. In this role, you will focus on generating reports, developing visualizations, and conducting data analysis to help drive key business decisions.
ConsultingGroceryPoint of SaleRetail
Responsibilities
Engage with users to understand their business needs, brainstorm solutions, and translate requirements into actionable data models
Educate and guide users in leveraging BI tools effectively to meet their goals
Create visualizations and prototypes to demonstrate how data insights can address user challenges
Contribute to and work within the organization’s data warehouse to structure and prepare data for BI tools and reporting
Develop Power BI semantic models using fact and dimension tables in a star schema
Write and performance-tune complex SQL queries and DAX measures to enable insightful analysis on large datasets
Use dashboards and visualizations to effectively communicate the story behind the data
Engage stakeholders to determine how best to present and visualize information for business insights
Design and build dashboards and data visualizations for internal and external purposes using diverse data sets
Administer Power BI workspaces, apps, and shared datasets, ensuring content is distributed effectively and securely
Configure Row-Level Security (RLS) to protect sensitive data and manage access
Monitor usage, configure data refresh, and optimize performance across the Power BI ecosystem programmatically via API
Collaborate with data team members to ensure semantic models align with the overall BI ecosystem
Stay current with and apply emerging tools and technologies in the Power BI and data analytics space
Contribute to the team’s adoption of advanced tools and practices, such as Microsoft Fabric, Azure Data Factory, Power Automate, and external Power BI tools
Developing large semantic models used for reporting to internal and external audiences that also enable self-service reporting within the organization
Contributing to the rollout of embedded analytics and reporting on company platforms
Collaborating with business users to define KPIs and logic used to measure success of INFRA’s purchasing and service programs, and providing education to business users on how to leverage INFRA’s data to enhance the services provided to our members
Qualification
Required
2-5 years Demonstrated deliverables and experience with service-based organizations
Strong user-centric approach
Experience seamlessly working with users to translate needs and technology opportunities, including using visualization where helpful
Teaching and brainstorming while serving users
Gathering business requirements and collaborating with stakeholders to design and implement a well-structured data model
Collaboration with data team members to ensure semantic models fit into the overall BI ecosystem
Creating Power BI semantic models using fact and dimension tables following star schema design
Creating and performance-tuning complex DAX measures for aggregations and time intelligence on large semantic models
Writing complex SQL queries to ingest data for modelling and ad-hoc analysis
Configuring Row-Level Security (RLS) on Power BI semantic models
Using Git for version control
Administering Power BI workspaces and distributing content via apps and shared datasets, including monitoring usage and configuring data refresh via API
Preferred
Preferred experience in the food industry or retail
Preferred familiarity with Azure Data Factory, Power Automate, Dynamics CRM, Azure Data Lake Storage (ADLS), SQL Server Management Studio (SSMS), Git
Preferred familiarity with external Power BI Tools such as Tabular Editor, DAX Studio, and Measure Killer
Preferred familiarity with Microsoft Fabric and how Power BI fits in
Preferred familiarity with Power BI Embedded
Benefits
Paid flexible time off
Health, dental, vision, disability, and life insurance
Health savings account
401(k) retirement plan contributions
And more.
Company
INFRA
INFRA is a boutique firm that provides grocery retail, education, promotions, retail marketing, POS, and consulting services.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Patrick Sheridan
President & CEO
Recent News
2026-01-22
KeHE Distributors
2025-07-31
Company data provided by crunchbase