Business Intelligence Analyst @Ensemble Performing Arts
Data and Analytics
Salary $90,000
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type full-time
Posted Today

[Hiring] Business Intelligence Analyst @Ensemble Performing Arts

Today - Ensemble Performing Arts is hiring a remote Business Intelligence Analyst. πŸ’Έ Salary: $90,000 πŸ“Location: USA

Role Description

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.
    • 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.
    • 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.
    • Profile, cleanse, normalize, and deduplicate data.
    • Prepare import-ready files for stores moving onto NetSuite, Shopify, or the rental platform.
    • 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.
    • Handle customer, financial, and operational data according to our access, retention, and confidentiality expectations.

Qualifications

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

Requirements

  • 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.
  • 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.
Before You Apply
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
Business Intelligence Analyst @Ensemble Performing Arts
Data and Analytics
Salary $90,000
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type full-time
Posted Today
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 135,000+ Remote Jobs
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 135,000+ Remote Jobs
Γ—
Apply to the best remote jobs
before everyone else

Access 135,000+ vetted remote jobs and get daily alerts.

4.9 β˜…β˜…β˜…β˜…β˜… from 500+ reviews

⚑ 139,310+ remote jobs, refreshed hourly

πŸ”” Real-time alerts: Apply first, direct to employer

πŸ›‘οΈ Vetted companies, no scams, true remote only

Unlock All Jobs Now

Maybe later