Description

You will own the design, development, and maintenance of data pipelines for healthcare reporting.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica tools.
• Source data from NYS healthcare plans and external systems.
• Perform data staging, auditing, cleansing, enrichment, and transformation.
• Load processed data into the NY All Payer Database (APD) reporting structures in Oracle.
• Ensure data quality, integrity, and compliance with regulatory standards.

Required Skills

• 5+ years of experience in a data analysis or engineering role.
• Strong hands-on experience with Informatica PowerCenter.
• Proficiency in Oracle, specifically working with Oracle Exadata environments.
• Experience with ETL processes and data warehousing concepts.
• Demonstrated knowledge of Data Quality and Master Data Management (MDM).
• Strong SQL skills with performance tuning capabilities.
• Experience working with large-scale healthcare data (encounter & enrollment data preferred).
• Familiarity with healthcare domain data (Medicaid/Medicare/NYS preferred).

Preferred Skills

• Experience working with state healthcare systems or All Payer Databases.

Key Skills

Education

Any Gradute