Business System Analyst (BSA) Basic Data Warehousing concepts – Fact/Dimension with SCD Type I & II
Contract
Remote
Job Description:
Gathers business requirements from Business teams.
Perform Data Analysis and data profiling based on requirement. Also perform impact analysis.
Prepare Source to Target Data Mapping sheet and provide walkthrough to ETL Dev and QA teams.
Validate the data in UAT environment and present it to Business team for their approval.
Perform postproduction data validation
Partner with cross-functional teams to deliver projects that drive real value for our customers and the business.
Act as a key liaison between stakeholders and developers, making sure nothing gets lost in translation.
Mandatory Skills:
Total 10+ years of experience as a Business System Analyst (BSA)
6+ years of experience in the Banking sector.
Basic Data Warehousing concepts – Fact/Dimension with SCD Type I & II
Strong in writing complex SQLs using Regular Expressions, Windows function
A strong understanding of banking products, regulatory frameworks, and core banking platforms.
Familiarity with CCAR, BASEL, AML/KYC, loan origination systems, Loan IQ or digital banking platforms.
Comfort with business process mapping, data analysis, and documentation like BRDs, FRDs, S2T (Source to Target Data Mapping) and user stories.
Excellent communication skills you’re just as comfortable talking to executives as you are with developers.
Experience with tools like JIRA, Confluence, Visio, or other Agile/Scrum tools.
Must have Skills:
6+ years of experience as a Business System Analyst (BSA) in the Banking sector.
Strong understanding of banking products, regulatory frameworks, and core banking platforms.
Strong SQL knowledge mandatory – 5+ years
Good To have Skills:
Experience with tools like JIRA, Confluence, Visio, or other Agile/Scrum tools
Understanding of payment systems, ISO 20022, or SWIFT messaging. Certifications like CBAP, Agile BA, or PMI-PBA.
Job Description:
Gathers business requirements for Business teams. Perform Data Analysis and data profiling based on requirement.
Prepare Source to Target Data Mapping sheet and provide walkthrough to ETL Dev and QA teams.
Validate the data in UAT and present it to Business team for their approval.
Perform postproduction data validation Partner with cross-functional teams to deliver projects that drive real value for our customers and the business.
Act as a key liaison between stakeholders and developers, making sure nothing gets lost in translation.
What You Bring:
Total 10+ years of experience 6+ years of experience as a Business System Analyst (BSA) in the Banking sector.
A strong understanding of banking products, regulatory frameworks, and core banking platforms.
Familiarity with CCAR, BASEL, AML/KYC, loan origination, or digital banking platforms.
Comfort with business process mapping, data analysis (strong SQL knowledge mandatory), and documentation like BRDs, FRDs, S2T and user stories.
Excellent communication skills you’re just as comfortable talking to executives as you are with developers. Experience with tools like JIRA, Confluence, Visio, or other Agile/Scrum tools.
Bonus Points:
Understanding of payment systems, ISO 20022, or SWIFT messaging. Certifications like CBAP, Agile BA, or PMI-PBA.
Thanks & Regards,
send C2C requirements
🔔 Get our daily C2C jobs / Hotlist notifications on WHATSAPP Channel US Jobs