You are viewing a preview of this job. Log in or register to view more details about this job.

Data Analyst Intern

AspireHR
Email

Position Summary

The Data Analyst supports business operations by developing and maintaining recurring reports, dashboards, and data extracts that provide visibility into ticket volume, performance, SLA attainment, and operational trends. This role partners with service delivery, technical teams, and payroll/finance stakeholders to ensure reporting is accurate, timely, and actionable. The analyst leverages strong SQL and advanced Excel skills to validate data, automate recurring deliverables, and continuously improve reporting processes and data quality.

What You’ll Gain in This Internship

  • Hands-on experience building real Service Desk KPI reports and dashboards used by leaders to run day-to-day operations.
  • Stronger SQL skills through writing and refining queries (joins, CTEs, aggregations) to pull and validate data from production systems.
  • Advanced Excel practice including pivots, lookups, data cleansing, and repeatable templates (with exposure to Power Query where applicable).
  • Experience in building Salesforce dashboards and reports
  • Exposure to how payroll/timekeeping reporting works, including reconciliations, exception handling, and translating business rules into calculations.
  • Experience partnering with stakeholders to clarify requirements, define metrics, and present findings in a clear, actionable way.
  • Professional development through feedback, documentation best practices, and opportunities to automate and improve recurring reporting processes.
  • Ability to learn and receive certifications in SAP SuccessFactors

 

You’ll be supported by a team that will provide onboarding, regular check-ins, and guidance on priorities—while giving you ownership of meaningful deliverables you can showcase in a portfolio.

Key Contributions

  • Deliver accurate, repeatable Service Desk reporting that supports operational decision-making and service review discussions.
  • Build and enhance dashboards and KPI packs (e.g., SLA, backlog, aging, first contact resolution, reopen rate) to surface trends and risks.
  • Support payroll and timekeeping reporting needs by producing reconciliations, exception reports, and ad hoc analyses.
  • Improve data quality and consistency by defining data definitions, validating source system outputs, and documenting report logic.
  • Increase efficiency through automation and standardization (SQL queries, Excel Power Query/pivots, scheduled refreshes) for recurring deliverables.

Essential Duties and Responsibilities

Service Management Reporting & Dashboarding

  • Develop, maintain, and enhance dashboards and recurring KPI reporting for the Service Desk (volume, backlog, SLA performance, aging, trends, and throughput).
  • Write and optimize SQL queries to extract, join, and transform data from ticketing platforms and supporting data sources.
  • Validate data accuracy and completeness (categorization, timestamps, assignments, resolution codes) and partner with process owners to correct root issues.
  • Create clear visuals and concise narratives that explain performance drivers, emerging risks, and recommended actions for stakeholders.
  • Create dashboards and reports in Salesforce to support Service Management activities.

Continuous Improvement & Stakeholder Support

  • Support service review preparation by producing metrics packs, answering KPI questions, and helping track reporting-related action items.
  • Identify opportunities to streamline and automate reporting (e.g., standardized SQL views, scheduled refreshes, Excel Power Query, reusable templates, Salesforce dashboards, reports, or workflows).
  • Analyze trends across tickets and operational data (top categories, repeat drivers, peak periods, handoff delays) and recommend process improvements.
  • Partner with technical and business stakeholders to define KPIs, align on metric definitions, and communicate results in a clear, actionable way.

Required Qualifications

  • Bachelor’s degree in Business Analytics, Information Systems, Computer Science, Statistics, Finance, or a related field (or equivalent practical experience).
  • Strong SQL skills (writing complex queries with joins, CTEs, aggregations, and data validation techniques).
  • Advanced Excel skills (pivot tables, lookups, charts; Power Query and/or Power Pivot preferred).
  • Experience building and maintaining operational reports/dashboards and translating requirements into clear, repeatable deliverables.
  • Strong attention to detail, data integrity mindset, and ability to communicate findings to technical and non-technical audiences.

Preferred Qualifications

  • Experience with data modeling & analysis.
  • Experience with ticketing tools (e.g., ServiceNow, Jira Service Management, Zendesk) and working with ticket data structures.
  • Comfort with data governance practices (definitions, documentation, access controls) and continuous improvement/automation mindset.

Core Competencies

  • Customer focus and responsiveness.
  • Analytical thinking and ability to identify trends in operational data.
  • Attention to detail and data integrity mindset.
  • Time management and prioritization in a queue-based environment.
  • Collaboration and clear communication with technical and non-technical stakeholders.