Intern – IT Data Analyst

Join Rensa Filtration Inc as an IT Data Analyst Intern (Finance Focused) working remotely or from Aurora, Kane County, IL. This summer internship offers hands‑on experience analyzing financial data and supporting business decisions.

Key Responsibilities

• Collect, clean, and validate financial datasets from ERP and accounting systems.
• Generate routine and ad‑hoc reports using Excel, SQL, and Power BI.
• Assist the finance team with budgeting, forecasting, and variance analysis.
• Identify data trends, anomalies, and opportunities for process improvement.
• Document data sources, workflows, and analytical methodologies.
• Collaborate with IT and finance stakeholders to ensure data accuracy and security.

Required Qualifications

• Currently pursuing a Bachelor’s degree in Finance, Accounting, Information Systems, Computer Science, or a related field.
• Strong analytical mindset with proficiency in Microsoft Excel (pivot tables, VLOOKUP, macros).
• Basic knowledge of SQL queries and data visualization tools (Power BI or Tableau) is a plus.
• Excellent written and verbal communication skills.
• Detail‑oriented, self‑motivated, and able to work independently in a remote environment.

What We Offer

• Mentorship from senior finance and IT professionals.
• Real‑world exposure to data‑driven decision making in a manufacturing setting.
• Flexible remote work or on‑site experience in Aurora, IL.
• Stipend: $22,549.35 for the internship period.

Frequently Asked Questions

What is the duration of the IT Data Analyst internship?

The internship is a summer program, typically lasting 10‑12 weeks, with flexible start and end dates.

Do I need prior experience with SQL or Power BI?

Basic knowledge is helpful but not required; the internship provides training and mentorship on these tools.

Can I work remotely or do I have to be in Aurora, IL?

The role offers a hybrid option – you can work fully remote or from Rensa Filtration’s office in Aurora, Kane County.