EDW Analyst

Position Description:

The EDW Analyst is a critical member of the EDW Payer Data Integration team with responsibilities across various operational and development projects. The primary team operation is the monthly loading and certifying of member enrollment and claims data for ingestion into the Payer database. The Payer Data Analyst leverages internal QA dashboards executing preset certification rules to validate key data points identify trend irregularities and perform troubleshooting activities to certify incoming data content. These activities include writing SQL queries and conducting detailed data research and analysis to gain the insight and determine the corrective action. The Payer Data Analyst will also provide data certification for other operational jobs including Payer DataMarts PHM subject area DataMarts Provider data as well as internal and external extracts. On development projects the Payer Data Analyst will gather requirements from product owners to create and execute a test plan that certifies new or revised product functionality. The Payer Data Analyst interacts with a variety of Payer and PHM data assets and needs to be the subject matter expert (SME) to support Adhoc research requests.

Responsibilities: