Business Data Analyst
About The Position
Role: Business Data Analyst Duration: 6-12+ Months Contract Location: Philadelphia, PA - Hybrid Must have Skills - Skill 1 - 10+ Yrs of Exp - Sr BSA (Business/Systems Analysts) Skill 2 - 5 Yrs of Exp - Data Warehouse, SQL, Data Profiling Skill 3 - 5 Yrs of Exp - Mapping Document to be used by Dev and QA team (Detailed level required. Provide Joins, Filters and Ranking (if required) to get UNIQUE records) Skill 4 - 6 Yrs of Exp - Data Warehouse projects (Preferably in Sourcing or Outbound Extracts) Skill 5 - 6 Yrs of Exp - Perform UAT / Business Checkout using SQL Scripts Skill 6 - 5 Yrs Of Exp - Target Mapping, Gap Analysis / Data Profiling, Functional Specifications working with Business Skill 7 - 3 Yrs Of Exp - Data Profiling (Identify all data issues before getting the data to DW) 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) 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 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
Requirements
- 10+ Yrs of Exp - Sr BSA (Business/Systems Analysts)
- 5 Yrs of Exp - Data Warehouse, SQL, Data Profiling
- 5 Yrs of Exp - Mapping Document to be used by Dev and QA team (Detailed level required. Provide Joins, Filters and Ranking (if required) to get UNIQUE records)
- 6 Yrs of Exp - Data Warehouse projects (Preferably in Sourcing or Outbound Extracts)
- 6 Yrs of Exp - Perform UAT / Business Checkout using SQL Scripts
- 5 Yrs Of Exp - Target Mapping, Gap Analysis / Data Profiling, Functional Specifications working with Business
- 3 Yrs Of Exp - Data Profiling (Identify all data issues before getting the data to DW)
- 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 understanding of RDBMS concepts
- Good Communication Skills
- Good Analytical skills
- Strong SQL skills
Responsibilities
- Perform UAT / Business Checkout using SQL Scripts
- 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)
- Present the draft version of Data Model
- Prepared Source to Target Mapping
- Performed Gap Analysis / Data Profiling
- Prepared Functional Specifications working with Business
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Mid Level
Industry
Professional, Scientific, and Technical Services
Education Level
No Education Listed
Number of Employees
11-50 employees
