Business Intelligence & Data Analyst

Union Park Capital • Mount Prospect, IL

1d

About The Position

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.

Requirements

• 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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level