Business System Analyst

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 Modelling (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 the recent project)


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