Department: Digital Marketing & Media
Supervisor: Director of Business Strategy
FLSA Status: Exempt
In the digital marketing department at the Columbus Blue Jackets, our strategy drives what we do. We heavily prioritize our understanding of the fan's experience by tying it to metrics. We take this responsibility seriously by making sure we handle our data with integrity, diligence, and aptitude. We strive to develop curiosity by not only asking questions but finding new and unique ways to phrase questions that deliver intelligent responses. When we get answers, we translate and help explain them to key decision makers within the organization to make the best-informed decisions possible.
The Business Analyst will provide quantitative data analysis to facilitate data-driven decision making primarily supporting the Corporate Partnership and Premium departments. The position will organize and data mine our primary and secondary data sources to provide actionable insights. Understanding efficient data processes across multiple platforms, employing database communication techniques, and adhering to data standardization methods will lead to success in this role. More importantly, this role aims to increase corporate partnership and premium revenue while helping us deliver enhanced service to our corporate and premium customers and prospects.
Essential Duties and Responsibilities include the following. Other duties may be assigned.
Produce sales reports which involve creating an optimized process that can easily be viewed by sales representatives, managers, and the executive leadership team.
Establish revenue projections based on pipeline status and/or helping to create new variables within CRM that allow projections to be properly categorized to determine realized value, i.e. new, renewed, live, pitched.
Within CRM, establish and report on Key Performance Indicators (KPIs) for the sales staff pipelines along with performance-based metrics for managers to assess staff productivity.
Provide asset valuation analysis and maintain rate card for corporate partnership inventory including working closely with the digital team to value digital assets.
Collect disparate data from primary and third party resources so that sales presentations and reports feature the most accurate and reliable data available to the company.
Ability to use and manage syndicated research, including Nielsen Scarborough, to bolster data-driven presentations and ensure proper time and expertise is devoted to the company’s investment in this area.
Develop and report metrics within the digital and social realm so that proper KPIs can be established and used company-wide to communicate the value of digital marketing initiatives and guide content strategy.
Institute methodology that quantitatively measures the quality of a fan’s user experience on Blue Jackets digital outlets and analyze ways to enhance that experience.
Analyze content strategy trends for monetization opportunities on BlueJackets.com, the Blue Jackets’ mobile app, and Blue Jackets social platforms.
Conduct and analyze surveys that aim to measure brand awareness, recall, and overall recognition of corporate partners.
Ad hoc reporting on an as-needed basis.
To perform the job successfully, an individual should demonstrate the following competencies:
Analytical - Synthesizes complex or diverse information; collects and researches data; uses intuition and experience to complement data; designs work flows and procedures.
Communications - Expresses ideas and thoughts verbally; expresses ideas and thoughts in written form; exhibits good listening and comprehension; keeps others adequately informed; selects and uses appropriate communication methods.
Quality Management - Looks for ways to improve and promote quality; demonstrates accuracy and thoroughness.
Strategic Thinking - Develops strategies to achieve organizational goals; understands organization's strengths & weaknesses; analyzes market and competition; identifies external threats and opportunities; adapts strategy to changing conditions.
Adaptability - Adapts to changes in the work environment; manages competing demands; changes approach or method to best fit the situation; able to deal with frequent change, delays, or unexpected events.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education and/or Experience
Bachelor's degree from four-year college or university, Statistics, Mathematics, Finance, Economics, MIS, Marketing or related field with a quantitative focus preferred; and a minimum of 2 years of related experience and/or training in analytics, advertising, media and sponsorship sales process; or equivalent combination of education and experience.
To perform this job successfully, an individual should have knowledge of Microsoft Office software, Tableau, SQL, Data Warehouse, Microsoft CRM, Ticketmaster Archtics, and Adobe Analytics.
Physical Demands and Work Environment
While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is occasionally required to stand and walk. The noise level in the work environment is usually moderate.