Skip to main content

This job has expired

DATABASE ANALYST II

Employer
Duke University
Location
Durham, NC

View more

Faculty Jobs
Arts & Humanities
Administrative Jobs
Technology, Database Administration
Employment Type
Full Time
Institution Type
Four-Year Institution

Job Details

Auto req ID
109748BR
Duke Entity
MEDICAL CENTER
Job Code
2293 DATABASE ANALYST II
Job Description
Informatics
 
Database Analyst II (DBA II)
 
Occupational Summary
Coordinate and perform a variety of technical and creative duties for data analytics, data modeling and data management using an array of software applications, framework, techniques, and tools to design and develop and test custom solutions, reports and applications and provide support to existing applications for the Duke Cancer Institute (DCI).
Reporting 
This position reports to the DCI IT Application & Database Development Manager and to the Associate Director of the Clinical Trials Office & Business Development
Responsibilities and Expectations
OnCore and Complion – 50% EffortExtensive reporting and data extraction using Forte’s OnCore clinical trial management system (CTMS)Complion - Responsible for providing support, troubleshooting, managing upgrades, and features, providing data reporting and customer supportDCI Applications – 10% EffortAdministration and management of applications on DCI’s application team.  Primary applications include Metric and Extraview.  Responsible for data analysis, data interpretation using statistical techniques to design, develop and test custom solutions, reports and applications and integrate with web applicationsApplication Development / Data Management – 30% EffortFoster and build relationships with clinical research teams, leadership, IT/development to develop custom solutionsIdentify, analyze, and interpret trends or patterns in complex data setsAct as the lead person for data management by creating dashboards and metricsAct as departmental liaison to other departments as it relates to data analyticsEvaluate new data analytics tools for scalability, industry approval and consistencyResearch information/best practices that enhance the significance of the dashboard. Work to keep the dashboard up to date enforcing standards and available technologiesCompliance – 10% EffortAdhere to Duke Security and Standards as related to HIPPA and provide training and assistance on issues regarding data analysis and management Attend staff meetings, conferences and trainings as assignedAnd other work as assigned
Required Skills
·         Experience in design, development, and testing of data analytical applications, dashboards, enhanced reporting capabilities using Jasper Reports, Tableau, Business Objects, Crystal Reports and business intelligence processes and technologies and integration with web technologies
·         Advanced skills in writing SQL queries in multiple databases – SQL Server, MySQL, Oracle, and strong analytical and problem-solving skills
·         Advanced skills in Excel, PowerPoint, Microsoft Office and experience with VBA and macros preferred
·         Must have a strong mathematical and statistical skill set to maintain accurate data reporting and analysis
·         Effective communication skills - interpersonal, presentation and written
·         Ability to work independently as well as a part of a team in a fast-paced environment
·         Ability to effectively communicate and explain reports, models, and dashboards to various levels throughout the organization, from front line management up to C-level executives
·         Strong organizational skills and high attention to detail to meet deadlines in an environment of constantly changing priorities
·         Problem Solving, Analytical and Conceptual thinking - using logic and reason, creative and strategic thinking
·         Flexibility and adaptability to changing prioritiesBasic understanding of underlying technologies and architecture that support dashboards and data analyticsFamiliarity with code versioning software:  Git, SVN, CVS Basic understanding and experience with deployment to web and modern web security best practices.Ability to write good test cases and automated unit tests for all code.Ability to support existing applications like Extraview, Metric, and Redcap according to given requirements.Ability to document the code and create and maintain SOPsAbility to communicate effectively with peers and train team members and end users.Ability to complete tasks as assigned with close oversightThe above statements describe the general nature and level of work being performed. This is not intended to be an exhaustive list of all responsibilities and duties required.  Employees may be directed to perform job-related tasks other than those specifically presented in this description.
The intent of this job description is to be representative of the level and the types of duties and responsibilities that will be required of this position and shall not be construed as a declaration of the total specific duties and responsibilities. 
PreferencesExperience with Complion (or other eRegulatory solutions for clinical research)Experience with OnCore (or other Clinical Trial Management Systems – CTMS)Experience with Jasper Reports, Tableau, Business Objects, Crystal Reports or similar tools and business intelligence (BI) software tools.  Experience with web development tools and programming or scripting tools like Python, RubyExperience working in multi Operating System environments - Windows and Linux4 years of experience providing training and/or education  Qualifications Required At This Level
Education/Training
Work requires a bachelor's degree in mathematics, computer science, or a computer-related field or the equivalent coursework or technical training.
Experience
Work requires 4 years of progressive programming or database administration experience to include design, implementation, tuning, backup, recovery, modification and reorganization of relational databases for a complex computer network. 
Or an equivalent combination of relevant education and/or experience.
Location
Durham
Requisition Number
401555752
Position Title
DATABASE ANALYST II
Shift
First/Day
Job Family Level
70
Full Time / Part Time
FULL TIME
Regular / Temporary
Regular
Department Name
DCI OFFICE OF RESEARCH SUPPORT
Minimum Qualifications
Duke University is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.

Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.


Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.

Education
Work requires a Bachelor's degree in mathematics, computer science, or a computer-related field.

Experience
Work requires 4 years of progressive programming or database administration experience to include design, implementation, tuning, backup, recovery, modification and reorganization of relational databases for a complex computer network.
OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE
 

Organization

Read our Diversity Profile History

Duke University was created in 1924 by James Buchanan Duke as a memorial to his father, Washington Duke. The Dukes, a Durham family that built a worldwide financial empire in the manufacture of tobacco products and developed electricity production in the Carolinas, long had been interested in Trinity College. Trinity traced its roots to 1838 in nearby Randolph County when local Methodist and Quaker communities opened Union Institute. The school, then named Trinity College, moved to Durham in 1892, where Benjamin Newton Duke served as a primary benefactor and link with the Duke family until his death in 1929. In December 1924, the provisions of indenture by Benjamin’s brother, James B. Duke, created the family philanthropic foundation, The Duke Endowment, which provided for the expansion of Trinity College into Duke University.Duke Campus

As a result of the Duke gift, Trinity underwent both physical and academic expansion. The original Durham campus became known as East Campus when it was rebuilt in stately Georgian architecture. West Campus, Gothic in style and dominated by the soaring 210-foot tower of Duke Chapel, opened in 1930. East Campus served as home of the Woman's College of Duke University until 1972, when the men's and women's undergraduate colleges merged. Both men and women undergraduates now enroll in either the Trinity College of Arts & Sciences or the Pratt School of Engineering. In 1995, East Campus became the home for all first-year students.

Duke maintains a historic affiliation with the United Methodist Church.

Home of the Blue Devils, Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.

Mission Statement

Duke Science"James B. Duke's founding Indenture of Duke University directed the members of the University to 'provide real leadership in the educational world' by choosing individuals of 'outstanding character, ability, and vision' to serve as its officers, trustees and faculty; by carefully selecting students of 'character, determination and application;' and by pursuing those areas of teaching and scholarship that would 'most help to develop our resources, increase our wisdom, and promote human happiness.'

“To these ends, the mission of Duke University is to provide a superior liberal education to undergraduate students, attending not only to their intellectual growth but also to their development as adults committed to high ethical standards and full participation as leaders in their communities; to prepare future members of the learned professions for lives of skilled and ethical service by providing excellent graduate and professional education; to advance the frontiers of knowledge and contribute boldly to the international community of scholarship; to promote an intellectual environment built on a commitment to free and open inquiry; to help those who suffer, cure disease, and promote health, through sophisticated medical research and thoughtful patient care; to provide wide ranging educational opportunities, on and beyond our campuses, for traditional students, active professionals and life-long learners using the power of information technologies; and to promote a deep appreciation for the range of human difference and potential, a sense of the obligations and rewards of citizenship, and a commitment to learning, freedom and truth.Duke Meeting

 “By pursuing these objectives with vision and integrity, Duke University seeks to engage the mind, elevate the spirit, and stimulate the best effort of all who are associated with the University; to contribute in diverse ways to the local community, the state, the nation and the world; and to attain and maintain a place of real leadership in all that we do.”

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert