Business Intelligence and Data Analyst

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., * 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

Do you have experience in Teamwork?, Do you have a Bachelor's degree?, * 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, * 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)

Pulled from the full job description

• 401(k)
• Health insurance
• 401(k) matching
• Paid time off
• Life insurance
• Disability insurance
• Paid holidays, 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, * 401(k)

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