Senior BI Analyst

Aston Carter; United States; On-site; USD 59,000 - 87,000; Full time

Benefits offered by this job

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Disability Insurance

Health Spending Account

Transportation benefits

Employee Assistance Program

Paid time off

Job summary

Aston Carter is seeking a BI Analyst in Tacoma, WA for a contract-based position to lead the Power BI reporting strategy during a major Epicor ERP migration. You will design and deliver scalable reporting, dashboards, data models, and infrastructure while integrating data from legacy ERP systems with Epicor.

You will mentor junior analysts, collaborate with operations and leaders to set reporting priorities, develop DAX calculations, optimize SQL queries, and create BAQs to support operational

Qualifications

• 5+ years in BI, BI development, data analytics, or a closely related field.
• Hands-on Power BI development experience, including dashboards and reports.
• Strong SQL development and database management experience.
• Proven experience developing complex DAX measures and calculations.
• Strong understanding of data modeling, ETL concepts, and reporting architecture.
• Ability to independently manage projects and deliver results with minimal oversight.
• Experience gathering business requirements and translating them into reporting/analytics solutions.
• Experience with ERP reporting and Epicor BAQs.

Responsibilities

• Lead the Power BI reporting strategy during the Epicor ERP migration and ensure continuity of critical reporting.
• Build, enhance, and maintain Power BI dashboards, reports, and data models.
• Connect and consolidate data from legacy ERP systems and Epicor into unified reporting solutions.
• Develop advanced DAX calculations and measures to support analytics and performance metrics.
• Write and optimize SQL queries and manage database interactions for accurate data retrieval.
• Design scalable reporting architecture and data infrastructure for long-term BI needs.
• Collaborate with leaders to identify reporting priorities and translate them into BI solutions.
• Gather, analyze, and document business requirements, delivering robust reporting deliverables.
• Troubleshoot data, reporting, and system issues across the Microsoft stack.
• Develop and maintain ERP reporting solutions, with emphasis on Epicor and related tools.
• Create and work with Epicor BAQs to support reporting needs.
• Mentor junior analysts and provide technical guidance in Power BI, SQL, DAX, and BI best practices.
• Partner with operations and leaders to deliver user-friendly reporting solutions.
• Influence reports lifecycle during ERP transition to modernize the portfolio.
• Independently manage BI projects from requirements gathering through delivery.
• Support executive leadership teams with accurate, timely reports and dashboards.

Skills

Power BI

SQL

DAX

Data modeling

ETL concepts

BI project mgmt

Stakeholder engagement

ERP reporting

Mentoring

BAQs

Tools

Epicor BAQs

Job description

Job Title: BI Analyst

Job Description

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.

Essential Skills

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

Additional Skills & 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.

Job Type & Location

This is a Contract position based out of Tacoma, WA.

Pay and Benefits

The pay range for this position is $43.00 - $63.00/hr.

Eligibility requirements apply to some benefits and may depend on your jobclassification and length of employment. Benefits are subject to change and may besubject to specific elections, plan, or program terms. If eligible, the benefitsavailable 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)

Workplace Type

This is a fully onsite position in Tacoma,WA.

Application Deadline

This position is anticipated to close on Aug 26, 2026.

About Aston Carter

Aston Carter provides world‑class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry‑leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® Platinum Award winner for both client and talent service.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email [e-mail] for other accommodation options.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.