Junior Data Analyst

Job summary

The Junior Data Analyst monitors and analyzes business performance reports while maintaining dashboards to support data-driven decision-making. They also extract and validate data from multiple sources to provide actionable insights for cross-functional stakeholders.

Job details

Reporting to the Senior Data Analyst, the Junior Data Analyst supports the analysis and optimization of business performance across the organization. This role collaborates with cross-functional stakeholders to manage databases and reporting, analyze marketing and sales data, and provide insights on ROI, brand impact, and key performance metrics. The position also contributes to continuous improvement initiatives that enhance marketing effectiveness, optimize performance, and enable data-driven decision-making. This part-time, contract role has an hourly rate of $18.00/hr. This is a temporary position and offers flexibility to work in a hybrid work arrangement. This positions term length is 12 weeks (up to 16 hours per week). What you’ll do: * Monitor and analyze weekly, monthly, quarterly, and annual business performance reports, identifying key trends, performance drivers, and opportunities to improve results. * Build, maintain, and enhance recurring reports and dashboards, including Net Promoter Score (NPS), ticketing performance for owned and tenant teams, email marketing, and social media performance. * Extract, transform, validate, and prepare data from multiple sources to ensure accurate and reliable reporting and analysis. * Use Microsoft Excel, Snowflake, Ticketmaster Archtics, Host, and other analytics tools to analyze data and develop reporting solutions. * Respond to ad hoc analytical and data requests from cross-functional stakeholders, delivering accurate and timely insights that support business priorities. * Research and evaluate emerging analytics platforms, technologies, and data sources to identify opportunities to improve reporting capabilities, data quality, and analytical efficiency. * Establish and maintain data quality and reporting standards to ensure consistency, accuracy, and reliability across analytical outputs. * Continuously develop analytical capabilities and stay current with industry trends, emerging technologies, and best practices in business and marketing analytics. What’s needed: * Completion of post-secondary education in data analysis, computer sciences, marketing, or related field. * 0-2 years of relevant work experience, preferably within a sports property. * Intermediate to expert-level knowledge of Microsoft Excel and data manipulation. * Data driven with an interest in translating complex data into clear, actionable insights that resonate across all levels of the organization. * Excellent communication and collaboration skills. * Ability to work on deadlines, handling multiple tasks at once with great attention to detail. * Bilingualism in English & French is an asset. * Knowledge in Snowflake and Omni Analytics considered an asset. Why OSEG? Located at Lansdowne Park, the Ottawa Sports and Entertainment Group (OSEG) is the largest sports and entertainment company in the capital. We are proud owners of the Ottawa REDBLACKS, and Ottawa 67’s. We are also home to Atletico Ottawa, Ottawa Blackjacks, and Ottawa Rapid FC, and live events at TD Place. OSEG and its related Foundation were founded on the vision of its partners - to create year-round world-class guest experiences and give back to the Ottawa community. TD Place is an advocate for equity, diversity, and inclusion and invites and encourages all candidates to apply for this role, including women, Indigenous peoples, members of racialized communities, persons with disabilities and persons of minority sexual orientations and gender identities. Additionally, we are happy to accommodate any individual needs in keeping with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If you require an accommodation in order to participate in the hiring process, please contact us to make your needs known in advance. Please note this role will require interacting with the public, including in crowded spaces. TD Place is committed to providing a safe and enjoyable experience for all employees and guests. We encourage you receive a full dose of the COVID-19 vaccination (subject to applicable exceptions). We appreciate the time and effort it takes to apply and thank all applicants for their interest. Our selection process utilizes AI to compliment application screening. We’ll reach out to candidates whose applications best match the role's requirements.

What you’ll do

The Junior Data Analyst monitors and analyzes business performance reports while maintaining dashboards to support data-driven decision-making. They also extract and validate data from multiple sources to provide actionable insights for cross-functional stakeholders.

Requirements

Candidates must have post-secondary education in data analysis, computer science, marketing, or a related field. Proficiency in Microsoft Excel and 0-2 years of relevant work experience are required.

Listed skills

• Collaboration · Preferred
• Attention to detail · Preferred
• Data Validation · Preferred
• Data analysis · Preferred
• Microsoft Excel · Preferred
• Communication · Preferred
• Reporting · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data analysis
• Microsoft Excel
• Snowflake
• Ticketmaster Archtics
• Host
• Data manipulation
• Reporting
• Dashboard development
• Data validation
• Marketing analytics
• Trend analysis
• Communication
• Collaboration
• Attention to detail
• Data quality management
• Reporting and Analysis
• Performance Reporting
• Reporting Solutions
• Net Promoter Score
• Snowflake (Data Warehouse)
• Emerging Technologies
• Advocacy
• Data-Driven Decision Making
• Research
• Artificial Intelligence
• Analytics
• Data Analysis
• Dashboard
• Computer Science
• Continuous Improvement Process
• Data Manipulation
• Data Quality
• Email Marketing
• English Language
• Sales
• French Language
• Marketing
• Marketing Analytics
• Marketing Effectiveness
• Performance Metric
• Social Media
• Reliability
• Detail Oriented
• Business Priorities

Job areas

• Data & Analytics
• Marketing
• Sports & Recreation
• Technology
• Data Analyst
• Statistical, Mathematical and Related Associate Professionals
• Business Intelligence Analysts
• Data Scientists