This position is responsible for design, development, implementation and maintenance of reports, scorecards, dashboards and analytic tools to represent various university operational, administrative and academic data to a variety of departmental, divisional, and central consumers including analysts, managers and senior leaders.
Responsible for the creation, implementation, maintenance, performance, production support and documentation of various departmental and enterprise-wide application systems. This includes but is not limited to the installation, modification, and testing of new and/or upgraded applications (packages or home grown), operating systems, file structures, hardware, communication devices, and productivity tools. Applies analysis techniques and procedures to gather and then translate business requirements into functional/technical specifications and designs. Using functional specifications and designs, produces all or part of the deliverables. Maintains databases and application system code.
Responsible for full life cycle of medium to large sized complex projects; strong technical skills; strong ability to understand complex business processes. Develops solutions based on extensive technical knowledge, skills and experience; influences client towards innovative/integrated solutions.
Responsible for the design, development, testing, implementation and maintenance of reporting solutions for university divisions, central academic and administrative leadership.
Lead semantic design through SQL development and BI tools to refine presentation of data to meet reporting needs.
Use Agile approach to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing and reviewing the results.
Collaborate with data warehouse engineers to drive technical design of data warehouses and data marts; and to adapt the data warehouse architecture and assets to meet evolving business requirements.
Complete and maintain professional documentation for projects and deliverables.
Responsible for unit, integration, stress/load testing of reports and dashboards to ensure functional and performance requirements are met.
Work with business and IT management to understand and prioritize data and information needs, including the enrichment of data for: classifications and roll-ups to support analytics; building expressions and calculations; working with stewards to clearly define and document definitions and metadata.
Solves complex technical problems related to dashboard and report design, BI tools and collaborating with engineers on issues relating to data architecture and database/data warehouse/data mart design.
Ensure documentation of requirements, design, testing and user guides meets departmental and professional standards.
Working with data warehousing team to develop data warehouses and data marts as needed.
Coordinates coaching and training other developers on business intelligence tools, reporting and analytic best practices and data visualization techniques.
Make use of data, statistical and quantitative analysis, explanatory and predictive modeling and fact-based management to drive decision making and help customers develop new insights and understanding of performance-based data.
Work with vendors to resolve issues, as needed.
The responsibilities listed below are typical examples of the work performed by this position. Not all duties assigned to this position are included, nor is it expected that everyone in this position will be assigned every job responsibility.
ANALYSIS AND REQUIREMENTS GATHERING
Define complex business/clinical/education problems by meeting with clients to observe and understand current processes and the issues related to those processes. Provide written documentation of findings to share with the client and other IT colleagues.
Gather complex system requirements by meeting with clients and researching existing technology to understand the business requirements and possible solutions for new applications.
DESIGN AND DEVELOPMENT
Develop detailed tasks and project plans by analyzing project scope and milestones for complex projects in order to ensure product is delivered in a timely fashion according to software lifecycle standards.
Write functional/technical specifications from the complex system requirements, putting them into functional and technical descriptions for use by programmers and business analysts to develop technical solutions.
Develop/change data input, files/database structures, data transformation, algorithms, and data output by using appropriate computer language/tools to provide technical solutions for complex application development tasks.
Document code and associated processes by adhering to development methodologies, adding code comments and appropriate documentation to various knowledge-base system(s) to simplify code maintenance and to improve support.
Provide monitoring and guidance in application design and development to more junior staff.
Provide thought leadership in designing and developing innovative integrated solutions.
TESTING AND DOCUMENTATION
Create and document complex test scenarios using the appropriate testing tools to validate and verify application functionality.
Test all changes by using the appropriate complex test scenarios to ensure all delivered solutions work as expected and errors are handling in a meaningful way.
Author and maintain documentation by writing audience-appropriate materials to serve as technical and/or end-user references.
Mentor junior staff in testing tools and technologies by reviewing their work.
IMPLEMENTATION AND MAINTENANCE
Implement changes by adhering to the change management policies and procedures for any given project to communicate to all parties the nature, significance, and risk factors of the solution.
Monitor changes and resolve complex problems by responding as they occur, by reviewing all processing and output of the newly implemented solution, and by proactively ensuring the solution works successfully in order to satisfy the customer requirements and to provide a smooth transition to the new solution.
Provide support by investigating and resolving issues, including complex issues to ensure prompt, effective service.
Describe the specific devices, software, projects for which the position is responsible:
Understand student and faculty lifecycles and corresponding applications and systems.
Leverage knowledge of applications, functional processes and existing reporting environments/s to rationalize and help define data warehouse and reporting strategy, particularly as application portfolio evolves.
Build out a semantic infrastructure for ongoing expansion, improvement and reuse, leveraging consolidated data via automated ETL processes.
Perform entire development lifecycle requirement, analysis, design, build, test, deploy and support analytic applications, tools and components using a variety of presentational tools, data discovery, analytic and statistical packages.
Aids in design, architecture and implementation of a front-end reporting and analytics library.
Describe scale/size of area, project and/or system supported:
Scale of project will vary from targeted, power user initiatives, divisional reports with 20-50 users, and university-wide reporting with several hundred users.
ETL development using SQL and data integration tools.
Work will span integration of many source systems, 4-6 primary systems of record plus potentially dozens of complementary data sources.
Development of operational reports, scorecards and dashboards using MS SSRS, Tableau, BObj and other tools.
Bachelor's degree (or foreign equivalent) in Computer Science, Computer Information Systems, Information Technology, Electronic Engineering, or a related field.
Additional experience may be substituted for education.
Five years of related work experience with computer systems and applications.
Additional education may substitute for experience.
Equivalency Formula: 30 undergraduate degree credits or 18 graduate degree credits = 1 year of experience. For jobs where equivalency is permitted, up to two years of non-related college coursework may be applied towards the total minimum education/experience required for the respective job.
Preferred Job Qualifications:
Knowledge in the assigned application as well as the platform on which it runs.
Knowledge, Skills, & Abilities (KSA’s):
Must demonstrate strong critical thinking and analytical reasoning skills.
Ability to work on multiple priorities effectively.
Ability to prioritize conflicting demands.
Ability to execute assigned project tasks within established schedule.
Ability to work collaboratively in a team environment.
Ability to communicate effectively in the service of users and colleagues.
Writes and communicates clearly and concisely.
Possesses sound documentation skills.
Ability to maintain confidentiality.
Must demonstrate exemplary customer service skills
Special knowledge, skills, and abilities:
Expert knowledge of Microsoft SQL Server toolset (SSMS, SSRS, SSIS, SSAS…) and BI tools including Tableau & PowerBI.
Experience in data-warehousing and dimensional data mart design.
Experience in design, development and implementation of Dashboards & Business Intelligence applications.
Experience with data analysis, trending and KPI development.
Demonstrated knowledge of project management, requirements gathering, software development methodologies and project documentation practices.
Proficient in SQL, Excel and other Microsoft Office tools.
Excellent written and oral communications.
Familiarity with student and faculty data and information systems, University business processes and systems, including Matrix, Slate, HandShake and PowerFAIDS.
Familiarity with tools such as: JIRA, Git.
Experience with using statistical languages (MATLAB, R) and statistical packages in programming languages (Python, C++); Java, and more
MS, MBA or PMP.
Familiarity with Azure, SQL Tabular models, OLAP data sources, SAP HANA, non-relational databases (NoSQL), big data technologies such as Hadoop or MapReduce.
Experience with SAP BusinessObjects Business Intelligence suite.
Experience developing reports and dashboards against SAP Business Warehouse (BW) data sources, including Business Explorer (BEx) queries.
Experience with modern web technologies, protocols and languages (REST, SOAP, JSON, XML).
Essential Job Functions (add position-specific functions if necessary)
Analysis and requirements gathering
Design and development
Testing and documentation
Implementation and maintenance
Classified Title: Software Engineer Working Title: Business Intelligence (BI) Developer Role/Level/Range: ATP/04/PE Starting Salary Range: Commensurate with Experience Employee group: Full Time Schedule: Mon-Fri, 8:30a-5:00p Exempt Status: Exempt Location: 02-MD:Mount Washington Campus Department name: [email protected] Enterprise Business Solutions Personnel area: University Administration
The successful candidate(s) for this position will be subject to a pre-employment background check.
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 HR Business Services Office at [email protected]. For TTY users, call via Maryland Relay or dial 711.
The following additional provisions may apply depending on which campus you will work. Your recruiter will advise accordingly.
During the Influenza ("the flu") season, as a condition of employment, The Johns Hopkins Institutions require all employees who provide ongoing services to patients or work in patient care or clinical care areas to have an annual influenza vaccination or possess an approved medical or religious exception. Failure to meet this requirement may result in termination of employment.
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.
Equal Opportunity Employer Note: Job Postings are updated daily and remain online until filled.
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 Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.