Business Systems Analyst: BI, Data Warehousing & Analytics

Stem Xpert; Chicago (IL); On-site; USD 70,000 - 90,000; Full time

Job summary

A financial services company in Chicago is seeking a Business Systems Analyst to collaborate with Treasury business partners and the Data Analytics team. The ideal candidate should excel in communication, possess a good grasp of banking concepts, and have experience with BI tools like Qlikview and IBM Cognos. Responsibilities include documenting requirements, conducting system integration testing, and aiding in user acceptance testing. This full-time role requires a strong analytical background and comfort with senior executives.

Qualifications

• Strong communication skills in both verbal and written form.
• Familiarity with banking or accounting concepts and terminology.
• Experience in multi-dimensional and relational data modeling.
• Proficiency in statistical analysis, data mining, and ETL processes.
• Complete life-cycle experience in BI and data warehousing.
• Comfortable engaging with Senior executives.

Responsibilities

• Work with Treasury partners to document requirements.
• Collaborate with Data Analytics on existing solutions.
• Engage with nForm BI team on tools for required functionality.
• Conduct requirement reviews for the BI team.
• Perform System Integration testing for solutions.
• Assist business partners in planning and executing UAT.

Skills

Verbal and written communication skills

Familiarity with banking/accounting concepts

Experience with OLAP and OLTP data modeling

Statistical Analysis and Data Mining

Experience with BI and data warehouse lifecycle

Interacting with Senior level executives

Tools

Qlikview

IBM Cognos BI

TM1

SPSS

SAS

Job description

A financial services company in Chicago is seeking a Business Systems Analyst to collaborate with Treasury business partners and the Data Analytics team. The ideal candidate should excel in communication, possess a good grasp of banking concepts, and have experience with BI tools like Qlikview and IBM Cognos. Responsibilities include documenting requirements, conducting system integration testing, and aiding in user acceptance testing. This full-time role requires a strong analytical background and comfort with senior executives.