Spring Semester Data Analyst Internship

The Rochester Red Wings are offering a valuable educational opportunity for a talented Data Analyst Intern to assist in the development and management of our tech stack. Join our Research & Development team and become an integral part of preserving our legacy of success while contributing to our future achievements. This is your chance to embark on an exciting journey with us!

Educational Experience

As a Data Analyst Intern, you will receive training that builds on classroom knowledge and academic experience, closely supervised by experienced professionals. This internship aims to enhance your skills, providing you with practical knowledge and experience that are transferable to any similar business in the field. You will have the opportunity to engage in real-world projects, gaining insights into the data engineering and business analytics strategies of a professional sports organization.

Key Learning Areas

• Data Platform Architecture: Learn to design, develop, and implement data platform architecture and integration strategies to support the entire Business Intelligence team.
• ETL/ELT Processes: Gain experience creating and maintaining ETL/ELT processes, ensuring data standardization and integrity across multiple data sources.
• Data Hygiene: Implement best practices for data hygiene and effectively manage issue tracking within data pipelines.
• Data Management Operations: Oversee all aspects of data management operations, including resolving database problems, optimizing queries, and managing data storage.
• Data Transformation: Transform and consolidate raw data from various sources into analytics-ready data models.
• Stakeholder Collaboration: Collaborate with non-technical business stakeholders to gather requirements and build strong relationships.
• Data Requirements Analysis: Work closely with the Business Strategy team to understand data requirements for current and future projects.

Ideal Candidate Profile

• Currently pursuing a degree in Computer Science, Data Engineering, or a related field.
• Proficiency in SQL and Python languages, with the ability to apply them effectively.
• Demonstrated experience with various data forms, including data warehouses/relational SQL, NoSQL, JSON, and unstructured data environments (e.g., PIG, HIVE, Impala).
• Strong understanding in developing data structures and pipelines to organize, collect, and standardize data for generating insights and addressing reporting needs.
• Understanding of how to conceptulize creating data pipelines for sales systems, such as ticketing data for sports events.
• A motivated team player with a positive attitude and a strong work ethic.

Additional Learning Opportunities

• Developing excellent communication skills and a collaborative mindset.
• Enhancing attention to detail and problem-solving abilities in data engineering/analyst contexts.

Compliance with Educational Internship Guidelines

To ensure the position is a true educational experience and not an employment relationship, the internship will:

• Provide training similar to that offered in an educational environment.
• Be for the benefit of the intern, offering skills useful in various jobs.
• Ensure interns do not displace regular employees and are under close supervision.
• Not provide an immediate advantage to the employer, with the focus on the intern’s learning.
• Not guarantee a job at the conclusion of the internship.
• Include written notification to interns that they will not receive wages and are not considered employees for minimum wage purposes.