Sr.Data Analyst(ETL)

Codetech • Eden Prairie, MN

20h • Remote

About The Position

The Sr. Data Analyst will design and deliver ETL frameworks and components in a multi-terabyte Oracle Exadata environment integrating public and private healthcare encounter and enrollment data from New York State healthcare plans. The role uses Informatica to synthesize data for management, evaluation, and analysis of the New York State healthcare system. It is a hands-on technical role involving the Informatica product suite, including PowerCenter, Test Data Manager, Master Data Management, Metadata Manager, and Data Quality. The analyst will source data from healthcare plans, then stage, audit, cleanse, enrich, and load it into the New York All Payer Database (APD) reporting structures in Oracle. The team includes one Project Manager and four Developers.

Requirements

• At least 5 years of experience with Informatica PowerCenter.
• At least 5 years of experience with Oracle and PL/SQL, including strong coding and performance-tuning skills.
• At least 2 years of experience with scripting languages such as Python or Shell.
• At least 2 years of experience in data analysis.
• At least 2 years of healthcare data experience, such as Medicaid, Medicare, Exchange, or commercial payer data.
• Experience with data modeling techniques for data warehouse environments.
• Strong understanding of data warehouse and database design principles.
• Experience with performance tuning and optimization.
• Experience with Informatica Data Quality and Test Data Manager.
• Excellent problem-solving skills, attention to detail, and ability to work independently and collaboratively.
• Strong communication and collaboration skills.

Nice To Haves

• Knowledge of HIPAA regulatory security requirements.
• Experience with 834, 837, and NCPDP transactions.
• Familiarity with Snowflake, Databricks, Azure, or AWS.
• Advanced Oracle experience.

Responsibilities

• Design and deliver ETL frameworks and components in a multi-terabyte Oracle Exadata environment.
• Source, stage, audit, cleanse, enrich, and load healthcare data from New York State healthcare plans into the New York All Payer Database reporting structures.
• Use Informatica to integrate and synthesize encounter and enrollment data for healthcare system management, evaluation, and analysis.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed