Business Intelligence & Data Analyst

Business Intelligence & Data Analyst (162388) Mount Prospect, Illinois Salary: USD95000 - USD115000 per year Business Intelligence & Data Analyst (MIS / AI / Data Operations Lead) Mission/Purpose The Business Intelligence & Data Analytics Analyst is a cross functional role responsible for transforming raw operational, engineering, financial, and commercial data into actionable business intelligence that drives decision making across the organization. This role owns the full data lifecycle, from data extraction and structuring through analysis, reporting, and insight delivery. Unlike traditional analyst roles, this position independently accesses and works with data across systems without reliance on IT for routine data retrieval. In addition to analytics, this role serves as a bridge between business operations and technical systems, supporting AI adoption, reporting automation, and coordination with outsourced IT resources. Core Functional Areas Data Extraction & Mining Write and execute SQL queries (T SQL, SSMS, or equivalent) across ERP, CRM, and internal databases Extract, join, and structure datasets from multiple systems Independently retrieve data directly from source systems Identify relevant datasets to support business questions Data Management & Structuring Clean, validate, and standardize datasets to ensure accuracy and consistency Maintain data integrity across reporting platforms Assist in maintaining data structures and data warehouse usability Business Intelligence & Analytics Analyze datasets using statistical methods, trend analysis, and modeling Identify inefficiencies, patterns, and improvement opportunities Translate data into actionable insights and business recommendations Partner with leadership across operations, sales, engineering, and finance Build and maintain dashboards using Power BI and advanced Excel Develop KPI tracking aligned with company goals Create clear, user friendly reports for non technical stakeholders Integrate reporting into ERP/CRM systems where applicable Support adoption and use of AI tools across the organization Identify opportunities to automate reporting and workflows Assist in developing AI driven tools, agents, or process improvements Evaluate emerging technologies relevant to business operations IT Liaison & Systems Support (Outsourced IT Coordination) Act as internal point of contact for outsourced IT support provider Manage and triage IT helpdesk tickets Coordinate issue resolution with external partners Support new hire onboarding setup: user accounts and system access, ERP/CRM permissions, email and hardware/software readiness Strategic Impact Responsibilities Improve reporting automation and reduce manual processes Increase visibility into key business metrics across departments Support continuous improvement initiatives with measurable insights Bridge communication between technical systems and business teams Skills & Qualifications Education & Experience Bachelor's degree in Data Analytics/Business Analytics, Management Information Systems (MIS), Computer Science/Engineering, or related field preferred 4 to 5 years of experience preferred in data analytics, business intelligence, or related role High potential candidates with 2 to 3 years of strong, relevant experience may be considered Technical Skills Advanced to Expert Excel, including Power Query (ETL, data transformation), Power Pivot (data modeling, multi source datasets), and complex formulas and large dataset management Strong SQL proficiency (joins, filtering, query optimization) Power BI (dashboard development and visualization) Experience with ERP systems (Epicor or similar) Experience with CRM systems (HubSpot or similar) Understanding of relational databases and data structures Preferred / Emerging Skills Experience with data modeling or data warehouse concepts Exposure to AI tools, automation platforms, or workflow optimization Familiarity with scripting (Python, PowerShell, or similar) is a plus Core Competencies Strong analytical and critical thinking skills Ability to translate business problems into data driven solutions High attention to detail and data accuracy Effective communication across technical and non technical audiences Ability to manage multiple priorities in a fast paced environment Curiosity driven mindset with a focus on continuous improvement Strong ownership and accountability Salary Range: $95K - $115K Benefits: Medical, dental, and vision insurance available Work Environment: Onsite 5 days a week first 6 months and hybrid once this is complete

#LI-SK1

#DICE

LNTS #J-18808-Ljbffr The LaSalle Network