Business Intelligence and Data Analyst Job at GAM Enterprises, Inc., Mount Prospect, IL

RXBCY0ZJdFdWZWR1dERKam9LT2hXTXVDUkE9PQ==
  • GAM Enterprises, Inc.
  • Mount Prospect, IL

Job Description

GAM Can, Just ASK! That’s the spirit of our entrepreneurial culture. We live and breathe our core values: Teamwork, Action-Oriented mindset, Long-Term Relationships, Professionalism, and Having Fun.

GAM Enterprises manufactures precision mechanical components used in the robotics and factory automation industry. As we continue to grow, we are building a stronger data-driven and AI-enabled organization, and this role is central to that transformation.

This is a full-time on-site role located in the Greater Chicago Area for a Business Intelligence and Data Analyst. We are seeking a professional to transform raw operational, engineering, and financial data into actionable insights that support decision-making across the organization. This is a high-impact, cross-functional role that owns the full data lifecycle—from extracting and structuring data to building dashboards, delivering insights, and supporting automation and AI initiatives. Unlike traditional reporting roles, this position independently works across ERP, CRM, and internal systems to access, analyze, and translate data into business intelligence. This role will also support internal IT tasks as presented.

RESPONSIBILITIES

  • Extract and query data from ERP, CRM, and internal databases using SQL (T-SQL / SSMS or similar)
  • Clean, validate, and structure data to ensure accuracy, consistency, and reliability across systems
  • Analyze data to identify trends, inefficiencies, and business opportunities
  • Translate business needs into structured data requirements and reporting outputs
  • Build dashboards, reports, and KPI tools using Power BI and advanced Excel
  • Partner with operations, engineering, sales, and leadership teams 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
  • Act as internal liaison for outsourced IT support, including onboarding, access setup, and ticket coordination

QUALIFICATIONS

  • Bachelor’s degree in Data Analytics, Business Analytics, MIS, Computer Science, Engineering, or a related field preferred
  • 4–5 years of experience preferred in data analytics, business intelligence, or a related role
  • Candidates with 2–3 years of strong, relevant experience will be considered
  • Industry experience in mid- to large-sized manufacturing environments is preferred
  • Strong SQL skills (T-SQL, querying, joins, filtering datasets)
  • Advanced Excel skills
  • Power Query (data extraction, transformation, ETL)
  • Power Pivot (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 skills with a curiosity-driven mindset
  • Ability to communicate clearly with both technical and non-technical teams
  • Comfortable working in a fast-paced, evolving, cross-functional environment

COMPENSATION & BENEFITS

Our compensation package includes a competitive base salary, choice of medical plans, company-paid life and disability insurance, 401(k) with company match, paid time off, holidays, flexible work schedule, business casual environment, and more. CONTACT US: If you are qualified and interested in this position, we encourage you to contact us at careers@gamweb.com and start your new career! No third-party contacts please.

Job Type: Full-time

Pay: $80,000.00 - $110,000.00 per year

Benefits:

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

Application Question(s):

  • 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?
  • How many years of Automation Machinery Manufacturing experience do you currently have?

Education:

  • Bachelor's (Required)

Ability to Commute:

  • Mount Prospect, IL 60056 (Preferred)

Work Location: In person

Job Tags

Full time, Work experience placement, Casual work, Flexible hours

Similar Jobs

Pyramid Consulting Group, LLC

Import/Export Coordinator Job at Pyramid Consulting Group, LLC

Our client, a luxury brand, is seeking an Import/Export Coordinator to join their team in Dayton, NJ. This position plays a crucial role in ensuring merchandise and non-merchandise arrive safely and efficiently, while adhering to all federal regulations of import/export...

TrueCare

Behavioral Health Consultant LCSW, LMFT, or Psychologist Job at TrueCare

 ...Opportunity and will not discriminate against an applicant or employee on the basis of any characteristic protected by applicable federal, state, or local law. Our goal is to support all team members recruited or employed here. Powered by JazzHR Compensation details... 

Fieldguide

Senior Product Marketing Manager Job at Fieldguide

 ...commerce and capital markets through automating and streamlining the work of assurance and audit practitioners specifically within...  ...enthusiasm for building a great culture and product, you will find a home at Fieldguide. About the Role We are seeking a Senior Product... 

Central Florida Inpatient Medicine

Pulmonary ARNP-Post Acute Job at Central Florida Inpatient Medicine

 ...Ability to communicate effectively with patients and healthcare staff Ability to use a computer, printer, scanner, and other office equipment Ability to sit, stand, and view a computer screen for extended periods Ability to perform repetitive hand and wrist... 

Wise Coatings of New Hampshire

Experienced Resin Floor Coatings Installer Job at Wise Coatings of New Hampshire

 ...You are eager to learn and can take constructive criticism without getting offended. You will be trained on how to transform floors in garages, basements, warehouses, etc. Floor coatings experience is required for Lead positions. You will be trained in the art...