BI Analyst

blueStone

Chicago, IL, us on site Until 8/21/2026 H-1B sponsor history First posted March 21, 2025 Last posted March 21, 2025

Job description

• ETL tasks supporting a central Datamart, with extended Subject marts • Business Intelligence projects, reports, and analytics • Work with Hyperion HFM, Planning and ESSBASE strategies • Support and design complex Reports • Develop modern visual analytics with meaningful content and little instruction • Debug ETL, monitor BI content, and troubleshoot BI solutions as needed • Write relational TSQL database queries, create tables, views, and stored procedures in Sql Server 2013+ • Work with business stakeholders in a non-formal environment to produce formal requirements. • Compose technical and end-user documentation for every project. English writing skills are mandatory.

• Bachelor’s degree in Computer Science, Information Systems or other related field; 2 – 3 years of experience; or equivalent combination of education and experience. • Proven knowledge and experience with at least one ETL tool, SQL, SSAS, SQL Server • Working knowledge of modern ETL concepts • Excellent communication skills

•Benefits kick in immediately- no waiting period •10 paid holidays •3 weeks’ paid vacation •*** Flexible schedule; their hours are 7a-6p so if you preferred you could work 7a- 3p, 8-4p, 9-5p etc which I think is a great benefit if you have kids especially or this also is a great work-around for traffic •Summer hours- Memorial Day through Labor Day the office closes at 1p everyday •12 days remote of work allowed a year- doesn’t count towards PTO •BlueCross benefits- PPO, HSA, flex spending account, short and long-term disability, life, tuition reimbursement and certification and continued education reimbursement after first 90 days •401k match up to 5%

About this role

Summary

Support ETL, develop reports, and create visual analytics for business intelligence projects.

Job title

BI Analyst

Experience level

2-3 years

Industry

software

Location requirements

On-site in Chicago, IL, with 12 days remote allowed

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

Skills & keywords

Required skills

ETLSQLSSASSQL Server

Preferred skills

None specified

Specializations

ETLSQLBIreportingvisual analytics

Locations

Structured locations inferred from the posting.

Chicago, IL, USA

Hybrid City