Business System Analyst

Cygnus Professionals; Hoffman Estates (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading consulting firm in Hoffman Estates is seeking an experienced data architect to conduct requirements gathering and document business processes. The role requires a strong background in Enterprise Data Warehouse architecture with a minimum of seven years of experience, including at least two years in Teradata or Oracle. Candidates must possess excellent SQL skills and the ability to produce high-quality work under pressure. The position offers a dynamic work environment and opportunities to engage with various business users.

Qualifications

• Minimum of seven years of experience in deploying solution designs and software development.
• At least 4 years in Enterprise Data Warehouse architecture.
• 2+ years experience in Teradata or strong Oracle experience required.

Responsibilities

• Conduct requirements gathering and analyze source data.
• Document business processes, meeting minutes, and follow up on action items.
• Create business requirements documents and metrics mapping.

Skills

Enterprise Data Warehouse architecture solution

SQL skills

Teradata or strong Oracle experience

Interviews with business users

Test script creation

Agile/Scrum methodology

Experience in retail environment

Job description

Conduct Requirements gathering sessions / JAD sessions

Document business processes

Document meeting minutes and follow up with responsible teams on action items

Create Business requirements document, Metrics Definition and mapping documents

Analyze source data and document any source data issues

Maintain a good communication channel with Business users, architects, DBAs and project teams

Involve in creating Logical & Physical Data Model and DDL's

Develop test cases and scripts for testing

Data validation and document results

Support QA & UAT

Skill requirements:

• Minimum of Seven or more years of experience in deploying solution designs and software development of which at least 4 years of solid Enterprise Data Warehouse architecture solution
• At least 2+ year experience in Teradata is must (or a very strong Oracle experience 4+)
• Expertise in interviewing various business users
• Strong SQL skills are essential
• Experience in creating test scripts
• Experience in working with Microstrategy reports and dashboard is a plus (This is just using for pull out reports)
• Prior project experience using agile/scrum methodology will be a plus
• Ability to produce high quality work products under pressure and within deadlines
• Ability to thrive in a fast paced, dynamic environment
• Experience in a retail environment and/or analytics solutions for huge volumes of data will be a plus.

Additional Information

All your information will be kept confidential according to EEO guidelines.