Business Systems Analyst – EDW

Job Title: Business Systems Analyst – EDW

Location: Columbus, OH, 

Must reside in Columbus, OH this is 4 days onsite

Job Description:

Summary:

Client is looking for a Lead Business Systems Analyst (BSA) in our Enterprise Data Warehouse (EDW). In this role you will be part of a team working to develop solutions enabling the business to leverage data as an asset at the bank. As a Lead BSA Analyst, you will work with the business to understand their needs, document technical requirements and build/manage the product backlog. Key EDW technologies include Snowflake, DataStage, Python/PySpark, Infogix and Tableau.

Responsibilities:

• Serves as a liaison and knowledge source with stakeholders, product owner and team members.
• Work in an Agile environment and is expected to take requirements and effectively develop Features and User Stories with the team.
• Work with the Agile team, Product Owner, and business stakeholders to facilitate and gather requirements, including documenting the source to target data mappings.
• Work with Product Owner and other SMEs to refine Epics – which triggers creation of Features and User-Stories
• Facilitate backlog refinement sessions to refine user story details, acceptance criteria, and establish story points with team members. These meetings should result in user stories ready to be prioritized into the backlog.
• Participates in the identification, quantification and mitigation of project risks and issues.
• Responsible for working with the Application BSAs to identify and escalate impediments to completing the requirements to the Scrum Master.

Must Have:

Must have banking or financial experience

7+ years of experience as Business Systems Analyst in a Data Warehouse environment.

3+ years of experience using SQL to create ad-hoc queries and analyze data.

Preferred Qualifications

• 5+ years experience in financial services (banking) industry.
• 5+ years experience with Snowflake and AWS S3.
• 5+ years experience data modeling activities in Erwin or other modeling tools
• 5+ years experience enterprise data warehousing best practices and standards.
• 5+ years experience data mapping experience creating source to target mappings.
• Highly motivated with strong organizational, analytical, and problem-solving skills.
• Ability to effectively prioritize and execute tasks and handle multiple projects simultaneously.
• Excellent verbal and written communications skills.
• Experience leading other BSAs on a project team.