Hybrid Programmer Analyst, Temporary Programmer Analyst, Temporary with verification
The Johns Hopkins University · Baltimore, MD (Remote) · nan, United States Of America · Hybrid
About the job
Job Req ID: 115066
Programmer Analyst, Temporary
The Carey Business School's Office of Institutional Data and Analytics (OIDA) is seeking a technical and highly detailed individual for the position of Programmer Analyst, Temporary. Under the general guidance of the Institutional Research and Analytics Manager, this position serves as a critical interface between OIDA and the Office of Software and Reporting Services. The person in this role will understand and manage technology integration and data management. They will play a critical role in ongoing efforts to build and maintain OIDA's internal data warehouse and multiple interactive dashboards, including data preparation and reporting solutions. Additionally, the role provides ongoing technical support for OIDA, offering a unique opportunity for ingenuity in a dynamic and supportive team environment.
The Programmer Analyst will be the subject matter technology expert for OIDA. The incumbent will primarily be responsible for developing, coordinating, and managing the daily activities of the OIDA database applications development operation, extracting data from the Student Information System to gather and compile large datasets, developing internal databases, automating reports, and preparing dashboards for reporting. The person in this role will collaborate in a dynamic team environment with the data management and technical support administrator, senior institutional research analysts, and manager.
Specific Duties & Responsibilities
Data Extraction, Transformation Reporting & Data Visualization (60%)
- Contributes to OIDA’s internal ETL (Extract Transform Load) design, evaluation, selection, implementation, and support of database solutions. Works closely with the OIDA team on ETL development and BI reporting. Troubleshoots problems regarding the databases and applications and provides technical support. Identifies and analyzes queries and stored procedures for optimization.
- Develop/change data input, files/database structures, data transformation, algorithms, and data output using appropriate computer language/tools to provide technical solutions for moderately complex application development tasks.
- Ensures that the use of business intelligence applications enhances business decision-making capabilities.
- Creates, upgrades, and maintains dashboards of data based on leadership needs and ongoing/common data requests for the school.
- Document code and associated processes by adhering to development methodologies, adding code comments and appropriate documentation to various knowledge-based system(s) to simplify code maintenance and improve support.
- Analyze complex reporting needs and develop complex reports.
- Create and document moderately complex test scenarios using the appropriate testing tools to validate and verify application functionality.
- Test all changes using the appropriate moderately complex test scenarios to ensure that all delivered solutions work as expected and errors are handled meaningfully.
- Author and maintain documentation by writing audience-appropriate materials to serve as technical and end-user references.
- Assist data management and technical support administrator with creating easy-to-follow training guides to support non-analytical client utilization.
- Assist data management and technical support administrator with conducting and facilitating training.
- Other duties as assigned.
- Proven ability to write and analyze SQL Query.
- Proven ability in database development, management, and access software, including Microsoft SQL Server and other SQL tools.
- Proven abilities implementing and customizing/extending a vendor-provided solution.
- Proven ability using SSRS and/or other reporting tools.
- Proven ability to develop dashboards with Power BI, Tableau, or similar tools.
- Ability using a variety of data manipulation tools.
- Ability to adapt to changes in technology and environment quickly and easily. Must be able to serve as a change agent in promoting change among colleagues within the organization and its user communities.
- Excellent verbal/written communication skills and ability to interact effectively with functional and technical communities.
- Skilled in managing multiple projects and working independently.
- Ability to effectively communicate technical information to non-technical staff.
- Strong ability to work within a team and communicate effectively via all mediums.
- Ability to work effectively with other people.
- Ability to be creative and exercise initiative.
- Excellent interpersonal, written, and verbal skills.
- Must be able to stay abreast of technologies relevant to daily duties through formal training programs and/or independent study and explore new technologies that would benefit the organization or its initiatives.
- Bachelor's Degree.
- One-year related experience.
- Additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.
- Two years' related experience.
- Extensive Experience using SQL programming and related databases.
- Experience using Power BI.
- Experience in computer science, information systems, engineering, or related fields.
- Experience extracting and merging data from multiple platforms; experience with creating a Data Warehouse, including the steps involved in the “lifecycle” of its development.
- Experience supporting clients in complex systems with multiple project partners.
Job Posting Title (Working Title): Programmer Analyst, Temporary
Role/Level/Range: ATP/03/PC
Starting Salary Range: $27.58 - $48.41 HRLY ($19,760 targeted; Commensurate with experience)
Employee group: Casual / On Call
Schedule: Monday-Friday 8:30-5:00
Exempt Status: Exempt
Location: Remote
Department name: Institutional Data and Analytics
Personnel area: Carey Business School
Total Rewards
The referenced base salary range represents the low and high end of Johns Hopkins University’s salary range for this position. Not all candidates will be eligible for the upper end of the salary range. Exact salary will ultimately depend on multiple factors, which may include the successful candidate's geographic location, skills, work experience, market conditions, education/training and other qualifications. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/.
Education and Experience Equivalency
Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines: JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. 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.
Applicants Completing Studies
Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.
Background Checks
The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.
Diversity and Inclusion
The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.
Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
EEO is the Law
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf
Accommodation Information
If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at [email protected]. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit https://accessibility.jhu.edu/.
Vaccine Requirements
Johns Hopkins University strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine. The COVID-19 vaccine does not apply to positions located in the State of Florida. We still require all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. This change does not apply to the School of Medicine (SOM). SOM hires must be fully vaccinated with an FDA COVID-19 vaccination and provide proof of vaccination status. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.
The following additional provisions may apply, depending upon campus. Your recruiter will advise accordingly.
The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.
Remote
