Ensemble Performing Arts

Human Resources

• Serve as the primary HR resource for managers and employees
• Coach leaders on policies, performance expectations, and people-management matters
• Conduct objective workplace investigations and coach managers through difficult employee situations
• Escalate complex or high-risk matters to the Senior HR Manager
• Partner with Payroll to accurately and promptly capture new hires, terminations, compensation changes, and other employee-status changes
• Help resolve payroll discrepancies
• Support managers through goal setting, reviews, feedback, performance plans, follow-up, and documentation
• Facilitate compliance training and manager-effectiveness programs
• Provide ongoing coaching to build manager capability and confidence
• Identify capability gaps and help develop training materials, manager resources, and HR communications
• Partner with leaders and Talent Acquisition on staffing needs, onboarding, employee engagement, retention, and career-development initiatives
• Support organizational changes and change management
• Collaborate across HR and Shared Services to provide a consistent, connected experience
• Manage routine and moderately complex HR matters independently while escalating higher-risk or sensitive issues

Human Resources Manager

Events

• Report directly to the Chief Marketing Officer
• Plan and execute recurring internal and external events across Ensemble Performing Arts
• Build and run a multi-day Music School Owners Conference end to end
• Source venues, negotiate contracts, manage room blocks, and own the conference budget/P&L
• Design the conference agenda and sessions with ELT and Opus stakeholders
• Manage registration and attendee data in HubSpot
• Lead attendee acquisition campaigns with the marketing team
• Manage AV, F&B, production, signage, swag, run of show, and on-site execution
• Conduct post-event surveys, financial close, and create a repeatable conference playbook
• Own venue, travel, lodging, budget, vendors, meals, transport, evening programming, materials, and feedback for the all-company offsite
• Build the all-company offsite agenda with the ELT
• Own the demand-generation cadence for M&A/CDM webinars, including platform, registration, reminder sequences, and HubSpot integration
• Lead speaker preparation and dry runs with the CDM team and live production
• Hand off webinar follow-up into the CDM workflow and report through to screenings
• Run department offsites and internal gatherings using repeatable playbooks
• Own logistics, budgets, vendor relationships, and scalable event templates

Event Manager, Marketing

Analytics Engineer

• Write, test, and maintain SQL queries for operational domains including customers, accounts receivable, rentals, products, inventory, and payments
• Investigate unfamiliar or poorly documented relational databases
• Profile source data for completeness, duplication, referential integrity, unusual record states, and migration risk
• Document extraction criteria, joins, filters, assumptions, control totals, audit fields, and known limitations
• Develop and maintain operational reports, extracts, exception reports, and cross-system comparisons using SQL, Excel, Power Query, or approved reporting tools
• Assist with NetSuite and Shopify saved searches, exports, and data investigations
• Trace discrepancies across source systems, transformations, import files, and target records to identify root cause
• Execute assigned data-conversion workstreams using approved requirements, source-to-target mappings, and acceptance criteria
• Develop and maintain mappings, normalization rules, exception categories, and deduplication logic
• Prepare import-ready outputs and reconcile record counts, quantities, balances, totals, duplicates, exclusions, and transformation results
• Create evidence packages and support post-import verification, corrections, and documented rerun procedures
• Develop Python, PowerShell, or comparable utilities for file ingestion, transformation, validation, reconciliation, exception reporting, and export generation
• Convert recurring SQL and Excel processes into version-controlled, tested, maintainable scripts or scheduled workflows
• Apply logging, configuration management, error handling, restartability, and safe-recovery practices
• Maintain queries, scripts, mappings, runbooks, and recovery procedures; participate in review and cross-training
• Support implementation testing, cutover activities, and issue investigation for assigned workstreams
• Work with the Software Systems Engineer and business subject-matter experts to independently execute defined technical workstreams after onboarding

Human Resources Manager

Event Manager, Marketing

Data Systems, ETL Engineer I