Senior SQL Developer
Institute for Medical Research
- Durham, NC
- $95,000-130,440 per year
- Permanent
- Full-time
- Access VA databases and repositories to programmatically identify research study cohorts and extract research data from patient electronic health records (EHRs)
- Coordinate with VA database administrators to, to add study cohort EHR data to designated VA research databases, and for other general database maintenance activities
- Assess the quality of clinical data sets to identify data limitations and errors; work with study team to resolve coding errors and data discrepancies.
- Promptly respond to time-sensitive data query requests with data summary reports and diagrams to support research study feasibility decisions and/or research proposal development
- Facilitate manipulation of data between different formats (excel, csv, etc.)
- Develop and maintain backend database structures for clinical research study databases
- Design and build relational database structures
- Create and modify tables within existing databases
- Advise on decisions regarding the expansion of or changes to a study database based on best design practices.
- Model data collection requirements to inform backend development plan for research studies
- Elicit and integrate user feedback and testing into database backend structure designs
- Ensure data security including privacy protection, backups, etc.
- Document work related to database and query design using comments, codebooks, and good programming practices
- Produce graphical documentation of work including entity relationship and consort diagrams
- Utilize version control as part of code development and documentation
- Recommend new methods for collection and documentation of data
- Revise and maintain procedural manuals and training materials, as needed
- Provide written, oral, and/or electronic status reports of assigned tasks
- Communicate with collaborators around the country to advise on topics related to data management, data abstraction, and compilation of multiple datasets across sites
- Work with research coordinators to ensure all procedures adhere to HIPAA and IRB compliance
- Correspond with VA technology departments to address/resolve IT needs and problems
- Provide input on project decisions related to timelines, feasibility, and other relevant issues working with team leads to make sure work is completed in timely manner for project deadlines to be met
- Participate in team meetings on a frequent and regular schedule
- Train additional team members, as necessary
- Bachelor's degree in Computer Science, Engineering, Information Systems/Technology, or other relevant field
- At least 5 years of experience as a SQL developer, data analyst, or other relevant work that aligns with the qualifications of this job
- Intimate familiarity with the best practices, methodologies and/or frameworks associated with the following practices:
- Relational database tools, design, and analysis
- ETL development
- Database theory and design
- Principles of data querying
- Minimum of 5 years practical experience with SQL and RDBMSes (preferably Microsoft SQL Server) and at least one general-purpose programming language (e.g., Python, Java, etc.)
- Extensive experience with procedural SQL, stored procedures, triggers, and user defined functions
- Ability to design and implement table structures following principals of normalization
- Ability to write SQL queries and sub-queries to acquire data accurately and efficiently from large datasets with complex table structures
- Analyze new and existing SQL queries for performance improvements
- Experience with data integration, including creating and maintaining ETL processes
- Experience with version control is a plus
- Experience working in healthcare, medical research, heath sciences, or related fields is a plus
- Highly organized, detailed oriented with the ability to manage multiple tasks, changing priorities and deadlines
- Ability to work effectively both independently and as part of a team
- Ability to solve problems, troubleshoot, and quickly and independently learn new skills
- Capacity to communicate both written and orally with an array of research team members
- Salary will be commensurate with abilities and experience.
Phone: (984)250-7012
Email: HumanResources@imr.org
This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.
Equal Opportunity Employer, including disabled persons and veterans.If you want to view the Know Your Rights: Workplace Discrimination is Illegal poster, please choose your language: – – -– –