Business Analyst - Data Warehouse

Position: Business Analyst - Data Warehouse

Location: Hybrid, Philadelphia PA (must be local to PA, NJ, or DE) consultant will be expected to come into the office 3x/week

Duration: 6 months contract w/ potential hire

Rate: Open

Interview: Video

Requirements List:

1. Strong Communication Skills
2. Strong SQL Skills
3. Data Warehouse Experience
4. Business Analyst Experience
5. Local/Onsite

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