EDW BSA Lead

Description
This person will be expected to be onsite 4 days a week. Candidates must be onsite in Columbus, OH. This is a technical BSA role. Candidates must be strong with SQL and have great Enterprise Data Warehouse experience.
Summary:
Bank 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.
This is a hybrid role, candidate will need to be located in Columbus, Ohio and work in the office a minimum of 4 days each week.
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.
Basic Qualifications
Bachelor's Degree
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.
Skills
Data Warehouse, SQL, Requirements gathering, data mapping, ETL, Python, Gherkin, Cucumber, Pytest BDD
Top Skills Details
Data Warehouse,SQL,Requirements gathering,data mapping
Experience Level
Expert Level
Job Type & Location
This is a Contract to Hire position based out of Columbus, OH.
Pay and Benefits
The pay range for this position is $45.00 - $70.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the 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)
Workplace Type
This is a fully onsite position in Columbus,OH.
Application Deadline
This position is anticipated to close on Mar 19, 2026.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

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

About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

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.