Application Specialist
Indexed description
This position is a hybrid role working out of our Carmel, IN office.
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.
- Strong analytical, problem-solving, interpersonal, and organizational skills, with the ability to own technical work from requirements through delivery.
- Proficiency developing, reviewing, testing, and debugging applications written in Python, Java, CSS, and HTML, including AI-assisted and manually generated code.
- Working knowledge of relational database design, data modeling, data integrity principles, workflow automation, and performance optimization for data-driven systems.
- Experience with ETL/data integration concepts, API troubleshooting, data mapping, data validation, and ingestion of structured or semi-structured data files from multiple sources.
- Ability to evaluate, develop, integrate, and validate AI-enabled tools or automation within data management workflows while maintaining appropriate human review, data quality, and documentation standards.
- Strong communication and collaboration skills, including the ability to work effectively with a database administrator, build team, and cross-functional stakeholders; well organized work habits with attention to detail and a commitment to quality improvements.
- Minimum Education (or Substitute experience) required:
- Associate degree in MIS, CIS, Computer Science, or related field; equivalent professional experience may be considered.
- Minimum Experience required:
- 3-5 years of software development experience with Python, Java, CSS, and HTML required.
- 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. Experience working with FDA data sources, categorization data, client APIs, client or vendor data files, data build processes, or production support workflows is also preferred.
We value Integrity, Respect, Responsibility, Teamwork, and Creativity. Our offices in South San Francisco and Indianapolis have been awarded with Top Workplaces honors by The Bay Area News Group and the Indy Star, respectively, including the most recent honor awarded to our Indianapolis office since 2016 (the Top Workplaces honors are based solely on the results of an employee feedback survey by a leading research firm that specializes in organizational health and workplace improvement).
We are an Equal Employment/Affirmative Action employer. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state, or local law.
If you need a reasonable accommodation for any part of the employment process, please contact us by email at [email protected] and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.
For more information about our commitment to equal employment opportunity, please visit EEO is the Law , EEO is the Law Supplement , Pay Transparency , and FDB EEO/AA Statement .
In accordance with applicable law, Hearst is required to include a reasonable estimate of the compensation for this role if hired in Carmel, IN. The reasonable estimate, if hired in Carmel, is $85,000 - $100,000. Please note this information is specific to those hired in this location. If this role is open to candidates outside of this location, the compensation range would be aligned to that specific location. A final decision on the successful candidate's starting compensation will be based on a number of permissible, non-discriminatory factors, including but not limited to skills and experience, training, certifications, and education.
This role is also eligible for medical, dental, vision, life, and disability insurance; 401(k) retirement plan; flexible spending account; paid holidays; paid time off; employee assistance program; and other company benefits.
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search