Power BI Analyst
Role Overview
Build and improve reporting and automation using Microsoft Power BI and Power Automate.
Work with business teams to understand needs, connect data from systems such as ERP applications and SharePoint, and deliver usable solutions.
The role is based in the Los Angeles, California, or Louisville, Kentucky, office and works with stakeholders, IT, and external vendors.
Key Skills for This Role
Full Job Posting
Position overview
Build and improve reporting and automation using Microsoft Power BI and Power Automate.
Work with business teams to understand needs, connect data from systems such as ERP applications and SharePoint, and deliver usable solutions.
The role is based in the Los Angeles, California, or Louisville, Kentucky, office and works with stakeholders, IT, and external vendors.
Responsibilities
- Understand reporting needs, manual processes, and improvement opportunities with business teams.
- 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; verify data accuracy and resolve reporting discrepancies.
- Build and maintain Power Automate workflows for approvals, notifications, data movement, and recurring tasks.
- Test, monitor, and troubleshoot reports and workflows, including data refreshes and failed flows.
- Manage report access and coordinate data access and security requirements with IT.
- Support reporting and automation 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 updates with stakeholders, IT, and external vendors.
Qualifications
- 5+ years of experience in business systems analysis, business intelligence, reporting, process automation, or a related role.
- Hands-on Power BI dashboard experience, including Power Query, data modeling, and DAX.
- At least 1 year of hands-on experience creating and supporting Power Automate workflows.
- Working knowledge of SQL and experience using data from multiple business systems.
- Ability to gather requirements from nontechnical stakeholders and translate 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.
Preferred qualifications
- ERP data or application experience, such as SAP, QuickBooks, or similar systems, is preferred.
- SharePoint and other Microsoft 365 tools experience is preferred.
- A bachelor's degree in Computer Science, Information Technology, Business Analytics, or a related field is preferred.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career