2,316,967open jobs
146,463companies
277,326added this week
Browse all
Location
Remote (United States)
Seniority
Junior · 1+ year exp
Visa
H-1B filings in 12 months: 3 · green card filings: 1
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 16, 2026. First seen by Alion on Nov 16, 2026. Ensemble Performing Arts scores A on the Alion truth index.

Overview
Company
Impact
Profile match
Ensemble Performing Arts is a collaborative network and operating partner for community-based music and dance schools, headquartered in Beaverton, Oregon. The organization partners with local studios across multiple states, providing administrative, operational, and financial resources while preserving each school's unique local identity. Through its nationwide network, it supports sustainable career opportunities for educators and delivers comprehensive arts education programs to students of all ages.

Business Intelligence Analyst

Ensemble | Business Systems & Technology Location: Remote (United States) | Type: Full-time |

Salary: $90,000

About the role

Ensemble runs on data from many systems: NetSuite, Shopify POS, our NEMC rental platform, and the legacy SQL Server and FileMaker systems of the stores we acquire. As our Business Intelligence Analyst, you'll turn that data into accurate, timely insight for operations, accounting, and leadership.

You'll report to the Vice President, Operations, and work closely with our Software Systems Engineer. You'll write queries, build reports and dashboards, prepare data for system conversions, and help us bring newly acquired stores onto our platforms. You'll also make recommendations that business owners can act on.

What you'll do

Analyze and report

  • Build standard and custom reports for executives, managers, accounting, and store leaders. Examples include rental revenue and loss-and-damage waiver (LDW) reporting, accounts receivable and collections, inventory position, and affiliate dealer consignment and commission reporting.
  • Query NetSuite, Shopify, the NEMC rental platform, and legacy store databases using SQL and NetSuite saved searches.
  • Spot trends, patterns, and anomalies across rental, sales, inventory, receivables, and customer data, combining sources for a complete picture.
  • Monitor customer, school program, and affiliate dealer performance.
  • Turn findings into clear recommendations for business owners and leadership.
  • Support system implementations and cutovers with reporting, test data sets, and post-cutover analysis.

Prepare and validate data

  • Extract customer, rental contract, accounts receivable, payment, product, and inventory data for reporting, analysis, and system conversions.
  • Learn how unfamiliar or poorly documented acquired-store systems work so you can interpret their data correctly.
  • Profile, cleanse, normalize, and deduplicate data, applying source-to-target mapping rules agreed with the business owner and Software Systems Engineer.
  • Prepare import-ready files for stores moving onto NetSuite, Shopify, or the rental platform, and reconcile record counts, balances, and totals.
  • Document data exceptions and trace errors back to their source.

Build and maintain BI tools

  • Design reporting data sets, extracts, spreadsheets, and outputs that consolidate data across our systems.
  • Keep reports, dashboards, and data sets accurate as systems, acquisitions, and business rules change.
  • Run scheduled, monitored, recoverable data processes with logging, error handling, and documented reprocessing steps.
  • Replace manual, Excel-based reporting with repeatable processes using reusable SQL, saved searches, templates, and Python (or similar) scripts.
  • Collaborate with the Software Systems Engineer on data requirements, database design, APIs, and backend services.

Document, test, and support

  • Write specifications for reports and dashboards, including data sources, selection rules, and calculations.
  • Test reports and data against the business owner's needs before release.
  • Support existing reports and investigate discrepancies users raise.
  • Maintain a version-controlled library of queries, templates, mappings, and runbooks, and communicate changes to users.
  • Handle customer, financial, and operational data according to our access, retention, and confidentiality expectations.

What you bring

Required

  • Bachelor's degree (or foreign equivalent) in Computer Science, Information Systems, Data Analytics, Business Analytics, Statistics, Mathematics, or a closely related field
  • One year of experience in data analysis, business intelligence, reporting, database work, data migration, or a related field
  • Proficiency in SQL, including multi-table joins, CTEs, aggregations, and data-quality and reconciliation queries
  • Scripting experience in Python, PowerShell, or a similar language for cleansing, validating, and combining data
  • Experience extracting, cleansing, and validating business or financial data, using record counts, control totals, and exception reporting
  • Experience creating reports or analyses from relational databases or business systems
  • Working knowledge of version control, testing, and documentation practices
  • Clear written and verbal communication with non-technical users

Preferred

  • Experience with NetSuite, Shopify, Microsoft SQL Server, or FileMaker
  • Experience with a BI tool such as Power BI, SSRS, or Looker
  • Familiarity with accounts receivable, inventory, retail, or rental data
  • Exposure to data migrations, acquisitions, or system cutovers
  • Exposure to scheduled data workflows or reconciliation automation

What success looks like in your first year

  • Recurring reports that operations and accounting rely on are accurate and on time.
  • You've completed data extraction, cleansing, and validation for at least one store or system cutover, with reconciled results accepted by the business owner.
  • Selected Excel-based processes have been replaced with documented, repeatable queries, templates, or scripts.
  • You've built a shared library of documented queries, mappings, validation checks, and runbooks.

About the scope

This is a business intelligence role focused on analyzing and reporting on our business data and maintaining the tools that deliver it. You'll collaborate on database design and system architecture, but you won't own them. It is not a helpdesk, catalog-administration, accounting-policy, or general application-development position.

The posted salary range is provided in compliance with applicable laws and may vary based on location, experience, and qualifications. Total compensation will depend on individual performance and territory growth. Ensemble Performing Arts is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status or disability status, or genetic information. Pursuant to the Los Angeles County Fair Chance Ordinance for Employers and any other state or local hiring regulations, we will consider for employment any qualified applicant, including those with arrest and conviction records, in a manner consistent with applicable law. 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.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,316,967 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Similar stack
Same company
United States
Business Analyst II 1 hour ago
$66k – $104k per year · In office · Full-Time · 3+ years exp · Bachelor's Degree · Oakland
Analytics
Microsoft Excel
Management
Confluence
Smartsheet
Jira
SharePoint
Agile
Scrum
ITIL
Apply
$52k – $68k per year · Remote (Canada) · 3+ years exp · St. Thomas · London
Management
Agile
Apply
Remote (United States) · 3+ years exp · Laredo
Management
Agile
Apply
$137k – $140k per year · In office · Full-Time · 3+ years exp · Bachelor's Degree · Newton
Python
SQL
Databases
Snowflake
AI/ML
dbt
Machine Learning
Analytics
Tableau
Apply
In office · 3+ years exp · Bachelor's Degree · Durham
Python
SQL
AI/ML
AI Agents
Transformers
RAG
Time Series
Analytics
A/B Testing
Apply
$132k – $252k per year · Remote (location not specified) · Nationals only · Full-Time · 10+ years exp · Bachelor's Degree · United States
AI/ML
OCR
Apply
In office · Part-Time · 1+ year exp · Bachelor's Degree · Tempe · Chandler
Apply
In office · Full-Time · High School Diploma · Phoenix · Scottsdale
Apply
$52k – $78k per year · In office · Full-Time · 2+ years exp · Associate's Degree · United States
Apply
$102k – $184k per year · Remote (United States) · 9+ years exp · Bachelor's Degree · United States
DevOps
Azure
Management
ITIL
Apply
See all jobs
This is one of many
2,316,967 more open roles from verified company boards, updated every day.