Jr. Reporting Analyst

Group O, Inc.; Illinois; On-site; USD 44,000 - 47,000; Full time

Benefits offered by this job

Medical, Dental, Vision, and Life Ins.

401(k) Plan with Company Match

Generous Paid Time Off

10.5 Paid Holidays

Career Development Opportunities

Job summary

Group O, Inc. is seeking a Jr. Reporting Analyst in Milan, IL to support reporting, analytics, and data activities for internal teams and external clients.

You will prepare, validate, and analyze data, maintain recurring reports and dashboards, modify SQL queries, and present results in client-ready formats. Under guidance from the Analytics Director and senior staff, you will ensure reporting is accurate, timely, and aligned with stakeholder needs.

Qualifications

• Bachelor's degree or equivalent training/experience.
• 1–2 years in reporting, analytics, BI, data analysis, or related role.

Responsibilities

• Run, review, and modify SQL queries for recurring/ad-hoc reporting.
• Use intermediate Excel to organize and summarize data from multiple sources.
• Perform data quality checks and escalate issues.
• Support creation, maintenance, and refresh of reports, dashboards, and KPI reporting.
• Assist with Power BI report/dashboard updates and data refresh validation.
• Gather, clarify, and document reporting requirements from stakeholders and clients.
• Prepare clear report explanations, summaries, and findings for clients and internal teams.
• Research report results to answer client questions and communicate findings.
• Assist senior analysts with reporting tasks and client initiatives.
• Track and resolve reporting issues and data inconsistencies.
• Identify trends and explain variances to support business recommendations.

Skills

SQL

Excel

Attention to detail

Communication

Problem solving

Teamwork

Education

Bachelor's Degree

Tools

Power BI

Tableau

Job 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