Job Title: Data and Analytics Manager
Employer: Madison Symphony Orchestra
Location: Madison, WI
Deadline: May 19th, 2023
How To Apply: Send resume, cover letter, and the names of three professional references to Casey Oelkers, Director of Development: coelkers@madisonsymphony.org
About This Position:
The Madison Symphony Orchestra seeks an experienced Data and Analytics Manager to join our administrative team. As we approach our 100th Anniversary Season in 2025-2026, this new, full-time position will increase the capacity of our development and marketing departments by leading, implementing and overseeing all aspects of the MSO’s CRM systems, and being responsible for the organization’s overall data health and security.
As a member of our small but mighty administrative staff, you’ll enjoy our collaborative work environment, learn about all aspects of the organization, be invited to share your creative ideas and have them heard, take pride in knowing you are making a meaningful behind-the-scenes contribution to the success of the Symphony’s subscription concerts and Education and Community Engagement Programs.
Principal Responsibilities:
• Develop and implement policies and procedures related to data security and integrity.
• Monitor and maintain database performance, data health/accuracy, and security.
• Maintain data accuracy across multiple CRMs: Raiser’s Edge, Tessitura, WordPress, Mailchimp
• Identify efficiencies and process improvements: subscription form processing, paper record keeping, online donations, etc.
• Create and execute queries, lists and reports; configure data graphs, charts and/or tables as appropriate in collaboration with marketing, development, education, and senior leadership teams.
• Develop, lead, and execute processes for data entry and record maintenance: logging subscription info, single ticket buyers, special event attendance, and donations; updating addresses, phones and emails; deceased records; changes in marital status and other relationships
• Analyze, interpret and evaluate attendance and contribution trends; make data-driven recommendations to increase sales and contributions
• Create training documentation and guidelines for database users; train users.
• Resolve data conflicts for matters such as naming conventions, data privacy, and data ownership.
• Reconcile sales and contributions with finance department
• Install updates to database software
• Develop, implement, and monitor access policies limiting database access on a need-related basis.
• Generate sales and contribution reports.
• Provide documentation to support the annual audit.
• Identify, define, and assess the properties and specifications necessary for the database management system (DBMS) to meet current and future needs of the organization.
• Assess current and projected database performance, and recommend changes and enhancements.
• Maintain knowledge of trends, developments, and best practices in DBMS and related technology.
• Ensure project and department milestones and goals are met on time and within budget.
• Perform other duties as assigned by the Development Director and/or Marketing Director.
• Assist with concert duties as assigned by the Executive Director.
Required Qualifications:
• Knowledge of, and commitment to, best practices in database management
• In-depth knowledge of database technologies, architecture, and data security
• Analytical problem-solving skills, analytical organizational skills, and attention to detail
• Advanced Microsoft Office, Office 365 skills (includes Excel)
• Good human relations skills necessary for clear communication with supervisor and peers and cooperative relationship with interdepartmental personnel.
• Two to three years of relevant experience.
Highly Desired Skills/Experience:
• Associate’s or Bachelor’s Degree in management information systems, computer science or a related field — or equivalent experience
• Experience developing Extract, Transform, Load (ETL) procedures
• Experience with Raiser’s Edge, Omatic, and/or Tessitura
• Proficiency in SQL
• Interest in/knowledge of classical music is a bonus