EDW Lead Business Systems Analyst (BSA)

Overview

Hybrid
Depends on Experience
Contract - W2

Skills

Banking
Data Mapping
SQL
Snow Flake Schema
Modeling

Job Details

We re seeking an experienced EDW Lead Business Systems Analyst (BSA) to join our team supporting enterprise data warehousing initiatives. This role will lead data analysis, modeling, and mapping activities across large-scale financial services projects, ensuring high-quality, scalable data solutions. The ideal candidate is hands-on, detail-oriented, and experienced guiding other BSAs through the full project lifecycle.

What You ll Do:

  • Lead BSA activities for enterprise data warehouse (EDW) projects, guiding requirements, data modeling, and source-to-target mapping.

  • Partner with business and technical teams to translate business needs into clear, actionable data requirements.

  • Ensure alignment with enterprise data warehousing best practices and data management standards.

  • Support solution design and validation leveraging SQL, Snowflake, and AWS S3.

  • Provide mentorship and oversight to other BSAs within the project team.

Preferred Qualifications:

  • Experience in the financial services or banking industry.

  • Strong knowledge of Snowflake and AWS S3 environments.

  • Data modeling expertise using Erwin or similar tools.

  • Proven success in data mapping and source-to-target analysis.

  • Excellent communication, organization, and analytical skills.

  • Ability to manage multiple priorities and deliver results in a fast-paced environment.

Technical Skills:

  • 3+ years using SQL or equivalent query tools.

  • Experience with AWS Snowflake Cloud Data Warehouse.

Nice to Have:

  • Prior experience conducting data mapping analysis in large-scale data environments.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About w3r Consulting