Business System Analyst

Business System Analyst - Data Warehouse

Job : Contract: W2
Company : Dew Softech Inc
Location : Remote or Philadelphia, PA
Posted On: 13 October 2023

Job Description:

Position: Business System Analyst - Data Warehouse

Location: Hybrid or Remote, Philadelphia PA

Duration: 12+ months

Rate: Open

Interview: Video

Title: Data Architect/ Business System Analyst

Note from the Manager:

Looking for advanced SQL skills and Google Cloud (or AWS) experience. Open to fully remote candidates with ongoing contract renewals.

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)
  • Strong Data Profiling and Analysis skills
  • Strong SQL knowledge
  • Strong Data Mapping and Functional requirements documentation skills
  • Strong verbal, writing and active listening skills

Data warehousing knowledge

Skills

  • Business Analysis, Data Warehouse, Google Cloud, AWS