BSA/Data Analyst

Position: BSA/Data Analyst

Location: Philadelphia, PA

Job Description:

This is a BSA/Data Analyst with strong Data Warehouse and advanced SQL experience.

SQL - Must be able to join tables and be expert level.

Previous Healthcare Insurance experience required.

The Business System Analyst role on the EIM - Data Warehouse team requires experience in creating Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications.

This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents and further discussion with data modelers for the necessary table designs.

The ideal candidate should have all of the above skills at expert level along with strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team.

Other preferred experience includes Source-to-Target mapping, health insurance knowledge and general data warehousing. The candidate will also be comfortable enough to support testing, production readiness verification and ensuring accuracy after the deployments. This might include weekend and off hours support.

Skills/Experience:

Mandatory: 6-8 years

1. Strong Data Profiling and Analysis skills

2. Advanced SQL skills

* Must be able to write complex SQL s involving multiple tables and be expert level.

3. Strong Data Mapping and Functional requirements documentation skills

* Should be able to write business and functional requirements

4. Data warehousing knowledge

5. Previous Healthcare Insurance experience required

6. Strong verbal, writing and active listening skills