Business Systems Analyst (BSA) – Data Warehouse

Job Title : Business Systems Analyst (BSA) Data Warehouse

Location : Philadelphia, PA ,Hybrid

Rate : Best competitive rate

Overview

We are seeking an experienced Business Systems Analyst (BSA) with a strong background in Data Warehousing and SQL to support our client's ongoing data initiatives. The ideal candidate will play a key role in translating business requirements into functional and technical specifications, performing data profiling, and supporting data validation and UAT activities within a complex healthcare environment.

Key Responsibilities

Collaborate with business and technical teams to gather, document, and analyze requirements for Data Warehouse projects (preferably in sourcing or outbound extracts).

Develop comprehensive Functional Specifications based on business and system requirements.

Prepare detailed Source-to-Target Mapping Documents for development and QA teams, including joins, filters, and ranking logic to ensure unique record retrieval.

Perform data profiling to identify and resolve data issues prior to data integration into the warehouse.

Conduct Gap Analysis and provide recommendations to address data or process inconsistencies.

Validate data during User Acceptance Testing (UAT) and business checkout using SQL scripts.

Present draft versions of data models and collaborate with stakeholders for feedback and approval.

Maintain strong communication with business, development, and QA teams to ensure alignment across all phases of the project.

Apply strong analytical and problem-solving skills to troubleshoot data-related issues efficiently.

Required Skills & Experience

10+ years of experience as a Senior Business / Systems Analyst .

5+ years of experience in Data Warehousing , SQL , and Data Profiling .

Proven expertise in preparing detailed Mapping Documents used by development and QA teams.

6+ years of experience working on Data Warehouse projects , preferably in sourcing or outbound extracts .

6+ years performing UAT / Business Checkout using SQL scripts.

5+ years in Target Mapping , Gap Analysis , and Functional Specification development .

3+ years focused on Data Profiling (identifying data quality issues prior to warehouse integration).

Strong understanding of RDBMS concepts and relational data modeling.

Excellent communication and analytical skills .

Healthcare domain experience is required.

With Gratitude,

Bhavani Recruiting Manager | Nukasani Group Inc |

Email : Bhavani@nukasanigroup.com

540 W Galena Blvd, Suite 200, Aurora IL 60506.

People, Process, Technology Integrator

An E-Verified Company