IS Senior Systems Programmer - IT Research and Innovation

Serve as an expert on data transformation and ETL processes in the research data warehouse. Design and optimize pipelines for OMOP and PCORnet models, lead complex data integration, and ensure compliance with best practices and audit standards. Support users with documentation and training. Improve database schemas using Oracle, SQL Server, and Unix Shell Scripting. Monitor data refreshes and enhance data architecture. Requires 5+ years in ETL, strong SQL and scripting skills, and experience with OMOP/PCORnet. Healthcare data experience and scalable ETL design are preferred.

• Develops and maintains complex software programs and applications.
• Designs and implements system enhancements to improve performance and reliability. Leads application and system design discussion and creation for presentation and review.
• Provides technical support and troubleshooting for system issues.
• Collaborates with other IT professionals to integrate new systems with existing infrastructure.
• Conducts research and evaluates emerging technologies to determine their potential impact on the organization.
• Documents system architecture and processes for future reference and training purposes.
• Provides mentoring and support to less experienced programmers.

• Bachelor's Degree in Computer Science or relevant field, or equivalent experience, required.
• Master's Degree or PhD, preferred.

(not specified)

(not specified)

• Ability to participate in an effective mentoring relationship utilizing the appropriate methods.
• Exceptional interpersonal, presentation, customer service, and communication skills required to interact effectively with all hospital staff, medical staff, and external contacts.
• Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems.
• Ability to complete tasks with high levels of precision and identify, collect, and analyze data.
• Knowledge of effective project management strategies and tactics, with the ability to plan, organize, monitor, and control projects.
• Ability to produce software products or systems in line with product requirements.
• Knowledge of technical troubleshooting approaches, tools, and techniques and the ability to anticipate, recognize, and resolve technical issues. Working knowledge of relevant programming languages and environments.
• Ability to write technical documents such as manuals, reports, guidelines or documents on standards, processes, and applications.
• Knowledge regarding the Software Development Life Cycle (SDLC) and the ability to employ a structured methodology is crucial for successful delivery and management of software products.

• Five years of experience in system or application programming, required.
• Two years of experience in hospital information systems, preferred.

OCCASIONALLY: Bend/twist, Climb stairs/ladder, Flexing/extending of neck, Lifting / Carrying: 0-10 lbs, Pushing / Pulling: 0-25 lbs, Reaching above shoulder, Squat/kneel, Standing, Walking

FREQUENTLY: (none specified)

CONTINUOUSLY: Audible speech, Color vision, Computer skills, Decision Making, Depth perception, Hand use: grasping, gripping, turning, Hearing acuity, Interpreting Data, Peripheral vision, Problem solving, Repetitive hand/arm use, Seeing - Far/near, Sitting

(not specified)

"The above list of duties is intended to describe the general nature and level of work performed by individuals assigned to this classification. It is not to be construed as an exhaustive list of duties performed by the individuals so classified, nor is it intended to limit or modify the right of any supervisor to assign, direct, and control the work of employees under their supervision. EOE M/F/Disability/Vet"