Business Intelligence & Data Analyst Job at Union Park Capital, Mount Prospect, IL

Y2ZNaDhvV1owYndmbE8zc0lCQWRZbjUxbmc9PQ==
  • Union Park Capital
  • Mount Prospect, IL

Job Description

Our Values
GAM Can! That is our passion. The spirit of our entrepreneurial culture. We live and breathe our core values of Teamwork , being Action-oriented , building Long-term relationships , being Professional at what we do, and having Fun .

GAM is a portfolio company of Union Park Capital.

Overview
For more than 30 years, GAM Enterprises has built motion control components that advanced machines depend on when precision and engineering expertise is mission critical. From surgical robots in the operating room to robots in automated warehouses that move packages faster and more safely and to the assembly floor of aircraft manufacturers, GAM’s technologies make the world a safer and more productive place.

GAM is a fast-growing, entrepreneurial company, driven by a “GAM Can” attitude that values collaboration, customer focus and ownership that shows up in the quality of our work and is central to our purpose. We are a high-integrity team of people working across engineering, operations, and sales to wow our OEM machine building customers by solving their toughest engineering challenges.

The Data Analyst role is central to GAM's long term growth strategy. As the company scales through global acquisitions, you will build the data foundation, tools and dashboards that turn raw operational data from disparate sources into clear, data-driven insight that drive decisions at the highest levels of the business. With direct visibility to the C-Suite, you will be well positioned as a data-driven storyteller to shape strategy and impact performance.

Responsibilities
  • Establish and maintain a single source of truth by consolidating data from ERP, CRM, and manufacturing systems into clean, reliable, reportable datasets.
  • Build insightful 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
  • 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 related field preferred
  • 4+ years of experience preferred in data analytics, business intelligence, or related role
  • Strong ability to communicate data-driven story lines to technical and non-technical teams
  • 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)
    • Complex formulas and large dataset handling Experience with Power BI or similar data visualization tools
  • Strong analytical and problem-solving skills with a curiosity-driven mindset
  • Comfortable working in a fast-paced, evolving, cross-functional environment

Job Tags

Full time

Similar Jobs

Gpac

Entry Level Recruiter, Remote! Job at Gpac

Recruiting Partner - Transform Careers and Lives with gpac Make an Impact. Build a Career. Earn Without Limits. gpac (Growing People and Companies) has grown from a small, family-owned business into one of the nation's top recruiting firms over the last 30+ years . ...

Sync Staffing, Inc

Class C Driver- Ontario Job at Sync Staffing, Inc

JOB ALERT!!** Now hiring- CLASS C DRIVERS Location: Ontario Schedule: Monday-Friday 7AM-3:30PM Pay rate: $22h/r ~ Must be 22 years old or older ~ Must have NO traffic violation s in the past 1 year ~ Must be able to work overtime ~1 year of driving experience... 

Phoebe Ministries

Pharmacy Courier Driver Job at Phoebe Ministries

 ...Pharmacy Courier Driver Lancaster, PA Phoebe Ministries is hiring a Per Diem Pharmacy Courier Driver to join our Pharmacy located...  ...responsible for the safe and timely transportation of prescription medications from our pharmacy to various locations. Phoebe offers... 

Comsip

Contract Engineer Job at Comsip

 ...site. FEED shall be followed by an EPC roll over to Mc Dermott in consortium with Petrojet, local construction company. A Project Management Team is created through technical service agreements, mainly with Shell. The client is in charge to provide a service for contract... 

Mangrum Career Solutions LLC

Anesthesiologist Job at Mangrum Career Solutions LLC

 ...Anesthesiologist Physician Join a dynamic and supportive team in a modern, 155-bed community-based teaching hospital in Southwest...  ...Certified Registered Nurse Anesthetists (CRNAs), and Anesthesiology Assistants (AAs). Position Details: Schedule: Monday through...