Prizm MDMS Developer — AI, ETL & Data Workflows

Hearst Health; Indianapolis (IN); On-site; USD 85,000 - 100,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) retirement plan

Flexible spending account

Paid holidays

Paid time off

Employee assistance program

Job summary

Hearst Health is seeking an FDB Prizm Application Specialist (Developer) to design, develop, and improve the Prizm Medical Device Database and MDMS. You will automate data workflows, manage ETL pipelines, and implement AI-enabled tools to enhance data quality and throughput, collaborating with cross-functional teams in Carmel, IN.

The role requires 3-5 years of software development with Python, Java, HTML, and CSS, and entails hybrid work from the Carmel, IN office.

Qualifications

• Associate degree in MIS, CIS, Computer Science, or related field; equivalent professional experience may be considered.
• 3-5 years of software development experience with Python, Java, CSS, and HTML.
• Preferred experience developing database-backed web applications, data management systems, ETL/data integration pipelines, Python automation workflows, API integrations, and AI-enabled tools or integrations, including Cline, Cursor, or similar platforms, that improve system capabilities, data output, and data quality.

Responsibilities

• Assist in the design, development, maintenance, and continuous improvement of the Prizm Medical Device Database.
• Own and implement the Medical Device Data Management System (MDMS), including scalable database and UI solutions that support web applications and data-driven workflows.
• Leverage Python to automate data workflows, create and maintain ETL and integration pipelines, validate incoming medical device data, and enhance back-end systems linked to MDMS front-end interfaces.
• Manage ETL processes that ingest, transform, validate, and load medical device data from various internal and external sources, including FDA data sources, categorization sources, client APIs, and client or vendor data files.
• Implement and refine MDMS user-facing features using HTML, CSS, Java, and templating engines to support efficient workflows and clear data presentation.
• Use modern AI-assisted development tools, such as Cline and Cursor, to improve productivity, code quality, documentation, and testing while reviewing and validating AI-generated code before release.
• Develop, evaluate, and integrate AI-enabled tools, validation routines, and workflow automations into the MDMS and supporting data pipelines to enhance system capabilities, increase data output, and improve the quality, consistency, and validation of medical device data.
• Analyze complex medical device datasets to identify trends, data integrity issues, normalization needs, and opportunities for database optimization or schema redesign.
• Partner with the Prizm database administrator on database-related planning, schema and data model considerations, query optimization, performance monitoring, deployment coordination, and production support activities.
• Develop and maintain comprehensive documentation of data models, architecture, code, workflows, release/change processes, work instructions, and training materials for cross-functional teams.
• Monitor and troubleshoot MDMS and database performance, implementing indexes, partitioning, query tuning, and other optimization techniques to ensure availability, reliability, and responsiveness.
• Ensure ETLs function properly and on a scheduled cadence and frequency.
• Troubleshoot API, integration, ETL, and data build issues, including APIs used in build processes, and assist the build team in diagnosing and resolving Prizm-related issues throughout build, QA, and release workflows.
• Collaborate with Quality Management, clinical/content, product, technology, database administration, and build teams to translate business and data requirements into reliable MDMS enhancements; perform other duties as assigned.

Skills

Python

Java

HTML

CSS

AI-assisted development

SQL

Education

Associate degree in MIS, CIS, Computer Science, or related field

Tools

Cline

Cursor

APIs

ETL pipelines

Job description

Hearst Health is seeking an FDB Prizm Application Specialist (Developer) to design, develop, and improve the Prizm Medical Device Database and MDMS. You will automate data workflows, manage ETL pipelines, and implement AI-enabled tools to enhance data quality and throughput, collaborating with cross-functional teams in Carmel, IN.

The role requires 3-5 years of software development with Python, Java, HTML, and CSS, and entails hybrid work from the Carmel, IN office.