SQL Datawarehouse Analyst

Overview

Hybrid
$117,750 - $123,500
Full Time
50% Travel

Skills

SQL
Data
Analyst
ETL
Health
Claims

Job Details

SQL Datawarehouse Analyst

Location: 1901 Market Street Philadelphia PA

Hybrid T/W/Th

8-5 EST, 37.5 once they are FTE

6 months+

Job Summary:

This position is ideal for a SQL Data Analyst with strong SQL skills and deep understanding of data warehousing concepts. The SQL Data Analyst role on the Enterprise Integration Management Data Warehouse team requires experience in creating Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents and further discussion with data modelers for the necessary table designs.

Must Haves:

  • Have have at least 6 years of experience
  • Must have strong Data Mapping skills
  • Must have strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team.
  • Must have experience working in a Datawarehouse environment
  • Must have Healthcare Claims Data knowledge
  • Must have experience creating complex SQL queries, aggregate functions- specifically Where and Having Clauses before and after aggregation
  • Ongoing SQL analytics in operational systems

Skill/Experience/Education

  • Highly prefer candidates with knowledge of Healthcare Claims, Client Setup and Premium Billing
  • Deep understanding of Business Analysis concepts and successful application of standard methodologies
  • Strong Data Profiling and Data Analysis skills
  • Expert SQL analysis and SQL development skills
  • Strong Data Mapping and Functional requirements documentation skills
  • Data warehousing knowledge and understanding of standards and concepts
  • Strong verbal, writing and active listening skills.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.