• 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.

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.

Skill/Experience/Education:

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. Strong verbal, writing and active listening skills

Desired:

Healthcare insurance experience is a huge plus!

Job Type: Full-time

Pay: $50.00 - $60.00 per hour

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Experience level:

• 7 years
• 8 years

Schedule:

• Monday to Friday

Application Question(s):

• This is W2 role. We need GC or US citizen only.
• We need candidates from PA, DE, NJ only.

Experience:

• business system analyst/data analyst: 7 years (Preferred)
• data mapping and analysis: 3 years (Preferred)
• data ware house: 3 years (Preferred)
• SQL: 4 years (Preferred)
• data profilings: 3 years (Preferred)
• Healthcare: 2 years (Preferred)

Work Location: In person