Business Data Analyst

Must have Skills:

• Very Strong SQL Coding (5+ years)
• Perform Data Profiling / Data Mining / Data Structures / Data Modeling (5+ years)
• Prepared Source to Target Mapping / Mapping Documents / Gap Analysis (5+ years)
• Create FRD, BRD / Functional specifications (8+ years)
• Slowly changing Dimension - All types (1 year in 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 Analytical and Communication Skills.
• Prepared Source to Target Mapping.
• Performed Gap Analysis / Data Profiling.
• Prepared Functional Specifications working with Business.
• Strong SQL skills.