Data Engineering And Analytics Intern

We are looking for a detail-oriented intern to support the Data Strategy team in maintaining our data infrastructure and preparing internal intelligence for the business. In this role, you will work behind the scenes to ensure our data pipelines are robust and that our senior analysts have the clean, structured data they need to serve our management team and external clients. Roles and Responsibilities Data Analysis & Reporting Support • Support Client Reporting Workflows: Assist Senior team in extracting and preparing data for high-priority client reports. You will handle the data aggregation and formatting that allows our team to deliver timely insights to promoters and venues. • Internal Dashboard Maintenance: Help maintain and update internal BI dashboards (Apache Superset) to ensure the Data Team has a real-time view of sales and patron behavior. • Preliminary Analysis: Conduct initial data exploration on sales trends to flag interesting patterns for the wider team to investigate further. • Ad-Hoc Data Preparation: Rapidly query and structure datasets to support the management team in answering specific business questions (e.g., "Post-event sales velocity" or "Demographic breakdown"). Data Engineering & Pipeline Development • Pipeline Contribution: Work under the guidance of Data Engineer to assist with the ingestion, cleaning, and transformation of ticketing data within the SISTIC Data Warehouse. • Troubleshooting: Assist in monitoring existing data pipelines to identify potential issues, ensuring the data that feeds our client reports remains accurate and reliable. • Documentation & Best Practices: Write clean, well-documented code (Python/SQL) to ensure all data processes are transparent and reproducible by the engineering team. Skills and Experience Required Technical Aptitude • Currently pursuing a degree or diploma in a quantitative field (Data Science, Computer Science, Statistics, Economics, or Business Analytics) or have equivalent project experience • Data Handling: Proficiency in SQL (for data extraction) and Python (Pandas for manipulation) is essential. • Visualization: Familiarity with BI tools (Apache Superset, Tableau, or PowerBI) is a plus. • Excel Proficiency: Strong command of Excel functions (VLOOKUP, Pivot Tables) for quick data validation and ad-hoc formatting. • Demonstrated interest in core data-engineering concepts, including ETL processes and data-storage solutions (data warehouses and data lakes); familiarity with Google Cloud Platform is a plus; Basic understanding of database principles is a plus Professional Attributes • Confidentiality & Integrity: You will be handling sensitive commercial data regarding ticket sales and revenue. A strict adherence to data privacy, confidentiality, and professional discretion is a mandatory requirement for this role. • Attention to Detail: A "measure twice, cut once" mindset. You double-check your queries and data outputs to ensure accuracy before passing work to supervisors. • Curiosity: A strong interest in understanding the events ecosystem and the mechanics of data engineering. To facilitate our screening process, please explicitly include a proficiency rating (e.g., Beginner, Intermediate, Advanced) for the following skills in your resume: • SQL • Python • Microsoft Excel