What are the responsibilities and job description for the lead Technical Business Analysis position at HCL Global Systems?
Job Details
Business Analysis
Domain Experience Healthcare
Location - Philadelphia, Pennsylvania (Hybrid)
At least 3 years with Data Warehouse, 5 years with SQL and 15 years on a BSA / Technical role
Mandatory Areas
Must have Skills
Skill 1 5 Yrs of Exp Data Warehouse
Skill 2 5 Yrs of Exp SQL Query
Skill 3 5 Yrs of Exp SQL Scripting
Skill 4 5 Yrs of Exp - Data Modeling
Skill 5 5 Yrs of Exp Target Mapping (apping Document to be used by Dev and QA team (Detailed level required. Provide Joins, Filters and Ranking (if required) to get UNIQUE records))
Good To have Skills
Skill 2 Yrs of Exp Data Profiling
Skill 3 Yrs of Exp Gap Analysis
Skill 4 Yrs of Exp - RDBMS
- 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 15 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