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.
We are not able to provide employment visa sponsorship now or in the future for this position. Applicants must be authorized to work in the United States without current or future sponsorship.
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 inmid- to large-sized manufacturing environments is required
- 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
- Hands-on experience evaluating, implementing, or leveraging AI tools to improve reporting, analysis, operational efficiency, or business decision-making, with examples of measurable and sustainable outcomes.
- 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 [email protected] 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
- 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?
- 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?
Education:
Ability to Commute:
- Mount Prospect, IL 60056 (Required)
Work Location: In person
