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