Business System Analyst in Philadelphia, PA

  • Title: Business System Analyst
  • Code: RCI-16735-1
  • RequirementID: 123049
  • Location: Philadelphia, PA 19103
  • Posted Date: 12/02/2024
  • Duration: 2-3 Months
  • Apply Create Job Alert
Talk to our recruitment team

  Job Description

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)

 

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


About Rangam:

Rangam Consultants is a minority, women-owned, disability workforce solutions global organization. We specialize in attracting and retaining talent globally for rewarding careers in IT, Engineering, Scientific, Clinical, Healthcare, Administrative, Finance, Business Management, and many more, while integrating veterans and individuals with disabilities into the workforce. Indeed, we connect career aspirants to relevant job opportunities, whether in the USA, UK, India, or Ireland. Additionally, we offer Location Independent jobs and contract positions across different verticals and industries.
Rangam strives to put job seekers first, providing them with free access to search for jobs, post resumes, and research companies. Every day, we connect millions of people to new opportunities.

Apply Create Job Alert