Senior Data Analyst

Job Category: Data
Job Type: Remote
Compensation: Depends on Experience
W2: W2-Contract Only; Kindly note that applications on a C2C basis will not be considered for this role.

US Work Authorization Requirement:
Candidates must be legally authorized to work in the United States without employer sponsorship. This includes, but is not limited to, U.S. Citizens, Permanent Residents, and other individuals with valid U.S. work authorization.

Job Description: 

We are seeking a highly skilled and motivated Senior Data Analyst / Informatica ETL Developer to join our team. This is a hands-on technical role responsible for designing, developing, and delivering robust ETL frameworks and components within a multi-terabyte Oracle Exadata environment.

The role involves integrating public and private healthcare encounter and enrollment data from New York State (NYS) healthcare plans. Using Informatica tools, you will transform and synthesize data to support the management, evaluation, and analysis of the NYS healthcare system.

Key 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
  • Optimize performance within a large-scale Oracle Exadata environment
  • Collaborate with stakeholders, analysts, and technical teams to support reporting and analytics needs
  • Troubleshoot and resolve ETL and data-related issues

Required Technical Skills:

Strong hands-on experience with the Informatica product suite, including:

  • PowerCenter
  • Test Data Manager
  • Master Data Management (MDM)
  • Metadata Manager
  • Data Quality
  • Additional Skills:
  • Strong experience with Oracle / Oracle Exadata
  • Experience working with large-scale healthcare data (encounter & enrollment data preferred)
  • Strong SQL and performance tuning skills
  • Knowledge of data warehousing concepts and ETL best practices
  • Experience with healthcare domain data (Medicaid/Medicare/NYS preferred)

Preferred Qualifications:

  • Experience working with state healthcare systems or All Payer Databases
  • Strong analytical and problem-solving skills
  • Ability to work independently in a fast-paced environment