Senior BI Analyst

Aston Carter•Tacoma, WA

1d•$43 - $63•Onsite

About The Position

The BI Analyst will lead the Power BI reporting strategy during a major Epicor ERP migration, designing and delivering scalable reporting solutions that support critical business decisions. This role builds and maintains complex Power BI dashboards, data models, and reporting infrastructure while integrating data from legacy ERP systems and Epicor. The BI Analyst partners closely with operations and department leaders, provides technical leadership to junior analysts, and plays a key role in stabilizing and shaping the company’s business intelligence environment during a high-impact transformation.

Requirements

5+ years of experience in Business Intelligence, BI development, data analytics, or a closely related field.
Advanced, hands-on Power BI development experience, including dashboarding and report creation.
Strong SQL development skills and database management experience.
Proven experience developing complex DAX measures and calculations.
Strong understanding of data modeling, ETL concepts, and reporting architecture.
Demonstrated ability to independently manage projects and deliver results with minimal oversight.
Experience gathering business requirements from stakeholders and translating them into reporting and analytics solutions.
Experience with business intelligence tools and ERP-related reporting.
Ability to engage effectively with stakeholders and support decision-making through data-driven insights.

Nice To Haves

Epicor ERP experience, particularly in a reporting or analytics context.
Experience creating and working with Epicor Business Activity Queries (BAQs).
Background in the manufacturing industry, ideally with exposure to complex operations and manufacturing data.
Experience with ERP implementation or migration projects.
Prior experience supporting executive leadership teams with reporting and analytics.
Experience leading or mentoring junior analysts or BI teams.
Familiarity with BI infrastructure and data architecture design.
Experience working with regulated-industry reporting needs, such as life sciences or pharmaceutical manufacturing environments.

Responsibilities

Lead the Power BI reporting strategy throughout the Epicor ERP migration, ensuring continuity and improvement of business-critical reporting.
Build, enhance, and maintain complex Power BI dashboards, reports, and data models that deliver clear and actionable insights.
Connect, integrate, and consolidate data from legacy ERP systems and the new Epicor ERP platform into unified reporting solutions.
Develop advanced DAX calculations and measures to support sophisticated analytics and performance metrics.
Write and optimize SQL queries and manage database interactions to ensure accurate, performant data retrieval.
Design scalable reporting architecture and data infrastructure that support long-term business intelligence needs.
Collaborate with business leaders to identify reporting priorities and translate them into effective BI solutions that drive decision-making.
Gather, analyze, and document business requirements, then convert them into robust reporting and analytics deliverables.
Troubleshoot data, reporting, and system issues across the Microsoft stack, resolving problems quickly to maintain data reliability.
Develop and maintain ERP reporting solutions, with an emphasis on Epicor and related reporting tools.
Create and work with Epicor Business Activity Queries (BAQs) to support operational and executive reporting needs.
Mentor junior analysts, providing technical guidance in Power BI, SQL, DAX, and BI best practices.
Partner directly with operations and department leaders to understand reporting needs and deliver practical, user-friendly solutions.
Influence which reports are rebuilt, or newly created as part of the ERP transition, helping to streamline and modernize the reporting portfolio.
Independently manage BI projects from requirements gathering through delivery, ensuring timely, high-quality outcomes with minimal oversight.
Support executive leadership teams with accurate, timely reports and dashboards that inform strategic decisions.