/Senior Data Analyst

Senior Data Analyst

Chicagousvia direct
// Job Type
Full Time
// Salary
Not disclosed
// Posted
1 month ago
// Seniority
senior

About the 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 * Δ 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 [contact-form-7 id="ac31dcc" title="Job Apply Form"]

Tech Stack

SQLInformaticaETL

Interested in this job?

Login to Apply

Use our AI to tailor your resume for this Senior Data Analyst position at JPS Tech Solutions LLC.