What are the responsibilities and job description for the ANALYST PROGRAMMER II position at Duke University?
Occupational Summary
Analyze specific phases of Duke University administrative operations, procedures and functions to determine feasibility of adapting manual office procedures to computer applications; develop, modify and maintain computer programs to effect implementation, revisions and continued operation of computer application systems.
Work Performed
- Serve as the lead analyst in the production of reports in Tableau for Department utilizing a variety of data sources from Duke University, Duke Health Integrated Practice (DHIP), and DUHS. Reports are robust and include, but are not limited to, budget, finance, research, clinical research, personnel, effort, funding, space, conference attendance, and clinic productivity. Reconcile the bottom line of reports to independent data sources prior to release of reports.
- Serve as the lead analyst in the development of new reports and dashboards using Tableau, including both financial and non-financial data. Gain an understanding on the purpose of the reports and offer advice on the best and most meaningful presentation of the data. Determine how best to gather data not readily available in extracts or tools to map to new reports. Develop or program formulas where needed. Test new reports prior to release. Develop instructional and reference materials for users. Train users on new applications and reports.
- Assist in the design and maintenance of the department’s data and database. Understand source, purpose, and use of data elements in order to identify requirements and needs. Help determine the optimal way to collect, store, retrieve, present and analyze data from a variety of sources.
- Write or rewrite program code and/or reorganize existing SQL code to be more efficient, easier to maintain, and able to accommodate changing business needs.\
- Oversee server security and administration for Pediatrics; including Windows server, SQL server database, and front-end view to SQL server database.
- Document all processes and the flow of source in the reports. Documentation is in both written and process diagrams forms. Keep documentation or ‘cookbook” up-to-date.
- Perform ad hoc queries and statistical reporting of data mined from decision support database upon request of Department leadership.
Required Qualifications at this Level
Education/Training
Work requires a Bachelor's degree in mathematics or computer science or a computer-related field or equivalent coursework or technical training.
Experience
Work requires two years applications programming experience with some responsibility for systems design and supervision or project coordination. OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR
EXPERIENCE
Preferred Job Skills
- Strong analytical and critical thinking skills to identify problems and develop solutions
- Proven ability to research, gather and organize information to produce concise reports
- SQL programming skills
- Tableau proficiency a plus
- Knowledge of Ruby on Rails helpful
Minimum Qualifications
Education
Work requires a Bachelor's degree in mathematics or computer science or a computer-related field or equivalent coursework or technical training.
Experience
Work requires two years applications programming experience with some OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE responsibility for systems design and supervision or project coordination.
Duke 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 essentialjob 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.
