The Business Intelligence Audience Analyst will provide support to The Philadelphia Orchestra Association by designing and developing solutions within the organization’s main CRM and current business intelligence tools that provide patron data in a fast-paced environment across earned and contributed revenue to inform the design of more effective audience development, patron loyalty and engagement campaigns.
The main focus of this position will be on elevating reporting and tracking mechanisms for data analysis within a variety of audience segments with the goal of supporting growing revenue and audience engagement across identified patron segments. This position will serve as an analyst across the marketing and development departments and will need to effectively communicate with technical and non-technical stakeholders, solicit requirements and transform those requirements into actionable business intelligence solutions with the goal of enhancing revenue generation and expanding audience participation efforts.
The BI Audience Analyst will be required to program efficiently in T-SQL, develop SQL Server Integration Services (SSIS) packages and SQL Server Reporting Services (SSRS) reports and must also be able to learn and adapt to new business intelligence technologies.
With the Associate Director of Marketing, manage data capture, tracking, reporting and analysis for overall patron behavior and engagement across all product lines and audience segments.
In coordination with the Associate Director of Marketing and Senior Director of Development Services, set best practices, create and execute analysis across targeted patron segments to combine both earned and contributed revenue transactions to inform overall patron behaviors and lifetime engagement.
Lead effort to provide cross-departmental data analysis that captures trends that inform patron engagement strategies, working within CRM system and Business Intelligence tools.
Accountable for accuracy of data capture in analysis and reporting along with successful execution of timely analysis of patron segments based on organizational goals and revenue growth demands.
Develop strategies for managing data models and cubes to deliver specific data for user requests.
Design, create and/or modify customized reports and analyses of patron trends.
Integration and development of new Business Intelligence tools that will enhance and improve overall reporting techniques and delivery.
Creating and modifying reports that adhere to established guidelines
Designing, creating, and modifying dashboards in the Business Intelligence tools
Monitoring the integrity of the data in database and web applications.
Provide technical assistance to the Marketing Department in using Business Intelligence tools.
Responsible for meeting deadlines outlined in campaign plans, efficient management of budget and resources for completion of duties, and maintaining positive working relations with colleagues.
Bachelor’s degree in a related field required, in addition to a minimum of three years experience in Information Technology. Work experience with CRM applications and / or ticketing/donor database reporting systems and proficiency with Tessitura strongly preferred.
Proven project management experience with superior skills and ability to navigate a complex environment, with multiple projects and competing deadlines.
Excellent communication skills (verbal and written), including the ability to explain technical details and processes in non-technical terms.
Ability to synthesize information quickly, make appropriate decisions and offer solutions.
Strong analytical skills and exceptional organizational and time management skills.
Strong problem-solving skills combined with a collaborative approach.
Must be self-motivated and work well in a team environment.
Proficiency in T-SQL.
Experience designing and deploying objects in the MS BI suite (SSIS/SSAS/SSRS).
Experience designing and writing enterprise level ETL processes, reports and dashboards.
Willingness and drive to learn new technologies and contribute meaningful solutions to the business intelligence team.
Experience with C#, .NET framework is desirable.
Experience with data warehouse systems using both relational and dimensional schemas desirable.
Experience with Team Foundation Server or other source control systems is desirable
Working Conditions/Physical Demands:
Routine for office environment
About The Philadelphia Orchestra
Renowned for its distinctive sound, desired for its keen ability to capture the hearts and imaginations of audiences, and admired for an unrivaled legacy of “firsts” in music-making, The Philadelphia Orchestra remains one of the preeminent orchestras in the world.