Business System Analyst Job at Cloudious LLC in Philadelphia

Title: Business System Analyst

Location: Philadelphia, PA (Onsite role)

Duration: 6 Months

Responsibilities:
Perform Data Profiling (Identify all data issues before getting the data to DW)
Prepare Functional Specification based on the interaction with Business and Technical teams
Prepare Mapping Document to be used by Dev and QA team (Detailed level required. Provide Joins, Filters and Ranking (if required) to get UNIQUE records)
Good understanding of RDBMS concepts
Present the draft version of Data Model
Perform UAT/Business Checkout using SQL Scripts

Requirements:
At least 3 years with Data Warehouse, 5 years with SQL and 8 years on a BSA / Technical role
Solid Healthcare Domain Knowledge
BSA Experience in Data Warehouse projects (Preferably in Sourcing or Outbound Extracts)
Good Communication Skills
Good Analytical skills
Prepared Source to Target Mapping
Performed Gap Analysis / Data Profiling
Prepared Functional Specifications working with Business
Strong SQL skills

Mandatory Areas:
Must have Skills
Skill 1 Yrs of Exp Very Strong SQL Coding (5+ years)
Skill 2 Yrs of Exp Perform Data Profiling / Data Mining / Data Structures / Data Modeling (5+ years)
Skill 3 Yrs of Exp Prepared Source to Target Mapping / Mapping Documents / Gap Analysis (5+ years)
Skill 4 Yrs of Exp - Create FRD, BRD / Functional specifications (8+ years)
Skill 5 Yrs of Exp - Slowly changing Dimension - All types (1 year in recent project)

Domain Experience (If any) Healthcare

Notes:
3 days onsite (Tuesday, Wednesday, Friday)