Senior Data Analyst

Codetech • Eden Prairie, MN

2d

About The Position

Despite the title, the posting describes an Informatica ETL Developer role responsible for designing and delivering ETL frameworks and components in a multi-terabyte Oracle Exadata environment. The environment integrates public and private healthcare encounter and enrollment data from New York State healthcare plans. Using Informatica, the role synthesizes data to support management, evaluation, and analysis of the NYS healthcare system.

The role is accountable for sourcing data from NYS healthcare plans, staging, auditing, cleansing, enriching, and loading data into the NY All Payer Database (APD) reporting structures in Oracle. 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.

Requirements

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

Responsibilities

• Design and deliver ETL frameworks and components in an Oracle Exadata environment.
• Source healthcare data from NYS healthcare plans; stage, audit, cleanse, enrich, and load it into NY All Payer Database (APD) reporting structures in Oracle.
• Synthesize healthcare data to support management, evaluation, and analysis of the NYS healthcare system.

What This Job Offers

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