Senior Data Analyst

Job Category:
Data
Job Type:
Onsite
Job Location:
Chicago Illinois
Compensation:
Depends on Experience
W2:
W2-Contract Only; Kindly note that applications on a C2C basis will not be considered for this role.
Job Description
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

Apply Online
Your Name \*
Your Phone Number \*
Your Email Address \*
Job id
What is your current U.S. visa or immigration status? \*
SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa
Where are you currently located at? \*
W2 or C2C \*
SelectW2C2C
How many years of total experience do you have? \*
How many years of relevant experience do you have? \*
Do you require H1B sponsorship? \*
YesNo
Do you require sponsorship? \*
NoYes – H-1B transferYes – Green Card sponsorshipYes – Both H-1B transfer and Green Card sponsorship
Upload Resume \*
Δ
Facebook X LinkedIn WhatsApp