- Salary
- $32 – $34/hr
- Location
- Milan, IL (4905)
- Type
- Full-time
- Experience
- 1+ years
- Source
- Pinpoint
Description
Jr. Reporting Analyst
Department: Client Services/Customer Success
Employment Type: Full Time
Location: Milan, IL (4905)
Reporting To: Amy McCarrell
Compensation: $32.00 - $34.00 / hour
Description
The Jr. Reporting Analyst supports reporting, analytics, and data activities for internal teams and external clients. This role assists with preparing, validating, and analyzing data; maintaining recurring reports and dashboards; modifying existing SQL queries; and communicating results in a clear, client-ready format. The Jr. Reporting Analyst works under the guidance of the Analytics Director and senior team members to ensure reporting is accurate, timely, and aligned with stakeholder needs.
Job Responsibilities
Essential Functions:
- Run, review, and modify existing SQL queries to support recurring and ad-hoc reporting needs.
- Use intermediate Excel skills to organize, validate, analyze, and summarize data from multiple sources.
- Perform data quality checks, including identifying discrepancies, validating report outputs, and escalating issues when needed.
- Support the creation, maintenance, and refresh of recurring reports, dashboards, and KPI reporting.
- Assist with Power BI report or dashboard updates, data refresh validation, and basic visualization enhancements.
- Gather, clarify, and document reporting requirements from internal stakeholders and external clients.
- Prepare clear report explanations, summaries, and findings for client-facing and internal audiences.
- Support client questions by researching report results, validating data, and communicating status or findings professionally.
- Assist senior analysts with assigned reporting tasks, enhancements, analysis requests, and client-facing initiatives.
- Track, document, and help resolve reporting issues, data inconsistencies, and process questions.
- Use reporting and analytics to identify trends, explain variances, and support business recommendations under guidance.
- Build strong working relationships with internal partners, clients, and cross-functional teams.
Position type
- Full time
Job Qualifications
Education/Certifications:
- Bachelor’s Degree or equivalent combination of training and experience
Experience:
- 1–2 years of experience in reporting, analytics, business intelligence, data analysis, or a related role; equivalent training or education may be considered.
Preferred Experience:
- Working knowledge of querying relational databases or demonstrated aptitude for learning query tools.
- Exposure to business intelligence, reporting, analytics, or dashboard support.
- Power BI dashboard development, maintenance, data visualization, or report refresh experience preferred.
- Experience working with client-facing reports, operational data, web portals, warehouse management systems, or ERP systems preferred.
- Previous Telecom, Retail, Customer Success, or operations support experience preferred.
Skills and Qualifications:
- Strong attention to detail with the ability to review data for accuracy, completeness, and consistency.
- Ability to work with data received in multiple formats from clients, internal systems, and business partners.
- Basic-to-intermediate SQL skills, including the ability to run, review, and modify existing queries.
- Intermediate Microsoft Excel skills used for data organization, validation, analysis, and summarization.
- Ability to explain reporting results, trends, and variances in a concise and easily understood manner.
- Excellent written and verbal communication skills with a professional, service-oriented approach to client and stakeholder interactions.
- Strong organizational, documentation, and task management skills with the ability to meet deadlines and manage assigned work accurately.
- Curiosity, problem-solving ability, willingness to learn, and ability to work both independently and as part of a team.
Preferred Skills and Qualifications:
- Exposure to Power BI, Tableau, or another business intelligence platform.
- Experience creating or maintaining reports, dashboards, KPI summaries, or recurring analytics deliverables.
- Ability to interpret business requirements and translate them into reporting or data request documentation.
- Familiarity with data visualization concepts and effective visual storytelling.
- Customer service, listening, communication, critical-thinking, and problem-solving skills.
Physical Requirements: N/A
Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed, as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
Benefits
- Medical, Dental, Vision, and Life Insurance
- Flexible Spending Accounts (Medical and Dependent Care)
- 401(k) Plan with Company Match
- Generous Paid Time Off
- 10.5 Paid Holidays
- Career Development Opportunities
Skills
SQLExcelTableauPower BICustomer ServiceERP