BI Analyst

Location: Chicago

Company Description

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.

Qualifications
• 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

Additional Information

•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%

Responsibilities

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.

Requirements

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