Location: East Baltimore Campus – Bloomberg School of Public Health
The Johns Hopkins Center for Population Health IT (CPHIT) and the Johns Hopkins ACG® research and development team, is seeking a motivated, independent individual with experience in database management and data analysis to join our team as a Database Programmer Analyst.
Specific duties & responsibilities:
The analyst will provide support to the team through database development, administration and analytics. This may include developing analytic data sets for specific research projects, and overseeing database development including infrastructure and architectural components. The programmer analyst will assist in maintaining current database environments including multiple SQL databases (MS-SQL and MySQL).
Analyst will work closely with both CPHIT and ACG teams and their work related to the application of health IT and electronic data sources to population health. CPHIT collaborates closely with other departments at the Schools of Public Health, Medicine and Nursing on the Medical campus, as well as the Department of Computer Science on JHUs Arts & Science/Engineering campus. CPHIT also collaborates closely with the Johns Hopkins Health Systems and several leading integrated delivery systems and government health agencies. See: http://www.jhsph.edu/cphit
- Provide database support in SQL or other relational databases
- Assist in programming and developing analytic datasets with researchers
- Develop reports and conduct data analysis with researchers
- Assist in managing data security and privacy protocols
- Other IT duties as assigned
Minimum qualifications (mandatory):
Bachelor's degree, preferably in math, engineering, statistics, computer science or other relevant.
One year related experience. Significant undergraduate programming coursework or independent project can be considered as related experience.
Additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.
- Knowledge of SQL or other relational databases (MS-SQL and/or MySQL)
- Experience with database-level analysis and advanced report creation
- Basic knowledge of spatial analysis and experience with GIS databases
- Experience programming in a higher level language (e.g., Python, Perl, Java, PHP, C++)
- Experience with data cleaning and manipulation in a statistical package (e.g., R, SAS, STATA)
- Experience with EHR and/or insurance claims databases
JHU Equivalency Formula:
18 graduate degree credits may substitute for one year of experience. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130... years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Baltimore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.