Mount Prospect, IL

Data Jobs in Mount Prospect, IL

2 jobs found

Include remote jobs

29d ago

Business Intelligence and Data Analyst

GAM Enterprises, Inc. Mount Prospect, IL

Mount Prospect, IL

29d ago

$85k+/yr Full time Analyst Analytical Skills Analytics

Apply Now

Job Description

GAM Enterprises, Inc. is seeking a seasoned data professional to anchor its data foundation and analytics capabilities. This on-site, full-time role focuses on turning raw data from ERP, CRM, and manufacturing systems into actionable insights that inform strategic decisions at the highest level, with direct visibility to the C-Suite. The ideal candidate will combine strong data engineering, reporting, and storytelling skills to empower cross-functional leadership.

Responsibilities

Establish and maintain a single source of truth by consolidating data from ERP, CRM, and manufacturing systems into clean, reliable, reportable datasets.
Develop dashboards, reports, and KPI tools using Power BI and advanced Excel for senior and executive leadership.
Clean, validate, and structure data to ensure accuracy, consistency, and reliability across systems.
Extract and query data from ERP, CRM, and internal databases using SQL (T-SQL / SSMS or similar).
Translate business needs into structured data requirements and reporting outputs.
Analyze data to identify trends, inefficiencies, and business opportunities.
Collaborate with operations, engineering, sales, and leadership to support data-driven decision-making.
Support automation of reporting and reduction of manual data processes.
Lead exploration and adoption of AI tools to improve efficiency and insight generation.
Serve as internal liaison for outsourced IT support, including onboarding, access setup, and ticket coordination.

Requirements

Bachelor’s degree in data Analytics, Business Analytics, MIS, Computer Science, Engineering, or related field preferred.
4+ years of experience in data analytics, business intelligence, or related role preferred.
Strong ability to communicate data-driven storylines to technical and non-technical teams.
Proficient SQL skills (T-SQL, querying, joins, filtering datasets).
Advanced Excel skills, including Power Query (ETL) and Power Pivot (data modeling across multiple sources).
Experience with Power BI or similar data visualization tools.
Complex formulas and handling large datasets.
Strong analytical and problem-solving skills with a curiosity-driven mindset.
Comfortable working in a fast-paced, evolving, cross-functional environment.

Technologies

Power BI
Excel
SQL
SSMS
Power Query
Power Pivot
Python

Benefits

401(k)
401(k) matching
Flexible schedule
Health insurance
Life insurance
Paid time off

Job Details

Job Type: Full-time

Salary: USD 85,000 per year

Location

Location: Mount Prospect, IL 60056 (onsite, 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?

View full job page →

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 →

Data Jobs in Mount Prospect, IL

Business Intelligence and Data Analyst

Business Intelligence and Data Analyst

Get Data Jobs in Mount Prospect, IL alerts