Data Insights and Reporting Analyst (Student Position)

Summary Posted: Mar 12, 2024 Weekly Hours: 37.5 Role Number: 200541586 Imagine what you could do here. At Apple, new ideas have a way of becoming extraordinary products, services, and customer experiences very quickly. Bring passion and dedication to your job and there's no telling what you could accomplish! The people here at Apple don’t just craft products - they build the kind of wonder that’s revolutionized entire industries. It’s the diversity of those people and their ideas that inspires the innovation that runs through everything we do, from amazing technology to industry-leading environmental efforts. Our diverse and innovative community is dedicated to leaving the world better than we found it! As a Data Insights and Reporting Analyst in Apple's Sales organization, you'll play a crucial role in supporting our mission. Collaborating with Sales Professionals, Finance, Operations and Senior Leadership, you will deliver operational excellence by providing data insights, reporting, analytics, and tools to advance our strategic vision. We are searching for a student who can be flexible in the face of business ambiguity and eager to analyze/break down sophisticated datasets to derive clear decisions for our various business partners. This opportunity is for a limited term (May through August 2023) and is located in Toronto with a work hybrid model of 3 days in office and 2 days remote each week. Key Qualifications Key Qualifications Solid experience using Excel Functions, Pivot Tables and Pivot Charts to derive business insights, decisions, modeling, and finance (VBA is a plus) Proven interpersonal critical to working across multiple teams / functions. Flexibility to juggle multiple responsibilities Quick to learn new skills and quick to ask questions where necessary to further understanding. Understanding of fundamental SQL, data principles, iterative computing, and logic: GROUP BY, JOIN, IF/AND/OR/ELSE, FOR/WHILE Loops. Exposure to data manipulation tools such as Python, Pandas, KNIME, Alteryx, Tableau Prep, R, STATA, MATLAB, APIs PUSH PULLS, GCP, AWS or Azure a plus Experience with data visualization such as Tableau, Power BI, Google Data Studios, Looker, MATPLOTLIB, PLOTLY. Description Description This program offers mentorship and development to elevate your business acumen and give visibility to a wide spectrum of business functions at Apple. In this role, you will: - Partner with our sales team and finance professional to deliver data, insights, analytics, and reporting in different forms to drive business decisions. - Analyze and derive different business success measurements across areas of the business from the consumer retailer and carrier space to enterprise sales and training. - Capture, distill, and synthesize business requirements to help develop new analytics products and deliverables for the organization. - Design and develop ETL data flows to help build out our data infrastructure of data sources and automation initiatives. - Maintain and build data automation flows to support business reporting. - Support the end-to-end development of Analytics Visualization tools using cutting edge tools. Education & Experience Education & Experience Undergraduate or Graduate studies in the fields (or related): Mathematics, Statistics, Computer Sciences, Data Science, Business Analytics, Commerce, Engineering, Economics or Finance. Additional Requirements Additional Requirements