Improve database schemas using Oracle, SQL Server, and Unix Shell Scripting. Monitor data refreshes and enhance data architecture.
Requirements
- strong SQL and scripting skills
- experience with OMOP/PCORnet
- Oracle
- SQL Server
- Unix Shell Scripting
- Working knowledge of relevant programming languages and environments.
- 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.
Responsibilities
- Design and optimize pipelines for OMOP and PCORnet models
- lead complex data integration
- ensure compliance with best practices and audit standards
- Improve database schemas using Oracle, SQL Server, and Unix Shell Scripting
- Monitor data refreshes
- enhance data architecture
- Develops and maintains complex software programs and applications.
Other
- Support users with documentation and training.
- 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.
