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.
Designs develops tests and maintains complex software systems and applications for an organizations mainframe computer systems.
Essential Functions:- 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.
Education Requirement:- Bachelors Degree in Computer Science or relevant field or equivalent experience required.
- Masters Degree or PhD preferred.
Licensure Requirement:(not specified)
Certifications:(not specified)
Skills:- 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.
Experience:- Five years of experience in system or application programming required.
- Two years of experience in hospital information systems preferred.
Physical Requirements: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
Additional Physical Requirements performed but not listed above:(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
Required Experience:
Senior IC