Data Architect / BSA

"This • Philadelphia, PA

1d • Hybrid

About The Position

This is a BSA position - hybrid work schedule is preferred. 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. 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. Candidates should be local to the office.

Requirements

• Expert level Business Requirement Documents creation skills.
• Expert level Functional Requirement Documents creation skills.
• Expert level Mapping documents creation skills for ETL applications.
• Extensive SQL experience in writing complex queries across multiple tables.
• Expert level data analysis skills.
• Expert level data profiling skills.
• Strong verbal and written communication skills.
• Strong active listening skills.
• Strong Data Profiling and Analysis skills
• Strong SQL knowledge
• Strong Data Mapping and Functional requirements documentation skills
• Strong verbal, writing and active listening skills

Nice To Haves

• Source-to-Target mapping experience.
• Health insurance knowledge.
• General data warehousing knowledge.
• Data warehousing knowledge
• Healthcare experience

Responsibilities

• Creating Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications.
• Writing complex SQL queries across multiple tables.
• Data analysis and profiling for the creation of mapping documents.
• Discussing necessary table designs with data modelers.
• Working with various stakeholders to gather and formulate business requirements.
• Translating business requirements to the technical team.
• Supporting testing, production readiness verification, and ensuring accuracy after deployments.
• Supporting weekend and off-hours deployments.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed