Detailed JD:

Work with business to understand requirements. Work with architects to understand solution and data model. Perform data analysis on large volume of healthcare payer operational data, by writing complex queries. Based on analysis, prepare comprehensive source to target mapping: identify data sources, join conditions, filter conditions and transformation logic to populate in target, as per business requirements / reporting needs / outbound data feed specifications. Support any questions that raise during development and testing. Develop SQL queries to produce ad-hoc reports, per business

Primary skill set:

Data Analysis, SQL, Healthcare Payer: Membership and Claims (facility, professional, dental, vision, pharmacy)

Secondary skill set:

Impala, Hive, Oracle, Toad, Postgres SQL, Redshift, Healthcare Payer: Provider, Care Management, Billing