Business Systems Analyst (BSA) – Data Mapping

Hi,

Hope you are doing well!!

I have an urgent requirement with one of my clients. Please find the job details below and forward me your updated resume along with your contact details at Jitendra.s@noviainfotech.com

Job Description

Role: Business Systems Analyst (BSA) – Data Mapping

Location: Raleigh, NC / Phoenix, AZ / Remote

Work Mode: Onsite or Remote (as applicable)

 

Role Overview

We are seeking an experienced Business Systems Analyst (BSA) with strong Data Mapping and SQL expertise to support system integrations, data migrations, and ETL initiatives. The ideal candidate will act as a bridge between business stakeholders and technical teams, ensuring accurate data transformation, validation, and alignment with business requirements.

 

 

Key Responsibilities

System Data Analysis & Mapping

Lead end-to-end data mapping initiatives for system integrations, migrations, and ETL processes

Analyze source and target data structures to identify relationships, dependencies, and transformation requirements

Create detailed source-to-target mapping documentation, including field-level specifications, transformation rules, and business logic

Develop data lineage diagrams and data flow documentation to ensure traceability

Perform data profiling and data quality assessments to identify gaps, anomalies, and inconsistencies

Define data validation rules and acceptance criteria for data migration and integration efforts

Collaborate closely with data engineers and developers to ensure accurate implementation of mapping specifications

SQL Development & Data Analysis

Write complex SQL queries to extract, transform, validate, and reconcile data across multiple databases

Develop and maintain stored procedures, views, and scripts for data analysis and reporting

Perform post-migration data validation and reconciliation to ensure data integrity

Optimize SQL queries for performance and efficiency

Conduct root cause analysis using SQL to troubleshoot data issues

Create ad-hoc reports and data extracts to support business intelligence and decision-making

Support database design reviews and contribute to data model optimization

Business Analysis

Required Qualifications

Technical Skills

Advanced SQL expertise, including:

Complex joins (inner, outer, self, cross)

Subqueries, CTEs, and window functions

Aggregations, grouping, pivoting

Query optimization and performance tuning

Stored procedures, triggers, and views

Strong experience in data mapping, including:

Source-to-target mapping

Business Analysis Skills

5–7 years of experience as a Business Analyst or Business Systems Analyst

Strong requirements elicitation, documentation, and stakeholder communication skills

Experience working in Agile/Scrum environments

Proficiency with tools such as Jira and Confluence

Experience with UAT coordination, test case development, and defect management

Strong understanding of SDLC best practices

Jitendra Singh

Sr.Technical Recruiter

Jitendra.s@noviainfotech.com

--
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CAMkiYD3No%3DByuZL8gnsNO0ddSivLEJi8gmd%3DzQu-dMxrF3q1tw%40mail.gmail.com.