Business Intelligence Analyst

Aditi Consulting; Chicago (IL); On-site; USD 82,656 - 89,544; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401(k) plan with employer match

10 paid days off

3 days paid bereavement leave

Commuter benefits

Job summary

A national consultancy firm is seeking a detail-oriented and analytical Business Analyst to support their Distribution M&A team in Chicago. The ideal candidate will manage multiple projects, analyze complex datasets, and work closely with cross-functional teams to optimize processes. A Bachelor's degree and at least 4 years of experience as a business analyst are required. This role offers a competitive pay range of $60.00 - $65.00 per hour along with a comprehensive benefits package.

Qualifications

• 4+ years of experience as a business analyst with a focus on analytics.
• Proficient with data analysis tools and SQL proficiency.
• Strong understanding of business processes related to Sales, Marketing, and IT.

Responsibilities

• Support account matching ensuring accuracy and consistency.
• Develop reports to track key metrics for decision-making.
• Analyze datasets to identify trends and anomalies.
• Collaborate with stakeholders for data needs.
• Present findings and recommendations clearly.
• Identify opportunities for process improvements.
• Investigate and resolve issues promptly.
• Communicate technical concepts to various audiences.

Skills

Data analysis in Google Sheets/Excel

Writing and executing SQL queries

Understanding of general business processes

Knowledge of fundamental IT concepts

Communication of complex concepts

Education

Bachelor's degree in business administration

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Aditi Consulting. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$60.00/hr - $65.00/hr

Payrate

$60.00 - $65.00/hr.

Summary

We are seeking a detail-oriented and analytical Business Analyst to support the Distribution M&A team. The role is responsible for analyzing complex datasets, supporting key operational processes, and collaborating closely with different cross-functional teams. The ideal candidate can manage multiple projects simultaneously, investigate and resolve issues independently, and play a critical role in supporting the account matching and mapping process. Your work will drive informed, data-driven decision-making and help optimize processes across the organization.

Responsibilities

• Support the account matching and mapping process ensuring accuracy and consistency
• Develop and maintain reports and dashboards to track key metrics and support business decision-making.
• Analyze complex datasets from various sources (including Tableau, and Snowflake) to identify trends and anomalies
• Collaborate with business stakeholders to understand their data needs and provide analytical support
• Present findings, insights, and recommendations clearly and concisely to stakeholders
• Identify opportunities to streamline operational processes and implement improvements to enhance efficiency and effectiveness
• Investigate and resolve issues in a timely manner
• Ability to communicate complex technical concepts effectively to both technical and non-technical audiences

Qualifications

• Bachelor’s degree in business administration, Computer Science, Information Systems, or a related field.
• 4+ years of experience as a business analyst, with a strong focus on analytics
• Must be proficient with:
• Strong data analysis in Google Sheet/Excel
• Writing and executing SQL queries for data extraction
• (CRM) - Account, Opportunity, Reports and related fields
• General Business Processes (Sales, Marketing, Service, Support)
• Fundamental IT concepts (databases, security, networking) and basic programming concepts

Pay Transparency

The typical base pay for this role across the U.S. is $60.00 - $65.00/hour. Non-exempt positions are eligible for overtime at a rate of 1.5 times the base hourly rate for all hours worked in excess of 40 in a work week, or as required by state or local law. Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education and experience. Full-time employees are eligible to select from different benefits packages. Packages may include medical, dental, and vision benefits, health savings accounts with qualified medical plan enrollment, 10 paid days off, 3 days paid bereavement leave, 401(k) plan participation with employer match, life and disability insurance, commuter benefits, dependent care flexible spending account, accident insurance, critical illness insurance, hospital indemnity insurance, accommodations and reimbursement for work travel, and discretionary performance or recognition bonus. Sick leave and mobile phone reimbursement provided based on state or local law.