Position: Business Analyst Data Warehouse

Location: Onsite/Hybrid, Philadelphia PA

Duration: 6 month contract-to-hire

Rate: Open

Interview: Video

Resources Needed: 3

This is a BSA position - candidates must be local as hybrid work schedule is required.

Note from the Manager:

Looking for advanced SQL skills and Google Cloud (or AWS) experience

Job Description:

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 (Advanced skills with 6-8 yrs of experience)

1. Strong Data Profiling and Analysis skills
2. Strong SQL knowledge
3. Strong Data Mapping and Functional requirements documentation skills
4. Strong verbal, writing and active listening skills

Desired

1. Data warehousing knowledge
2. Healthcare experience