Technical Business Analyst
Independence Blue Cross
Contract Philadelphia, Pennsylvania, United States Posted 2 weeks ago
About Position
Technical Business Analyst (Contract)
$75.00 / Hourly
Philadelphia, Pennsylvania, United States
Technical Business Analyst
Contract Philadelphia, Pennsylvania, United States Posted 2 weeks ago
Skills
•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 skillsDescription
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(SCD) - All types (1 year in recent project)
• 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
By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.
