Business Intelligence Analyst

Thesciongroupllc; Chicago (IL); On-site; USD 63,000 - 69,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401k Matching

Paid Maternity Leave

FLSA Status

Discretionary annual EOY bonus

Paid Time Off

Job summary

The Scion Group LLC in Chicago, IL is hiring a BI Analyst to execute complex data analysis and reporting initiatives. You will partner with business leaders to define requirements, design dashboards, and provide actionable insights that support strategic decision-making.

Responsibilities include gathering data from multiple sources, building interactive dashboards, and delivering data-driven recommendations to improve performance. Apply your SQL and Excel skills to drive business outcomes.

Qualifications

• Bachelor's degree in Data Analytics, Statistics, Finance, CS, Mathematics, or IS.
• 2-5 years of experience in BI or analytics roles.
• Strong SQL proficiency.
• Advanced Excel skills.
• Hands-on dashboard experience (Looker preferred).
• Experience with SharePoint and ClickUp preferred.
• Strong problem solving and project management skills.
• Ability to work independently with minimal oversight.

Responsibilities

• Independently gather and validate data from multiple sources.
• Design and maintain dashboards and reporting in Excel, Looker, and BI tools.
• Perform advanced trend analysis to identify business drivers.
• Translate requirements into SQL queries, data models, and analytical frameworks.
• Deliver data-driven recommendations to improve performance.
• Support ad hoc analytic and scenario modeling requests.
• Collaborate with Data Science and Data Engineering for reporting needs.
• Serve as analytics partner to various business units.

Skills

SQL

Advanced Excel

Dashboard design

Independent work

Analytical thinking

Education

Bachelor's degree in Data Analytics or related field

Tools

Looker

SharePoint

ClickUp

Job description

Want to learn more about The Scion Group? Check out our website.

We're hiring immediately!

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to sponsor visas.

Your Opportunity

The BI Analyst executes complex data analysis and reporting initiatives. This role partners closely with business leaders to define requirements, design dashboards, and provide actionable insights that support strategic and operational decision‑making.

Your Responsibilities

• Independently gather, integrate, and validate data from multiple internal and external sources
• Design and maintain interactive dashboards and scalable reporting solutions in Excel, Looker, and other BI tools
• Perform advanced trend analysis and statistical evaluation to identify business drivers
• Translate business requirements into SQL queries, data models, and analytical frameworks
• Deliver data-driven recommendations to improve performance and operational outcomes
• Support ad hoc analytic and scenario modeling requests
• Work closely with Data Science and Data Engineering to support reporting needs
• Serve as key analytics partner to various business units

The responsibilities listed above may not be all inclusive.

Qualifications

• Bachelor's degree in Data Analytics, Statistics, Finance, Computer Science, Mathematics, Information Systems, or related field
• 2-5 years of experience in business intelligence, analytics, or related role
• Strong SQL proficiency
• Advanced Excel skills
• Hands‑on experience building dashboards required (Looker preferred)
• Experience with SharePoint and ClickUp preferred
• Strong problem solving and project management skills
• Ability to work independently with minimal oversight

Operational Details

• Job location is based at Scion headquarters in Chicago, IL
• Working hours are general daytime business hours

Your Benefits

• Health Insurance
• Dental Insurance
• Vision Insurance
• 401k Matching
• Paid Maternity Leave
• FLSA Status
• Discretionary annual EOY bonus
• Paid Time Off

Illinois Pay Range

$63,000 — $69,000 USD

The base salary range for this full‑time position is base + bonus + benefits. Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job‑related skills, experience, and relevant education or training. Your recruiter can share more about the specific salary range for your preferred location during the hiring process.

The Scion Group LLC provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, religion, creed, national origin, color, gender, sex, sexual orientation, gender identity or expression, age, physical or mental disability (as long as the employee/applicant is otherwise qualified for the job with or without a reasonable accommodation), genetic information, HIV/AIDS status, marital status, uniformed service, veteran status, pregnancy or other legally protected status or category under federal or state law. The Scion Group LLC complies with applicable state and local laws governing nondiscrimination in employment in all locations in which the Company has properties. This policy applies to all terms and conditions of employment, including hiring, placement, promotion, termination, layoff, recall, transfers, leaves of absence, compensation, training and other terms and conditions of employment. The Scion Group LLC is committed to the principles of equal employment opportunities.