Business Systems Analyst - EDW..

Business Systems Analyst - EDW

Location: Columbus, Ohio (Hybrid weekly schedule)

Role Overview

An opportunity is available for a Lead Business Systems Analyst in an Enterprise Data Warehouse (EDW) environment. This role involves developing solutions that enable the business to leverage data as a key asset. The Lead Business Systems Analyst will work with business units to understand needs, document technical requirements, and manage the product backlog. Key technologies used include Snowflake, DataStage, Python/PySpark, Infogix, and Tableau.

Key Responsibilities

• Serve as a liaison and knowledge source for stakeholders, the product owner, and team members.
• Operate within an Agile framework to develop Features and User Stories with the team.
• Collaborate with the Agile team, Product Owner, and business stakeholders to gather and facilitate requirements, including documenting source-to-target data mappings.
• Work with the Product Owner and other subject matter experts to refine Epics, leading to the creation of Features and User-Stories.
• Facilitate backlog refinement sessions to detail user stories, define acceptance criteria, and establish story points with team members.
• Participate in the identification, quantification, and mitigation of project risks and issues.
• Work with Application Business Systems Analysts to identify and escalate impediments to the Scrum Master.

Required Qualifications

Education: A Bachelor's Degree is required.

Experience: 7+ years of experience as a Business Systems Analyst in a Data Warehouse environment is required.

Technical Skills: 3+ years of experience using SQL to create ad-hoc queries and analyze data is required.

Preferred Qualifications

• 5+ years of experience in the financial services or banking industry.
• 5+ years of experience with Snowflake and AWS S3.
• 5+ years of experience with data modeling activities in Erwin or other modeling tools.
• 5+ years of experience with enterprise data warehousing best practices and standards.
• 5+ years of data mapping experience, creating source-to-target mappings.
• Strong organizational, analytical, and problem-solving skills.
• Ability to effectively prioritize and execute tasks while handling multiple projects.
• Excellent verbal and written communication skills.
• Experience leading other Business Systems Analysts on a project team.

Work Environment

This is a hybrid role. The candidate will need to be located in Columbus, Ohio, and is expected to work in the office a minimum of four days each week.

Required Skills: EDW (preferably Snowflake), SQL, Azure DevOps, ETL, work as BSA or similar.

Basic Qualification:

Additional Skills:

Background Check: Yes