EDW BSA Lead

Lead Business Systems Analyst – Enterprise Data Warehouse

Our 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, Data Stage, Python/PySpark, Infogix and Tableau. This is a hybrid role. Candidates must be located in Columbus, Ohio and work in the office a minimum of 4 days each week.

• Serve as a liaison and knowledge source with stakeholders, product owner and team members.
• Work in an Agile environment and effectively develop Features and User Stories with the team.
• Facilitate and gather requirements, including documenting source-to-target data mappings.
• Work with Product Owner and other SMEs to refine Epics, triggering creation of Features and User Stories.
• Facilitate backlog refinement sessions to produce user stories ready to be prioritized.
• Participate in the identification, quantification and mitigation of project risks and issues.
• Work with the Application BSAs to identify and escalate impediments to completing the requirements to the Scrum Master.

• Bachelor’s Degree.
• 7+ years of experience as a Business Systems Analyst in a Data Warehouse environment.
• 3+ years of experience using SQL to create ad‑hoc queries and analyze data.

• 5+ years of experience in financial services (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 applying enterprise data warehousing best practices and standards.
• 5+ years of experience in data mapping, 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 communication skills.

• Experience leading other BSAs on a project team.
• Data Warehouse, SQL, Requirements gathering, data mapping, ETL, Python, Gherkin, Cucumber, Pytest BDD.

Contract to Hire position based out of Columbus, OH.

Pay range: $45.00 – $70.00 per hour.

• Medical, dental & vision
• Critical Illness, Accident & Hospital
• 401(k) – Pre‑tax and Roth post‑tax contributions available
• Life Insurance (Voluntary Life & AD&D for employee and dependents)
• Short and long‑term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, vacation or sick leave)

Hybrid position in Columbus, OH.

Position anticipated to close on February 24, 2026.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.