Senior Data & Reporting Analyst

Oil-Dri Corporation of America; Chicago (IL); On-site; USD 92,000 - 120,000; Full time

Benefits offered by this job

Annual bonus

401(k) with match

Health insurance

Dental coverage

Paid time off

Wellness reimbursement

Merit increase opportunity

Cross-functional exposure

Job summary

Oil-Dri Corporation of America in Chicago is seeking a data analytics professional to develop reports and dashboards, translate data into actionable insights, and support data-driven decision-making across finance, operations, supply chain, and commercial sales.

This role works across technical tools and business teams to optimize reporting platforms, build semantic layers, and drive adoption of analytics across the organization.

Qualifications

• Bachelor’s degree in a technical field or analytics-related discipline.
• 4–7 years of experience in data analytics, reporting, or BI.
• Advanced experience with Power BI, Tableau, or similar tools.
• Experience building reports, semantic layers, and table joins.
• Strong understanding of business processes across operations, finance, or supply chain.
• Proficiency with SQL, Python, or R for data analysis.

Responsibilities

• Develop, modify, and support reports, dashboards, and visualizations across operational and analytical reporting tools.
• Create database relationships, table joins, and semantic layers within reporting platforms.
• Gather requirements from business users and align reporting solutions with goals.
• Analyze data to identify patterns, trends, and insights to support initiatives.
• Provide training, documentation, and knowledge transfer for reporting tools.
• Support user adoption by leading user groups and assisting with access and admin tasks.

Skills

Power BI

Tableau

ReportsNow

SQL

Python

R

Education

Bachelor’s degree

Tools

JD Edwards

Oracle

SAP

Job description

Location: Chicago, IL (Wrigley Building)

Compensation: $92,000 – $120,000 + annual bonus

Regular in-person attendance consistent with the Company's established work schedule is an essential function of this position to facilitate effective collaboration, communication, and business operations.

Position Summary

This position supports enterprise data, analytics, and reporting initiatives across Oil-Dri. The role partners with business users across finance, operations, supply chain, and commercial sales to gather data needs, develop reports and dashboards, and support data-driven decision-making.

This position is well suited for someone who can work across technical tools and business teams, translate data into usable insights, and help increase adoption of reporting platforms across the organization.

The Opportunity

• Support enterprise-wide analytics and reporting initiatives across multiple business functions
• Partner with teams in finance, operations, manufacturing, supply chain, and commercial sales
• Build and enhance dashboards, reports, semantic layers, and data visualizations
• Help business users better understand reporting tools, data sets, and insights
• Join a stable manufacturing company where data work is close to the business and directly supports operational and strategic decisions

Primary Responsibilities

• Develop, modify, and support reports, dashboards, and visualizations across operational and analytical reporting tools
• Create database relationships, table joins, and semantic layers within relevant reporting platforms
• Partner with business users to gather requirements and align reporting solutions with organizational goals
• Analyze data to identify patterns, trends, and insights that support business initiatives
• Provide training, documentation, and knowledge transfer for reporting tools and data sets
• Support user adoption by assisting with questions, leading user groups, and collaborating with super users
• Coordinate with the help desk on user access and administrative tasks within BI tools
• Support project lifecycle activities including requirements gathering, testing, validation, and dashboard/report deployment
• Work across technical and non-technical teams to improve reporting accuracy, usability, and adoption

Candidate Profile

• Bachelor’s degree in Computer Science, Data Science, Engineering, Statistics, Finance, or another technical field
• 4–7 years of experience in data, analytics, reporting, or business intelligence
• Advanced experience with data visualization tools such as Power BI, Tableau, ReportsNow, or similar platforms
• Experience building advanced reports, semantic layers, and table joins
• Strong understanding of business processes across operations, manufacturing, finance, commercial sales, or supply chain
• Strong analytical, problem-solving, and communication skills
• Ability to explain technical concepts to both technical and non-technical stakeholders
• Ability to collaborate with and mentor business users across multiple functions
• Strong time management skills with the ability to balance technical, analytical, and user-support responsibilities

Preferred Experience

• Experience working with ERP data, particularly JD Edwards, Oracle, or SAP
• Proficiency with SQL, Python, R, or other data/statistical languages
• Experience in manufacturing, industrial, supply chain, or multi-functional business environments

Compensation and Benefits

• Competitive pay: $92,000 – $120,000
• Annual bonus opportunity
• 401(k) with 6% company match
• Paid parental leave, PTO, and holidays
• Employer-supported health and dental coverage
• Fitness and wellness reimbursement
• Annual merit increase opportunity
• Career growth through cross-functional exposure, business partnership, and leadership visibility

About Oil-Dri

Oil-Dri Corporation of America is a leading specialty minerals manufacturer serving consumer and business-to-business markets. We offer the stability of an established manufacturing company with the visibility, ownership, and direct impact of a more closely connected organization. Our teammates help Create Value From Sorbent Minerals every day.

Equal Opportunity Statement

Oil-Dri is committed to providing equal opportunity for all teammates and qualified candidates without regard to race, color, creed, religion, sex, age, sexual orientation, national origin, ancestry, citizenship, marital status, mental or physical disability, veteran status, or any other characteristic protected by federal, state, or local laws.