Power BI Analyst — Data Automation & Insights Lead

IJW Whiskey Company; Louisville (KY); On-site; USD 90,000 - 120,000; Full time

Job summary

IJW Whiskey Company is seeking a Power BI Analyst to build and improve reporting and automation across our organization. The role focuses on Microsoft Power BI and Power Automate, creating dashboards that help teams understand data and workflows that reduce manual work.

You will collaborate with business teams to identify needs, connect data from ERP, SQL databases, and SharePoint, and deliver practical solutions. The position supports both the Los Angeles and Louisville offices.

Qualifications

• 5+ years of experience in business systems analysis, business intelligence, reporting, process automation, or a related role.
• Hands‑on experience building and maintaining Power BI dashboards, including Power Query, data modeling, and DAX.
• At least 1 year of hands‑on experience creating and supporting workflows in Microsoft Power Automate.
• Working knowledge of SQL and experience using data from multiple business systems.
• Ability to gather requirements from nontechnical stakeholders and turn them into reports or automated workflows.
• Experience checking data accuracy, troubleshooting issues, and documenting solutions.
• Strong organization and communication skills, with the ability to manage multiple requests and work across teams.
• Experience working with ERP data or applications, such as SAP, QuickBooks, or similar systems, is preferred.
• Experience with SharePoint and other Microsoft 365 tools is preferred.
• Bachelor’s degree in Computer Science, Information Technology, Business Analytics, or a related field is preferred.

Responsibilities

• Work with business teams to understand reporting needs, manual processes, and opportunities for improvement.
• Build and maintain Power BI dashboards and reports for operational and leadership teams.
• Connect and prepare data from ERP systems, SQL databases, spreadsheets, SharePoint, and other business applications.
• Create data models and DAX measures; check data accuracy and resolve reporting discrepancies.
• Build and maintain Power Automate workflows for approvals, notifications, data movement, and other recurring tasks.
• Test, monitor, and troubleshoot reports and workflows, including data refreshes and failed flows.
• Manage report access and work with IT on data access and security requirements.
• Support reporting and automation needs during ERP implementations and other system projects, including testing and rollout.
• Document reports, workflows, and processes, and help users adopt new tools.
• Prioritize requests and coordinate with stakeholders, IT, and external vendors to deliver updates.

Skills

Power BI

Power Automate

DAX

SQL

ERP data experience

SharePoint

Education

Bachelor’s degree in Computer Science, Information Technology, Business Analytics, or a related field

Tools

SAP

QuickBooks

SharePoint

Microsoft 365

Job description

IJW Whiskey Company is seeking a Power BI Analyst to build and improve reporting and automation across our organization. The role focuses on Microsoft Power BI and Power Automate, creating dashboards that help teams understand data and workflows that reduce manual work.

You will collaborate with business teams to identify needs, connect data from ERP, SQL databases, and SharePoint, and deliver practical solutions. The position supports both the Los Angeles and Louisville offices.