Analyst, Ticket Finance and Reporting

This is a Full Time Job

Analyst, Ticket Finance and Reporting:

ABOUT US:

The Colorado Rockies are a professional Major League Baseball team based in Denver, Colorado. The mission of the Colorado Rockies Baseball Club is to embody the principles and practices of a championship organization in both the sport and business of baseball. In the rich tradition that has made baseball America's national pastime, we are committed to conducting our business with integrity, service, quality, and trust. We are committed to achieving excellence both on and off the field.

POSITION SUMMARY (PURPOSE OF POSITION)

The Analyst, Ticket Finance, and Reporting will manage financial reporting processes for ticketing, ensuring accurate KPIs and metrics are communicated to stakeholders. This role involves creating dashboards, automating reports, analyzing ticket sales and revenue, and supporting dynamic pricing strategies. The ideal candidate will have expertise in Tableau, data analysis, and financial reporting to drive data-driven insights for business decisions.

DUTIES AND RESPONSIBILITIES (REQUIRED, BUT NOT LIMITED TO):
• Generate accurate financial reports, including Daily Sales, Aramark P-Card, and Balance Due reports.
• Analyze ticket sales, revenue, and pricing data to optimize revenue opportunities.
• Ensure compliance with league standards by submitting required reports (e.g., MLB pre-season and game-close reports).
• Reconcile ticketing system deposits with the Finance Department's General Ledger (G/L).
• Create and maintain Tableau dashboards to track KPIs, commissions, and ticket sales trends.
• Automate and maintain sales and marketing reporting pipelines.
• Manage data source connections and ensure the integration of relevant data for reporting and analysis.
• Manage GiveX activation, reconciliation, and support for Dugout Stores and Season Tickets.
• Provide financial support for non-Rockies events (e.g., concerts, McGregor Square).
• Research and manage chargebacks, identifying trends to reduce disputes.
• Support data-driven decision-making through analysis of sales and operational data.

OTHER DUTIES/RESPONSIBILITIES:
• Provide support and financial closing information for non-Rockies events, including concerts and other miscellaneous events.
• Share in rotation that provides onsite customer support for non-Rockies events.
• Assist with educating stakeholders on the data and analytics provided.

CANDIDATE EXPERIENCE AND EDUCATION:
• Bachelor's degree in Finance, Accounting, Business Analytics, or a related field.
• 2 years of experience in finance, accounting, data analytics, or a related field, with a focus on financial reporting.
• Proficiency in Tableau or similar data visualization tools, and experience with Excel, SQL, and programming languages (e.g., Python, R, VizQL).
• Experience managing data source connections and ensuring smooth data integration.
• Working knowledge of Excel for financial analysis, including pivot tables, VLOOKUP, and complex formulas.
• Strong communication skills, with the ability to translate complex data insights to non-technical stakeholders.
• Attention to detail, problem-solving skills, and managing multiple priorities.
• Clear and practical communication skills, including translating complex data findings into insights easily understood by non-technical stakeholders.
• Strong problem-solving skills to address discrepancies, troubleshoot data issues and improve reporting processes.

WORK ENVIRONMENT:
• Monday – Friday, 8 am-5 pm with an hour lunch. Occasional night and/or weekend hours are necessary.
• Work Environment: The position is performed in a standard office environment, which includes sitting at a desk, using a computer, and attending meetings. There may be occasional exposure to noise or distractions, especially during high-traffic periods or when coordinating across departments.
• Work Hours: Standard full-time hours with the potential for extended hours during key periods, such as during the season or critical project deadlines. Occasional night and/or weekend hours are necessary.
• Team Dynamics: Collaborative environment involving regular interactions with front office personnel.

PHYSICAL JOB REQUIREMENTS:
• The role primarily involves sitting for extended periods while working at a desk and operating a computer.
• The position involves frequent typing, including using data entry software and spreadsheets and generating reports in Excel or other financial platforms.
• Good hand-eye coordination and manual dexterity are required for detailed tasks.
• Must accurately view and interpret small font sizes, graphs, and numerical data on screens or paper for extended periods without strain.
• Must work and be able to manage stress under tight deadlines, especially during peak reporting periods or season transitions.
• The position may involve brief walking between departments or meeting rooms for collaborative discussions, presentations, or sharing reports with stakeholders. A few steps may be required to attend in-person meetings or provide on-site customer support during special events.
• While primarily office-based, occasional lifting of materials with an approximate weight of up to 20 pounds may occur during report or event preparation.

SUPERVISORY RESPONSIBILITIES: N/A

COMPENSATION AND BENEFITS
• Annual Salary Range of $75,000-$85,000. This is a regular status, full-time position.
• As a candidate for this position, your salary and related compensation elements will be contingent upon your work experience, education, job-related skills, and any other factors the Colorado Rockies consider relevant to the hiring decision for this position.
• In addition to the base salary, the Club believes in providing a very competitive and generous compensation and benefits package for its employees. Benefits include but are not limited to Medical, Dental, Vision, 401(k) with employer match, generous vacation and holiday program, employee parking, employer-provided game tickets to home games, onsite fitness classes and experiences, employee discounts on merchandise, and so much more! All benefits are subject to eligibility requirements and the terms of official plan documents, which may be modified or amended at any given time.

APPLICATION PROCESS:
• Applications will be reviewed on a rolling basis but must be received by January 10th, 2025.
• The estimated time to complete the recruitment process will be by February 7, 2025
• Please note that this is just an estimate, and the posting and recruiting process may be removed or extended at any time.
• A note for Colorado Rockies employees:
• Please apply via the internal job board in UKG by following these prompts: MENU > MYSELF > MY COMPANY > VIEW OPPORTUNITIES > select the position > CONSENT > APPLY NOW
• If you cannot access UKG, please list your most recent Manager as an Employee

EQUAL OPPORTUNITY EMPLOYER:

Rockies baseball is for everyone! We pride ourselves on hiring, developing, and promoting talent as an Equal Employment Opportunity Employer. All qualified applicants and employees will receive consideration for employment or promotion without regard to race (including, but not limited to, traits historically associated with race, such as hair texture and length and/or protective hairstyles), color, national origin, gender identity, gender expression, sexual orientation, familial status, marital status, ancestry, age (40 ), creed, religion, disability, veteran status, pregnancy/childbirth and related conditions, or any other category or activity protected by law. In addition, we will endeavor to provide reasonable accommodation to otherwise qualified job applicants and employees with known physical or mental disabilities in compliance with the ADA. All employment and promotion decisions will be decided on the basis of qualifications, merit, and business needs.