Senior BSA: Retail Banking Data Integration (Remote)

Apex Systems; Trenton (NJ); Remote; USD 110,000 - 160,000; Full time

Benefits offered by this job

Medical insurance

401K with company match

Employee stock purchase program (ESPP)

Dental and vision

Job summary

Everforth Apex Systems is seeking an experienced Business Systems Analyst with Retail Banking Data Integration and Migration expertise for a remote, US-based initiative. You will bridge business stakeholders and technical teams to ensure accurate data requirements, mappings, and validation throughout the project lifecycle.

Key responsibilities include gathering requirements, analyzing source/target systems, maintaining STTM docs, and performing data profiling and validation using SQL.

Qualifications

• 7+ years of Business Systems Analysis experience supporting enterprise data initiatives.
• Strong hands-on SQL expertise, including complex joins, CTEs, aggregations, analytical queries, and data validation techniques.
• Demonstrated experience with data profiling, data analysis, and reconciliation.
• Strong understanding of data warehousing concepts, including ETL/ELT processes, dimensional modelling, fact and dimension structures, staging environments, and data marts.
• Extensive experience creating and managing Source-to-Target Mapping (STTM) documentation.
• Experience with data integration, migration, conversion, and data quality initiatives.
• Excellent analytical, problem-solving, communication, and documentation skills.

Responsibilities

• Gather, analyze, and document business, functional, system, and data requirements.
• Analyze source and target systems, data models, interfaces, and business processes.
• Develop and maintain STTM documentation with transformation logic and validation rules.
• Perform data profiling, analysis, reconciliation using SQL.
• Identify data quality issues, mapping discrepancies, transformation requirements, and data gaps.
• Collaborate with stakeholders, architects, developers, data engineers, and QA teams for successful delivery.
• Support data migration activities, SIT, UAT, conversion rehearsals, cutover planning, and post-production validation.
• Ensure full traceability of requirements, rules, and data mappings through development and testing phases.
• Assist in issue resolution and provide recommendations for data quality and process improvements.

Skills

SQL

Data profiling

Data analysis

STTM documentation

ETL/ELT

Data warehousing

Stakeholder communication

Retail Banking domain

Job description

Everforth Apex Systems is seeking an experienced Business Systems Analyst with Retail Banking Data Integration and Migration expertise for a remote, US-based initiative. You will bridge business stakeholders and technical teams to ensure accurate data requirements, mappings, and validation throughout the project lifecycle.

Key responsibilities include gathering requirements, analyzing source/target systems, maintaining STTM docs, and performing data profiling and validation using SQL.