Power Pivot Data Jobs

1 job found

1mo ago

Business Intelligence and Data Analyst

GAM Enterprises, Inc. Mount Prospect, IL

Mount Prospect, IL

1mo ago Closed

$80k - $110k/yr Full time Analyst Analytical Skills Analytics

This position is no longer accepting applications (closed Jul 13, 2026).

Job Description

GAM Enterprises, Inc. offers a collaborative, outcomes oriented environment in the Greater Chicago Area. This on-site, full-time role provides a competitive annual salary of USD 80,000 to 110,000 and a benefits package that includes 401(k) with matching, health and life insurance, a flexible schedule, and paid time off. You will own the full data lifecycle, turning raw operational, engineering, and financial data into actionable insights that drive cross-functional decisions and support automation and AI initiatives.

Responsibilities

Pull data from ERP, CRM, and internal databases using SQL (T-SQL, SSMS or equivalent) and run queries to access required datasets
Clean, validate, and structure data to ensure accuracy, consistency, and reliability across systems
Analyze data to uncover trends, identify inefficiencies, and reveal business opportunities
Translate business needs into concrete data requirements and reporting outputs
Create dashboards, reports, and KPI tools using Power BI and advanced Excel
Collaborate with operations, engineering, sales, and leadership to enable data driven decision making
Support automation of reporting processes and reduce manual data tasks
Lead exploration and adoption of AI tools to improve efficiency and insight generation
Serve as internal liaison for outsourced IT support, handling onboarding, access provisioning, and ticket coordination

Requirements

Bachelor’s degree in Data Analytics, Business Analytics, MIS, Computer Science, Engineering, or related field preferred
4 to 5 years of experience in data analytics, business intelligence, or a related role preferred
Candidates with 2 to 3 years of strong, relevant experience will be considered
Industry experience in mid- to large-sized manufacturing environments is required
Strong SQL skills including T-SQL, joins, and filtering datasets
Advanced Excel skills
Power Query for data extraction, transformation, and ETL
Power Pivot for data modeling across multiple sources
Experience handling complex formulas and large datasets
Experience with Power BI or similar data visualization tools
Strong analytical and problem solving abilities with a curiosity driven mindset
Clear communicator able to work with both technical and non-technical teams
Hands-on experience evaluating or implementing AI tools to improve reporting, analysis, efficiency, or decision making, with measurable outcomes
Comfortable working in a fast paced, evolving, cross functional environment

Technologies

SQL (T-SQL)
SSMS
Power BI
Excel
Power Query
Power Pivot
Python

Education

Bachelor's degree is required. Preferred fields include Data Analytics, Business Analytics, MIS, Computer Science, Engineering, or related disciplines.

Ability to commute

Mount Prospect, IL 60056 (Required).

Work location

In person

Application questions

How many years of work experience do you have with Microsoft Power BI?
How many years of experience do you have working with SQL/T-SQL?
Are you now, or will you in the future, require visa sponsorship to legally work in the United States?
What experience do you have using Python or scripting for automation?
Do you have industry experience in a mid- to large-sized manufacturing environment?

Compensation & benefits

Job Type: Full-time
Pay: USD 80,000.00 - 110,000.00 per year
Benefits: 401(k); 401(k) matching; Flexible schedule; Health insurance; Life insurance; Paid time off

View full job page →

Get Power Pivot Data Jobs alerts

New Power Pivot Data Jobs, daily.