ANALYTICS INTERN JOB DESCRIPTION
Discover what Analytics Intern roles involve across industries, from data visualization and KPI reporting to procurement analytics and machine learning support.

Analytics Intern Job Description Template
1. About the Role
Data without interpretation is just storage. An Analytics Intern who cannot reliably surface patterns, maintain clean data pipelines, or communicate findings to non-technical stakeholders leaves KPI dashboards stale and business decisions grounded in guesswork. This role owns a defined slice of the analytics production cycle: pulling data from relational databases, building reports, and translating quantitative output into stakeholder-ready presentations. Placed within a business analytics or operations team, the Analytics Intern works under the direction of senior analysts or a department analytics lead and is typically evaluated on report accuracy and turnaround.
2. Position Summary
As the Analytics Intern, you will collect, validate, and analyze structured and unstructured datasets to produce reports, dashboards, and KPI summaries that inform operational and strategic decisions across business functions. You will work within a data or business intelligence team, supporting senior analysts and partnering with stakeholders in marketing, operations, finance, or sales to ensure findings reach the people who act on them.
3. Why Join Us
Career Impact: Experience producing real KPI reports and dashboard deliverables used by business leaders accelerates the transition from academic coursework to a credentialed analytics role in the labor market.
Business Impact: The reports and models this intern produces feed directly into staffing forecasts, sales performance reviews, and operational improvement decisions that affect how the organization allocates resources.
Growth Opportunity: Hands-on exposure to relational database querying, forecasting models, and stakeholder presentation builds the technical and communication range needed to advance toward an Analytics Analyst or Business Intelligence Analyst title.
4. Key Responsibilities
- Gather data from multiple structured and unstructured sources to produce periodic and ad hoc analytical reports for business partners.
- Validate the accuracy and completeness of underlying datasets and investigate discrepancies before report distribution.
- Analyze historical trends and current performance data to support forecasting models and resource planning decisions.
- Build and maintain dashboards that track KPIs across assigned business functions, updating them based on real-time results.
- Develop presentations and data narratives that communicate analytical findings clearly to stakeholders without a technical background.
- Support senior analysts in modeling exercises, including cost models, staffing projections, and performance benchmarking.
- Automate recurring reporting tasks and data preparation workflows to reduce manual processing time.
- Collaborate with cross-functional partners in operations, finance, or marketing to clarify data requirements and confirm analytical outputs.
5. Required Qualifications
- Bachelor's degree in data analytics, statistics, economics, mathematics, or a related quantitative field, or equivalent work experience.
- 0 or more years of analytics experience, with demonstrated ability to work with structured datasets and produce summary reports.
- Proficiency in spreadsheet modeling, including advanced functions, Pivot Tables, and data validation techniques.
- Working knowledge of relational databases and the ability to write queries to extract and filter data.
- Demonstrated ability to translate quantitative findings into written summaries and visual presentations for non-technical audiences.
- Strong attention to detail with the ability to identify data anomalies and investigate their root causes before escalating.
- Effective time management skills, including the ability to prioritize multiple concurrent reporting deadlines independently.
6. Preferred Qualifications
- Prior internship or project experience involving data cleaning, dashboard creation, or quantitative modeling in a professional or academic setting.
- Familiarity with statistical analysis techniques such as regression, trend analysis, or forecasting, applied to business questions.
- Exposure to ETL concepts or experience preparing data pipelines that feed downstream reporting systems.
- Experience presenting data findings to managers or cross-functional teams, with ability to adapt the level of technical detail to the audience.
7. Success Metrics and Environment
- Report accuracy rate, measured as the percentage of deliverables requiring no correction after stakeholder review.
- Data validation turnaround, tracking the average time from raw data receipt to a clean, analysis-ready dataset.
- Dashboard freshness, measured by the percentage of assigned dashboards updated within the agreed reporting cadence.
- Stakeholder request completion rate, reflecting the proportion of ad hoc analytical requests resolved within the agreed SLA.
- Forecast variance, comparing projected values in intern-supported models against actual outcomes over the internship period.
- Typical tools: Spreadsheet and data platforms (commonly Excel or Google Sheets); query and BI tools (commonly SQL-based platforms and Power BI or Tableau).
8. Compensation and Benefits (US Market Benchmark)
- Base Salary Range: $18 to $24 per hour, depending on location and degree level.
- Bonus: typically not applicable for internship roles.
- Equity: not typically offered for internship positions.
- Health Benefits: some employers offer limited health coverage for full-time interns.
- PTO: typically follows academic or fixed internship calendar with limited additional PTO.
- Common Perks: Mentorship program access, intern cohort networking events, and potential for return offer consideration.
Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.
9. EEO and Legal
Background checks are a standard condition of employment for this role, and offers are contingent on successful completion of that process. All qualified applicants are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations are available to applicants and employees with disabilities upon request. Candidates must be authorized to work in the United States.
Analytics Intern Job Description Example
1. Analytics Intern (Workforce Planning)
The Analytics Intern delivers workforce analytics support by gathering and analyzing data from multiple sources to produce staffing plans, forecast models, and cost assessments for business partners. Working within the workforce planning function, the intern validates staffing models and adjusts forecasts based on real-time activity to ensure service level targets are consistently met.
Key Responsibilities
- Gather and analyze data from multiple sources to produce meaningful workforce metrics and reports for business partners.
- Ensure the reliability and quality of underlying data and investigate data issues as they arise.
- Analyze historical data and trends to forecast future contact volume and staff requirements.
- Track and trend all required workforce planning data on a continuous basis.
- Support workforce forecasts and cost models to assess future workforce requirements.
- Prepare updated staffing plans based on future product releases and launches.
- Validate ongoing staffing models to ensure service level targets are consistently met.
- Compare resource requirements with available resources to identify and resolve potential gaps.
- Provide ongoing adjustments to the forecast model based on actual results and real-time activity.
Required Qualifications
- Must be actively pursuing a degree at an accredited educational institution with a cumulative GPA of 2.8 or higher and at least 2 years of undergraduate studies completed.
- Experience or familiarity with forecasting and financial modeling preferred.
- Proficiency in Microsoft Office products, particularly Excel.
- Experience with SQL, MySQL, PHP, or FileMaker Pro is a plus.
- Familiarity with macroeconomics impacting the labor market.
- Strong quantitative and analytical skills with the ability to solve problems efficiently.
- Critical thinker with good decision-making skills and the ability to maintain composure under pressure.
- Ability to plan and prioritize work while preserving confidentiality and interacting effectively with employees at all levels.
2. Analytics Intern (Pharma and Healthcare Strategy)
Embedded within the Commercial and Government Affairs planning team, the Analytics Intern shapes strategic sales and marketing insights by applying primary market research techniques, building patient-based forecasts, and conducting competitive threat assessments across the biopharmaceutical industry. Working closely with cross-functional field leadership teams, the intern advances business performance understanding and supports the development of customer engagement strategies within healthcare systems.
Core Functions
- Provide strategic sales and marketing insights by leveraging primary market research techniques across qualitative and quantitative research with customers.
- Create trend-based and patient-based forecasts and conduct uncertainty analyses.
- Track competitive landscape and conduct competitive threat assessments.
- Apply expertise in managed care to assess the impact of payer management, coverage, pricing, and reimbursement drivers on the biopharmaceutical industry.
- Support cross-functional field leadership teams to understand business performance and update strategy and tactics for customer engagement within healthcare systems.
Qualifications and Experience
- MBA, PhD, or other advanced degree ongoing or recently completed, or a completed BS/BA degree.
- 2-4 years of work experience in consulting, finance, marketing, sales, or drug research and development related fields.
- Healthcare industry and managed care (payer/provider) experience preferred.
- Strong interest in business analysis geared toward pharma, biotech, or healthcare.
- Expertise in standard analysis and presentation software including Excel and PowerPoint.
- Proficiency in understanding market landscape and pulling insights across multiple data sources.
- Competency in conducting and analyzing research and distilling data into concise, insight-focused summaries.
- Proven track record of leadership, time management, project management, and teamwork, with demonstrated ability to interact effectively with senior leadership.
3. Analytics Intern (Data Visualization and BI)
Reporting to the analytics leadership team, the Analytics Intern leads efforts to mine structured and unstructured datasets, automate repetitive analytical tasks using tools such as Tableau, Power BI, and Visual Basic, and build data models that surface patterns and anomalies for business stakeholders. Partnering with cross-functional partners and customers, the intern drives a data accuracy project during integration activities and delivers reports that communicate clear, actionable messages to audiences unfamiliar with the data.
Primary Duties
- Dig deep into structured and unstructured datasets to spot patterns and anomalies.
- Visualize data and flag areas of differentiation to make complex ideas simple and accessible.
- Use tools such as Tableau, Smartsheets, Microsoft Power BI, Excel, and Visual Basic to automate analytical tasks and track results.
- Build data models and test analytical skills through creative problem-solving and logical reasoning against existing datasets.
- Create reports that deliver clear messages to stakeholders unfamiliar with the data.
- Automate repetitive tasks using software tools to focus efforts on higher-value analysis.
- Help build and drive a data analytics project to improve data accuracy during integration activities.
- Analyze customer and system data and interact with partners to understand reasons for data anomalies.
Skills and Qualifications
- Minimum one year of experience in sales, marketing, business development, or IT.
- Relevant analytics or BI related working experience preferred, including previous internships on data problem-solving projects.
- Strong knowledge of Microsoft Office, especially Excel and PowerPoint.
- Knowledge of data visualization programs such as Tableau and Power BI.
- Analytical thinking with demonstrated ability to analyze and visualize data.
- Fast learner with willingness to work across multiple data-related topics.
- Good teamwork, communication skills, and a hands-on, open, and motivated approach to work.
4. Analytics Intern (CEE Data Quality and Change Management)
Sitting at the intersection of data analytics and change management, the Analytics Intern works directly with data analysts and developers in the Group Data Analytics team, as well as analyst colleagues across the CEE, to lead status meetings and oversee day-to-day operations of change management and data quality workstreams. Operating across multiple markets and reporting to the Data Lake Product Owner, the intern maintains contact with business responsibles, monitors manual data sources, and prepares materials that enable internal decision-making.
Duties
- Support the overall work of the Data Analytics team in Group Digital Factory across project work and operations.
- Lead status meetings and oversee day-to-day operations of change management and data quality workstreams.
- Present prioritization questions to the Data Lake Product Owner and escalate issues as needed.
- Participate in process and service improvement initiatives related to onboarding, delivery, and reporting.
- Maintain contact with business responsibles from various markets and monitor manual data sources.
- Prepare management and internal decision-making materials as needed.
Experience and Qualifications
- Ongoing studies in economics, management, or IT at BSc or MSc level.
- Experience or strong interest in data analytics and data visualization, including the ability to distill conclusions from data.
- Outstanding knowledge of Microsoft Office applications.
- Availability to work at least 20 hours per week for at least one year with a flexible schedule.
- Ability to collaborate effectively with others across countries and work independently.
- Experience in consumer services, consumer products, or retail domain is an advantage.
- Outstanding communication skills with demonstrated ability to mediate effectively between stakeholders.
- Fluency in English required.
5. Analytics Intern (Finance Reporting and Azure Migration)
A key member of the Group and Regional Finance and IT teams, the Analytics Intern builds and coordinates finance-area reports and supports the migration of existing Power BI infrastructure to Azure-based technology while managing data quality and consistency throughout the transition. Collaborating across GBS, Statutory, and cross-functional business functions, the intern coordinates the newly established GBS academy and supports the integration plan with TCS to ensure continuity of analytics operations.
Functions
- Support the migration of existing Power BI reports to new technology leveraging Azure.
- Provide support in data quality management and consistency during the technology transition.
- Support the organization of the integration plan with TCS.
- Begin the creation of reports in the Finance area, focusing on the Statutory and GBS areas.
- Support the finalization of the new FA module and the update of the FFNF academy.
- Coordinate the creation of the newly established GBS academy.
Technical Qualifications
- University degree in a relevant discipline such as business economics, engineering, or mathematics.
- Knowledge of marketing and sales and experience managing Nielsen, IRI, or Kantar data.
- Knowledge of Power BI is a plus, along with proficiency in PowerPoint and Excel.
- Technical skills in Finance with deep knowledge of SAP and understanding of related systems.
- Strong project management ability and proven capacity to lead change management with diverse stakeholders.
- Business-oriented approach with curiosity and empathy in gathering requirements from business functions.
- Proven digital skills and mindset, with understanding of how data technologies translate to business value.
- Fluent English is mandatory, a second fluent language is required, and a third language is recommended.
6. Analytics Intern (Global Commercial Excellence)
The Analytics Intern owns support for the Global Commercial Excellence organization by assisting Advanced Analytics leads in running commercial business assessments, including LCM opportunity assessments and new product launches, while helping optimize internal and external digital channels for product communication. The work directly supports countries, regions, and internal stakeholders including leadership, brand teams, marketing, operations, and finance in executing global commercial and marketing strategies.
Accountabilities
- Assist Advanced Analytics in running commercial business assessments including LCM opportunity assessments, geographical expansions, and new product launches.
- Assist in the marketing and commercialization of existing products.
- Help optimize internal and external digital channels for product communication.
- Support the creation of deliverables for countries, regions.
- Internal stakeholders including leadership, brand teams, marketing, operations, and finance.
Position Requirements
- Currently enrolled as a BA, MA, or PhD student, or recently graduated within the last 12 months, in economics, technology, or natural science, with a preference for life science or pharmaceutical degrees.
- Preferably with first experience in digital marketing or product management.
- Strong interest in marketing, commercial strategy, and modeling tasks.
- Strong skills in Microsoft Office applications, especially PowerPoint.
- Reliable, self-reflective, and willing to learn, with demonstrated ownership and responsibility for submitted work.
- Excellent oral and written communication skills in English.
7. Analytics Intern (Retail Merchandising)
Based within the Merchandising team, accurate and insightful omni-channel reporting depends on the Analytics Intern, who supports database completion, seasonal pricing coordination, and the development and maintenance of new analytical tools across an omni-channel marketplace. Serving as a cross-functional liaison, the intern collaborates with multiple departments to identify best ways of working and optimal data sources to support the team's key milestones.
Job Functions
- Assist the analytics team in providing accurate and insightful reports on a timely and ad hoc basis across an omni-channel marketplace.
- Support the development, implementation, and maintenance of new tools to assist the merchandising team at key milestones.
- Collaborate with cross-functional departments to identify best ways of working and optimal data sources.
- Support daily tasks including data analysis, system updating, data entries, and reporting responsibilities.
- Support database completion and accuracy as well as seasonal pricing setup and coordination with cross-functional stakeholders.
Background and Experience
- Previous experience in a data role preferred.
- Strong proficiency in Microsoft Office, particularly Excel including VLOOKUPS and Pivot Tables.
- Strong interest in analysis and systems, with comfort working with data and numbers.
- Passion for the apparel and accessories industry, including denim culture and sustainability.
- Proactive and self-organized with strong analytical mindset, attention to detail, and ability to work independently.
- Excellent interpersonal skills with strong time management and organizational ability.
- Fluent in English.
8. Analytics Intern (Gamification and Rewards Optimization)
Analytics Intern leads qualitative and quantitative analysis of Gamification and Rewards programs, running A/B tests, building forecasts, and producing performance reports that justify program impact to upper management across all markets. Success in the position means demonstrating strong cost management to maximize growth opportunities within limited budgets while adapting Challenges design to local market needs in close collaboration with regional stakeholders.
What You'll Do
- Lead qualitative and quantitative analysis of Gamification and Rewards programs to manage program risk and support performance reporting, action plans, forecasting, and impact justification for upper management.
- Support planning and analysis on program design in market with local stakeholders, including setup of Challenges in the deployment process for all markets.
- Provide actionable, data-driven recommendations to improve program impact on business performance.
- Drive continual optimization of Gamification and Rewards programs through continuous A/B testing and scaling of effective initiatives.
- Demonstrate strong cost management capability to maximize growth opportunities within limited budgets.
- Work closely with local stakeholders to adapt Challenges design to market needs and nuances.
Knowledge Skills and Abilities
- Undergraduate or postgraduate students are welcome to apply.
- Working knowledge of SQL and strong familiarity with unit economics, monetization, and revenue management.
- Advanced skills in Microsoft Excel and PowerPoint, with macros as a plus.
- Knowledge and experience with BI tools such as Tableau and Data Studio is a plus.
- Knowledge of big data, data warehouse technologies, Python, or R is a plus.
- Strong problem-solving and analytical skills with the ability to work autonomously in a highly demanding and often ambiguous environment with strong attention to detail.
9. Analytics Intern (Consumer Insights and Beauty Industry)
The Analytics Intern produces monthly market analysis and core brand KPI reporting by aggregating data from panel sources, Google Analytics, Similarweb, CRM, and PR and social visibility datasets, while also setting up new tools to monitor retailer e-commerce platform performance. Working under the direction of the Head of Consumer Insights and Business Analytics Manager, the intern builds distribution trackers from scratch and supports consumer and shopper retail surveys to identify growth opportunities for the beauty sector.
Key Responsibilities
- Set up new tools to monitor performance on retailer e-commerce platforms.
- Support the Head of Consumer Insights and Business Analytics Manager in delivering monthly market analysis and core brand KPIs from multiple data sources including panel data, Google Analytics, Similarweb, CRM, and PR and social visibility data.
- Build a distribution tracker from scratch.
- Support specific market, consumer, and shopper retail surveys or trends under the direction of the Head of Consumer Insights.
- Provide accurate analysis with excellent attention to detail and strong critical reasoning.
Education and Experience
- Ideally a graduate in engineering, mathematics, statistics, or quantitative social sciences such as economics or business studies.
- Experience with panel data sources such as NPD and digital analytics tools such as Google Analytics and Similarweb.
- Proficient in Microsoft Office, especially PowerPoint and Excel, including Pivot Tables and graph creation.
- Strong interest in the beauty industry.
- Excellent analytical acumen with strong numerical capabilities, precise attention to detail, and critical reasoning skills.
- Curious, hands-on, and willing to learn, with excellent written and oral English and the ability to communicate concisely.
- Strong organizational skills with the ability to multi-task and manage time effectively.
10. Analytics Intern (KPI Analytics and Sales Operations)
Embedded within the Sales Operations team, the Analytics Intern develops custom KPI models, builds intelligent dashboards, and provides analytical recommendations on existing and new processes to enhance business strategy and planning. Working closely with stakeholders at all levels of the business, the intern advances commercial outcomes by leveraging data to drive key decisions and communicating analytical insights in compelling, story-driven formats.
Core Functions
- Analyze and maintain the organization's KPIs pertaining to specific projects.
- Communicate and meet with stakeholders to identify opportunities for analytical impact.
- Provide recommendations and operational insight on existing and new processes.
- Analyze data to provide insights that enhance business strategy and planning.
- Create intelligent and informative dashboards to tell stories with data.
- Build custom models and advanced analyses on KPIs to drive key decisions.
Qualifications and Experience
- Recent bachelor's or master's graduate in economics, statistics, or business administration, or equivalent experience.
- Previous experience in project management, analytical implementation, or business analytics.
- Solid knowledge of SQL, with Python or R as a plus.
- Working knowledge of relational databases and how they are manipulated.
- Experience using statistical techniques or advanced modeling.
- Strong analytical skills with proven experience leveraging data for commercial advantage.
- Strong communicator able to work at all levels within the business, with high autonomy, flexibility, and adaptability.
11. Analytics Intern (Digital and AI Consulting)
Reporting to the head of the Digital and AI Consulting practice, the Analytics Intern refines growth strategy by co-developing concepts for new digital and AI consulting offerings, producing sales materials, and supporting client projects across multiple industries. Partnering with the business development team and client workshop participants, the intern strengthens the practice's market presence through industry research, white papers, and thought leadership content on AI-related topics.
Primary Duties
- Co-develop growth strategy and concepts for new digital and AI consulting offerings.
- Contribute to the business development team by creating sales materials and preparing for client meetings.
- Support client projects across different industries to develop the right solutions.
- Support the creation of white papers and industry thought leadership on AI-related topics.
- Conduct data analysis and industry research and compile and present findings.
- Assist with the preparation of business development events and client workshops.
Required Qualifications
- Currently pursuing or recently completed a bachelor's, master's, or MBA degree, with any degree background considered.
- Prior work experience in business development or management consulting, such as through a working student role or internship.
- Ability to build and deliver convincing storylines and presentations using MS PowerPoint or Google Slides.
- Fast learner with great attention to detail and ability to quickly adapt to new environments and challenges.
- Outgoing personality with interest in business development and AI-related management consulting.
- Understanding of the value of teamwork.
- Fluent in English, with German or French as a plus.
- Must hold a Swiss passport or a valid EU/EFTA work permit.
12. Analytics Intern (Marketing Analytics and Automation)
Sitting at the intersection of marketing technology and data strategy, the Analytics Intern oversees the study and refinement of current marketing analytics processes, connects end-to-end marketing flows with existing or new data solutions, and builds frameworks to increase analytical efficiency and coverage of business initiatives. Operating across stakeholder teams and the marketing tech function, the intern scouts automations, shapes product features for best-in-class data tracking, and translates analytics into actionable recommendations that drive data-backed decisions.
Scope of Work
- Study the current marketing analytics process, identify opportunity areas for refinement, and implement solutions to bridge gaps.
- Connect end-to-end marketing flows with existing data solutions or initiate new solutions as needed.
- Devise marketing analytics frameworks to increase efficiency and coverage of business initiatives.
- Scout for potential automations in day-to-day analytics to increase self-serve capabilities of stakeholder teams.
- Liaise with the marketing tech team to shape product features and achieve best standards in data tracking and quality.
- Drive data-backed decisions and translate analytics into actionable recommendations for stakeholders.
Skills and Qualifications
- Experience or understanding of marketing objectives and processes preferred.
- Proficiency in analytics techniques with the ability to define and measure success.
- Knowledge of SQL and statistical or programming languages such as R and Python.
- Structured, scale-focused, and process-oriented mindset.
- Collaborative and friendly approach to work, with strong ability to connect with people and articulate thoughts verbally, visually, or in writing.
- Drive to explore, ideate, try, fail, learn, and repeat.
13. Analytics Intern (E-Commerce KPI and Platform Strategy)
A key member of the new Domestic Appliances e-commerce team led by the E-Commerce Sales Lead, the Analytics Intern leads daily collection, analysis, and reporting of key e-commerce KPIs including traffic, conversion, basket, and media performance, while leveraging data to conduct pre-post analysis of key activities across the consumer shopping journey. Collaborating across a multi-functional team, the intern makes proposals for KPI improvement and helps develop winning platform business strategies through data-driven insights.
Day-to-Day Responsibilities
- Lead collection, analysis, and reporting of daily key e-commerce KPIs including traffic, conversion, basket, media performance, and category and consumer trends.
- Leverage data to conduct pre-post analysis of key activities across the consumer shopping journey within the platform.
- Make proposals for improvement on key KPIs to address identified gaps.
- Solve important business problems and optimize growth opportunities to unlock the growth potential across e-commerce platforms.
- Help the e-commerce platform team develop and implement winning business strategy through data-driven insights.
Minimum Qualifications
- Prefer fourth-year university student.
- Familiarity with BI tools such as Power BI is desirable.
- Ability to build strong relationships and work effectively both as part of a team and independently.
- Excellent communication and presentation skills, both oral and written.
- Out-of-the-box thinking with a drive to come up with solutions and improvements.
- Able to fully commit for a minimum of 6 months from the hiring date.
14. Analytics Intern (Procurement Data Quality)
The Analytics Intern advances data quality and consistency for client-serving teams by supporting preparation tasks including quality checks, dataset combination, unified naming conventions in SQL, Python, and Excel, and automation of repetitive workflows through scripting. The work directly supports the Orpheus platform and client data management operations, enabling better procurement analytics outcomes across an international environment.
Operational Focus
- Support client-serving and knowledge-building teams in data preparation, including quality and consistency checks and combining datasets with unified naming conventions in SQL, Python, and Excel.
- Apply relevant business logic and calculations to data preparation tasks.
- Contribute to tool development by reporting bugs, participating in problem-solving sessions, writing scripts, and working on automation of repetitive tasks.
- Collaborate actively in data management and quality control of client data.
- Develop understanding of procurement analytics, the Orpheus platform, and various databases and tools.
Professional Experience
- Full-time university student in years 2 through 5, studying mathematics, statistics, economics, finance, business administration, business analytics, or engineering.
- Good knowledge of Python and SQL, with Excel as a significant plus.
- Strong analytical and problem-solving skills.
- Consistent, collaborative, and energetic attitude with intellectual curiosity.
- Willingness to work in an international environment.
- Fluent in English.
15. Analytics Intern (Procurement Analytics and Spend Analysis)
Embedded within the procurement analytics function, the Analytics Intern oversees spend and savings analysis, tracks market indexes, and produces Excel reports and presentations on contract compliance while using data visualization software and PPCA methodologies to determine the should-cost of materials and services. Working in close support of procurement analysts, the intern ensures data accuracy and completeness that enables robust business and market intelligence outputs.
Areas of Ownership
- Provide business and market intelligence, manage data and analytics, and track and report procurement metrics.
- Conduct spend and savings analysis and ensure data accuracy and completeness for robust analyses.
- Track market indexes and prepare Excel reports and presentations on spend, savings, and contract compliance.
- Use data visualization software and purchase price cost analysis (PPCA) methodologies to determine should-cost of materials and services.
- Support procurement analysts as needed.
Education and Experience
- Minimum bachelor's degree in business, economics, accounting, finance, or engineering, with final-year students also welcome.
- Advanced Excel knowledge and proficiency in visualization software.
- Interest in development within the procurement or engineering area.
- Ability to multi-task effectively, present data and business cases, and manage time and project priorities well.
- Quick learner capable of working independently with minimum supervision.
- Previous internships in purchasing, manufacturing, lab, or international environments are an advantage.
- Proficient in English.
16. Analytics Intern (AI, Machine Learning, and Supply Chain)
Reporting to the Smart Supply Chain team, the Analytics Intern develops real-time Power BI dashboards and data visualizations, supports AI and machine learning analysis using Python or R, and advances the Supply Chain Control Tower concept while managing sub-project scoping and engagement with project partners. Partnering with the management team and project stakeholders, the intern transforms data into valuable insights that strengthen supply chain decision-making.
Role Responsibilities
- Support AI and machine learning analysis using Python or R.
- Support the Smart Supply Chain team in furthering and improving the Supply Chain Control Tower concept.
- Transform data into valuable insights for the management team.
- Create real-time dashboards in Power BI and develop data visualizations with supporting data models.
- Manage the scoping and coordination of sub-projects and engage with project partners.
Technical Qualifications
- Students of a master's or bachelor's degree in business analytics, information technology, data science, or related disciplines.
- Preferably with past internship experience in business intelligence, data science, supply chain, or related fields.
- Proficient in Power BI and Tableau, with preferred knowledge of Microsoft Azure, R, or Python.
- Analytical mindset with ability to think outside the box and work independently on assigned projects with limited supervision.
- High proficiency in oral and written English.
- Commitment to a 6-month full-time internship required.
17. Analytics Intern (Internal Audit and Predictive Analytics)
As the Analytics Intern, this role creates individual internal audit project documentation, builds risk and control matrices, identifies control weaknesses, and supports the growing use of predictive analytics and AI within the internal audit function across operational, financial, compliance, and IT areas. The Internal Audit team relies on this work to ensure audit findings are documented in accordance with generally accepted auditing standards and that process improvement recommendations reach senior management and internal business partners.
Key Deliverables
- Perform individual internal audit projects across operational, financial, compliance, and IT areas.
- Assist with internal audit scope, build risk and control matrices, and perform internal audit procedures.
- Identify key control points and weaknesses within systems or functions being audited and develop process improvement recommendations.
- Document audit work and findings in accordance with generally accepted auditing standards.
- Support the growing use of predictive analytics and AI within the internal audit function.
- Gain experience in internal audit controls testing and in interacting with internal business partners and senior management personnel.
Minimum Qualifications
- Minimum 12 semester hours at a college or university, or equivalent experience, with a minimum cumulative GPA of 3.0.
- Previous internship and work experience preferred.
- Experience with data modeling and visualization, with Power BI experience as a plus.
- Knowledge of Excel Pivot Tables, with SQL and script writing experience as a plus.
- Strong interest in creating and applying AI solutions.
- Strong written and verbal communication skills with the ability to articulate the relationships and story behind data.
- Strong attention to detail with the ability to juggle multiple competing priorities.
- Demonstrated ability to work as part of a team through student organizations, community involvement, or work experience.
18. Analytics Intern (ETL and Data Warehouse Development)
Embedded within the client analytics team, the Analytics Intern executes ETL processes to extract data from multiple sources and load it into a data warehouse, creates fact and dimension tables to support OLAP cubes, Tableau, and Power BI, and develops reports and dashboards required by clients. Working closely with departments throughout client companies, the intern helps identify KPIs and supports senior management with analysis needed to make important decisions.
Engineering Responsibilities
- Build ETL processes to extract data from multiple sources and load into a data warehouse.
- Transform data by applying business rules, auditing, and staging processes.
- Create fact and dimension tables to support reporting technologies such as OLAP cubes, Tableau, and Power BI.
- Support senior management with analysis needed to make important decisions.
- Help identify KPIs for departments throughout client companies.
- Develop reports and dashboards within reporting technologies including OLAP cubes, Tableau, and Power BI.
Technical Qualifications
- Experience with SQL and proficiency in Excel required.
- Background in technology, mathematics, statistics, accounting, finance, or another quantitative discipline preferred.
- Experience or interest in SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.
- Familiarity with Python, data modeling using the Kimball Method (Star Schema), and cloud technologies is a plus.
- Experience training data science or machine learning models is a plus.
- Intellectual and analytical curiosity with initiative to understand the "why" behind results.
- Comfortable with uncertainty and able to accommodate rapidly changing priorities and timelines.
- Ability to work with different departments, communicate findings company-wide, and identify and raise issues proactively.
19. Analytics Intern (Pricing and Forecasting Analytics)
Reporting to Senior Leaders and the pricing analytics function, the Analytics Intern elevates analytical capability across pricing, forecasting, and cost reporting by building new tools and refining existing reports that draw on data from pricing, innovation, marketing, packaging, and distribution, while leading at least one key business project presented to senior leadership at the end of the internship. Partnering with the broader organization in Canada, the intern tracks Sales Excellence Program results and develops analysis templates that support ad hoc month-end closing and presentation delivery.
Delivery Expectations
- Build new and refine existing reports and tools to improve analytics on pricing, forecasting volumes, and costs across pricing, innovation, marketing, packaging, and distribution data.
- Track and monitor Sales Excellence Program results.
- Conduct ad hoc month-end closing and analysis, including developing and improving analysis and reporting templates.
- Assist in the development and delivery of presentations as required.
- Lead at least one key business project to be presented to senior leaders at the end of the internship.
Experience and Qualifications
- Currently completing the third year of a university degree, with any degree accepted and authorization to work in Canada required.
- Strong analytical and problem-solving skills with strong business intuition and critical thinking capability.
- Sophisticated proficiency in Microsoft Office, particularly Excel.
- Familiarity with statistical tools such as Minitab, R, Power BI, DataBricks, and Microsoft Excel, and multi-dimensional cubes such as Cognos Planning, is an asset.
- Experience with data analysis, statistical analysis, and trade math is an asset.
- Consumer packaged goods, beer, wine, or spirits industry experience is an asset.
- Self-starter with high attention to detail, strong time management, and ability to work independently under tight timelines.
- Excellent leadership, communication, presentation, and negotiation skills, with ability to communicate in French as an asset.
20. Analytics Intern (Business Intelligence and Data Storytelling)
As the Analytics Intern, this role coordinates data analysis and business intelligence development to drive business decisions by building visualizations, finding patterns in structured and unstructured datasets, and managing BI tool reporting infrastructure and web pages for stakeholders. The IT and business partner community relies on this work to receive insights presented creatively across a variety of formats, grounded in analytics communications, newsletters, and blog content.
Work Activities
- Perform data analysis and develop business intelligence and insights to drive business decisions.
- Develop visualizations and reports that communicate the story of the data analysis clearly to stakeholders.
- Find patterns and insights in structured and unstructured data sets.
- Prepare presentations and present findings to leadership.
- Research and develop content on topics pertaining to data and analytics.
- Manage web pages and BI tool reporting infrastructure as needed.
Position Requirements
- Must be actively enrolled in a degree program in business analytics, data science, business intelligence and data storytelling, data analytics engineering, or a related field, with a minimum GPA of 3.0.
- Familiarity with data visualization tools and techniques such as Tableau, Power BI, and Cognos.
- Proven ability to research topics and develop content for analytics communications, newsletters, and blogs.
- Ability to manage multiple projects and deliver on priorities in a timely fashion.
- Comfortable working with small and large data sets in Excel or SQL.
- Ability to visualize and report insights creatively in a variety of formats for various stakeholders.
- Ability to work with both business and IT partners and follow industry best practices.
- Available to work 20 hours per week during the school year, flexing up to 30-40 hours per week during the summer, between 8 am and 5 pm Central Time Monday through Friday.
21. Analytics Intern (Urban Analytics and Spatial Data)
A key member of the Urban Analytics team, the Analytics Intern guides a wide range of data mining, modeling, and visualization tasks that draw on structured and unstructured spatial and non-spatial data from multiple sources, while building client-facing dashboards, applications, and reusable automation scripts. Collaborating across consulting, research, and client-facing functions, the intern supports research and development of innovative products, tools, and platforms and produces graphics, maps, reports, and presentations for internal and external use.
Key Responsibilities
- Perform data mining, data manipulation, data analysis, and data visualization across a wide range of products, projects, and tasks.
- Assist in building complex data models with structured and unstructured data from multiple sources, including spatial and non-spatial data.
- Support and create client-facing, user-friendly dashboards, tools, and applications for desktop or web-based use.
- Create reusable scripts to automate procedures.
- Support research and development of innovative products, tools, and platforms.
- Develop graphics, maps, reports, and presentations for internal and external use, including quantitative and qualitative research and analysis.
Background and Experience
- Bachelor's degree in engineering, economics, urban planning, geography, social science, mathematics, or a related field, with at least three years of study completed, or currently pursuing a master's or PhD in a related field.
- Previous work experience in data engineering, data analysis, data modeling, or data visualization in consulting, research, or academic fields.
- Experience in SQL or NoSQL databases with capability in writing queries and scripts to retrieve or manipulate data, with experience in spatial data as a plus.
- Basic programming skills in at least one language such as Python, R, JavaScript, or VBA/Macros.
- Experience with data visualization tools such as Tableau, Power BI, or other programs and libraries.
- Strong business acumen with demonstrated ability to solve complex business problems.
- Knowledge and enthusiasm for the urban built environment.
- Willingness to learn new skills and automate procedures to reduce repeated manual work.
22. Analytics Intern (Operations Data Analytics and Dashboard Development)
Embedded within the Operations Data Analytics team, the Analytics Intern executes data parsing, manipulation, and synthesis of large volumes of data from multiple sources using Python, R, Tableau, Alteryx, Pentaho, or Informatica to build intuitive dashboards and visualizations that drive business decisions. Working closely with operations stakeholders across Viasat, the intern identifies data gaps, researches methods to fill them, and develops efficient processes for elegant data analysis and visualization.
Core Responsibilities
- Parse and manipulate raw data using tools including Python, R, Tableau, Alteryx, Pentaho, or Informatica, with a strong preference for Python.
- Ingest, understand, and fully synthesize large amounts of data from multiple sources to build a comprehensive understanding of the data story.
- Analyze large data sets, find the truth in data, and develop efficient processes for data analysis and simple, elegant visualization.
- Identify data gaps, research methods to fill these gaps, and provide recommendations.
- Monitor big data using business intelligence tools, simulation, modeling, and statistics.
- Build intuitive and actionable dashboards and data visualizations that drive business decisions using Tableau or similar tools.
Required Qualifications
- Currently pursuing a bachelor's degree or higher in computer science, data science, mathematics, statistics, or a related field.
- Experience with Python, R, SQL, or Tableau.
- Python experience with data visualization packages, data cleansing, and statistics libraries such as pandas, scikit-learn, matplotlib, seaborn, and plotly.
- Strong data wrangling skills.
- Excellent analytical and problem-solving skills.
- Excellent judgment, critical thinking, and decision-making skills with the ability to balance attention to detail with swift execution.
- Strong oral and written communication skills.
- Able to commit to a 10-12 week summer internship.
23. Analytics Intern (Campaign and Competitive Analysis)
Sitting at the intersection of media analytics and client strategy, the Analytics Intern creates competitive reporting and KPI recap reports by researching campaign results across competitive analysis, audience analysis, and conversion volume, while compiling online conversation research on client-related issues and industry trends for use in internal presentations and client deliverables. Operating across account and analytics teams, the intern provides weekly and monthly reporting that keeps stakeholders informed on performance against tracked KPIs.
Accountabilities
- Research, report on, and analyze campaign results including competitive analysis, audience analysis, and conversion volume.
- Conduct and compile online conversation research on client-related issues and industry trends.
- Pull competitive reporting and provide key analysis for internal teams.
- Used in presentations and client deliverables.
- Provide weekly and monthly recap reports to track KPIs for the team.
Skills and Qualifications
- Currently enrolled as a senior in a bachelor's program or a recent graduate in media, marketing, advertising, or a similar field, or possessing relevant prior work or life experience (degree not required).
- Basic understanding of social listening and analytical tools such as Crimson Hexagon, Google Analytics, Radian6, and Simply Measured.
- Proficiency in a Mac environment with experience in Microsoft Excel, Google Docs, and Keynote.
- Strong analytical skills, both quantitative and qualitative, with experience analyzing and making decisions from data.
- Strong written and verbal communication and organizational skills.
- Strong team player able to work effectively in a flexible, dynamic, and fast-paced environment.
24. Analytics Intern (People Analytics and LMS Administration)
As the Analytics Intern, this role coordinates daily report generation, data gathering, cleansing, and visualization for the People Analytics function at Coca-Cola Bottling Investments Group, while supporting automation of reports through Excel Macros and managing the company LMS through course creation, access provisioning, and query resolution. The Coca-Cola BIG associate community relies on this work to maintain operational excellence in people processes and ensure timely, validated data across bottlers and markets.
Day-to-Day Responsibilities
- Support the team in automating reports through Excel Macros as part of an interim solution.
- Generate daily reports and presentations through data gathering, cleansing, and visualization.
- Collect and organize reports and data in an efficient manner.
- Coordinate with associates from different bottlers and markets to validate data and ensure timely completion of reports.
- Assist in the daily management of the company LMS through creating courses, providing access, answering queries, and extracting reports.
Qualifications and Experience
- Preferably a student of information technology, computer science, or any IT-related course.
- Excellent written and oral communication skills.
- Has ownership and good project management skills.
- Extremely diligent, agile, and able to work under time pressure.
- Driven, passionate, proactive, and dependable.
25. Analytics Intern (Digital Analytics and Engineering Pipelines)
The Analytics Intern manages engineering pipelines that automate data management processes and maintains data feeds to advanced analytical systems such as the call center forecasting system, while developing and running analytic reports for marketing and product teams under the supervision of the Director of Digital Analytics. The work directly supports stakeholders at all levels of the organization by interpreting results, drafting presentations, and delivering analytic findings from statistical and relational database analysis.
Key Responsibilities
- Build engineering pipelines to automate processes around data management.
- Conduct data analysis using skills in statistics and database management.
- Maintain data feeds to advanced analytical systems such as the call center forecasting system under the supervision of the Director of Digital Analytics.
- Develop and run analytic reports for marketing and product teams.
- Interpret results, draft presentations, and report analytic findings.
- Support requests for ad hoc reporting assistance and miscellaneous research.
Experience and Qualifications
- Bachelor's or master's degree in a quantitative field such as statistics, computational sciences, or applied mathematics.
- Experience programming in Python or R.
- Experience working with relational databases preferred.
- Experience using Excel and PowerPoint.
- Strong analytical skills and basic skills in statistical analysis.
- Good critical thinking, questioning, and listening skills with excellent attention to detail.
- Strong written and verbal communication skills with the ability to communicate with individuals at various levels within the organization.
26. Analytics Intern (Strategic Business Analysis)
Embedded within the department analytics function, the Analytics Intern designs project-based analyses of real-world business questions by extracting, manipulating, and visualizing data across different platforms and collaborating with business partners inside and outside the department to drive analysis forward. Working under the direction of department leadership, the intern presents findings and recommendations to diverse stakeholder audiences, with an emphasis on informing critical business decisions.
Core Functions
- Perform project-based analyses of real-world business questions under the direction of department leadership.
- Extract, manipulate, and visualize data across different platforms.
- Collaborate with business partners.
- Outside of the department to drive analysis forward.
- Present findings and recommendations to different audiences with an emphasis on informing stakeholders to make critical business decisions.
Required Qualifications
- Pursuing a 4-year college degree or higher in data analytics, economics, statistics, advanced mathematics, or a related field, at junior, senior, or graduate standing.
- Familiarity with at least one relational database, with SQL experience preferred.
- Familiarity with at least one spreadsheet application.
- Strong analytical skills and self-motivated with excellent written and verbal communication skills.
- Detail-oriented with the ability to multitask.
- Willingness to work both independently and in a team-oriented environment.
27. Analytics Intern (IT Workforce Dashboards and Recruitment)
The Analytics Intern runs global IT executive dashboard development and supports the Workforce Transformation Team by collecting, updating, and analyzing data to provide high-level summaries, while also assisting with hiring, campus recruitment program management, and branded merchandise logistics for campus events. The work directly supports IT executives and the broader recruitment function by strengthening the visibility of workforce data and the operational delivery of campus engagement activities.
Scope of Work
- Support the development of global dashboards providing insights to IT executives.
- Collect, update, and analyze details to provide high-level summaries.
- Perform research and summarize findings.
- Assist with the hiring and recruitment process and management of campus recruitment program events.
- Manage branded merchandise for events, including shipment of items to locations participating in campus events.
Qualifications and Experience
- Working toward a bachelor's or master's degree in business administration, MIS, or a related discipline.
- Knowledge of Power BI or a similar data visualization tool.
- Proficient working knowledge of Microsoft Outlook, Excel, and PowerPoint.
- Strong analytical skills and attention to detail.
- Aptitude in organizational, interpersonal, written, and verbal communication skills.
- Open to continuous learning.
Editorial Process and Content Quality
This content is developed by the Lamwork Editorial Team using structured analysis of real-world job data, skill requirements, and hiring patterns.
Research framework by Lam Nguyen, Founder & Editorial Lead.
Reviewed by Thanh Huyen, Managing Editor.
Learn more about our editorial standards.