Senior BI Analyst

About the role

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.

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.

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.

Qualifications

• 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.

Work Environment

The role is fully onsite, with standard working hours from 8:00 a.m. to 5:00 p.m. The position operates within a specialized manufacturing and automation environment that supports life sciences and pharmaceutical manufacturing, offering exposure to complex operations, manufacturing data, and cross-functional stakeholders. The culture emphasizes a “fail fast” mindset, where the organization values individuals who can hit the ground running, deliver quickly, and adapt in a fast-paced, high-impact setting. The BI Analyst will work closely with operations, department leaders, and executive stakeholders in a collaborative, data-driven environment focused on building a stable and modern business intelligence landscape during a critical ERP transition.

Pay

The pay range for this position is $43.00 - $63.00/hr. Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Benefits

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Schedule

This is a Contract position based out of Tacoma, WA, with standard working hours from 8:00 a.m. to 5:00 p.m.