IT Data Analyst

Old World Industries; Northbrook (IL); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401(k) match

Life insurance

Disability benefits

Paid time off

Holidays

FSAs

Employee assistance

Job summary

Old World Industries seeks a Data Analyst to join the OWI Analytics team in Northbrook, IL. The role partners with business stakeholders to translate questions into analyses that drive decision-making and actionable insights beyond routine reporting.

You will develop dashboards, perform SQL data mining, and validate outputs against SAP as the source of truth, collaborating across data engineering, data science, and business teams to deliver impact.

Qualifications

• Experience with Power BI is required; DEX knowledge is strongly preferred.
• SAP is used as the ERP/source of truth for validation.

Responsibilities

• Translate business questions into structured analyses that drive decision-making.
• Create visualizations and dashboards for global customers to provide business insights.
• Use SQL to mine data and translate business needs into clear visualizations.
• Validate data against SAP and resolve discrepancies before reporting.
• Collaborate with stakeholders and other teams to develop insight‑driven visuals.
• Support reporting projects from requirements gathering through deployment and training.

Skills

Power BI

SQL

AI analytics tools

Data analytics concepts

Communication skills

Analytical thinking

Education

Bachelor's degree

Tools

DEX Deployment Pipelines/Dataflows

SAP

Job description

Position Purpose

The Data Analyst will be part of the OWI Analytics team, partnering closely with business stakeholders to translate business questions into structured analyses that drive decision-making. This role goes beyond report production — it requires understanding the "why" behind a request, identifying the right data and methodology, and delivering insights that business partners can act on.

Duties, Tasks, And Responsibilities

• Learn and map business processes end‑to‑end with stakeholders to identify the KPIs that genuinely measure performance for that process, then determine what data is required to analyze both the KPI itself and the underlying factors driving its performance
• Partner with the Data Engineering and Data Science teams to translate those KPI and data requirements into validated data models — confirming the models actually deliver on the business objective identified in the step above, not just that they're technically complete
• Partner with business stakeholders to scope analytical requests, clarify objectives, and identify the right metrics and data sources before analysis begins
• Create visualizations that provide business insights for our global customers — dashboards, cash‑flow projections, histograms, projective analysis, financial analysis, KPIs, and SLA reporting
• Use SQL to independently mine data and translate business needs into clear, creative visualizations
• Validate data and reporting outputs against SAP as the source‑of‑truth ERP, identifying and resolving discrepancies before they reach stakeholders
• Assess data quality and flag data quality issues to the Data Warehouse team; support data governance practices
• Leverage AI tools (e.g., Copilot in Power BI, generative AI for data exploration and narrative summaries) to accelerate insight generation and surface patterns in large datasets
• Demonstrate critical thinking and sound judgment to offer thoughtful, concise input toward problem resolution
• Collaborate with a wide range of stakeholders, functional teams, and other data analysts to develop insight‑driven visualizations
• Support requirements gathering, design, deployment, and change management for reporting projects (entry‑level project management)
• Build and demo prototypes to stakeholders — peer groups, business partners, and senior leaders
• Support and train peers/SMEs on report usage, troubleshooting, and results analysis
• Develop leadership skills to promote ideas, coordinate work, and plan deliverables within a project team

Education, Skills And Abilities

• Experience with Microsoft Power BI (required); DEX (Deployment Pipelines/Dataflows Experience) knowledge strongly preferred
• Working knowledge of SAP as an ERP/data validation source
• Entry-level SQL proficiency for data querying and mining
• Exposure to AI‑assisted analytics tools (Copilot, generative AI for BI) a plus
• Entry‑level experience with data analytics concepts — data dictionaries, data mapping, normalization concepts
• Basic project management and business process modeling
• Minimum Bachelor's degree in Business, Engineering Technology, Computer Science, or closely related field
• Excellent verbal and written communication skills, with the ability to clearly articulate technical issues to both technical and business audiences
• Strong analytical skills with the ability to solve problems effectively and in a timely manner

This Opportunity Offers a Competitive Benefits Package Including

• Medical, dental, and vision coverage with wellness benefits
• Company‑matching 401(k) plan
• Company‑paid life insurance and accidental death & dismemberment benefits
• Company‑paid long‑term care coverage
• Company‑paid disability
• Flexible spending and health savings accounts
• Company‑paid employee assistance program
• Paid time off and paid holidays
• Additional benefits included: voluntary life insurance, legal benefits, critical illness, accident insurance, and pet insurance

Old World Industries is among the largest privately held companies competing in the automotive aftermarket today. Built upon a 50‑year history of ingenuity, the Northbrook, Illinois‑based company is transforming the automotive, commercial and chemical industries that keep the world moving forward. Old World’s brands include a full line of PEAK® Performance Automotive Aftermarket Products including Antifreeze/Coolant, Washer Fluid, Lighting and Wiper Blades; BlueDEF® Diesel Exhaust Fluid and Equipment; FINAL CHARGE® PRO‑SERIES Heavy Duty Extended Life Coolant, Fleet Charge® SCA Precharged Heavy Duty Coolant and Thermal Charge® Heat Transfer Fluid.