Skip to main content

This job has expired

Software Engineer (BI)

IT@JH Enterprise Business Solutions is seeking aSoftware Engineer who will be 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.

General summary/purpose

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.

Primary Responsibilities:

  • Responsible for the design, development, testing, implementation and maintenance of reporting solutions for university divisions, central academic and administrative leadership.
  • 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.
  • 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.
  • Responsible for unit, integration, stress/load testing of reports and dashboards to ensure functional and performance requirements are met.
  • Solve 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.

    Secondary Responsibilities:
  • Work with data warehousing team to develop data warehouses and data marts as needed.
  • Coordinate knowledge transfer for projects and deliverables to coach and train teammates on BI tools, reporting and analytic best practices and data visualization techniques.
  • Make use of data, statistical and quantitative analysis; explanatory and predictive modeling 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 position’s roles & interactions:
  • Work closely with business leaders and analysts to maximize the effectiveness of data to achieve their business objectives.
  • Work closely with data stewards and data warehouse team to understand various data sources.
  • Collaborate with developers and end-users to understand requirements and specifically, how the desired products and deliverables drive the system architecture and data model.
  • Responsible for analysis, design, development, testing and maintenance of front-end BI and analytic content of moderate to high complexity; and a high degree of initiative and autonomy is expected.

    Specific systems, applications, 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 projects will vary from targeted, power user initiatives, divisional reports with 20-50 users, and university-wide reporting with several hundred users.
  • Work will span integration of many source systems, 4-6 primary systems of record plus potentially dozens of complementary data sources.
  • Develop SQL queries, views, stored procedures to integrate and transform data.
  • Development of operational reports, scorecards and dashboards using Tableau, MS SSRS, BObj and other tools.

    Required & preferred skills specific to position:
    Required Skills:
  • Advanced knowledge in Microsoft SQL SSMS, query development, SSRS reporting, and PowerBI or Tableau.
  • Experience in data warehousing and datamart design.
  • Experience in design, development and implementation of Dashboards & Business Intelligence applications.
  • Experience with data analysis, trending, metric 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.

    Preferred:
  • Familiarity with student and faculty data and information systems, University business processes and systems, including Matrix, Slate, HandShake and PowerFAIDS.
  • Familiarity with financial and other ERP data in SAP.
  • Proficiency with the entire Microsoft SQL and BI toolset including: SSMS, SSIS, SSAS and Power BI.
  • Understanding of data modeling principles including relational, dimensional, star schema.
  • Familiarity with tools such as: JIRA, GIT.
  • Experience with using statistical languages (MATLAB, R) and statistical packages in programming languages (Python, C++).
  • Experience with SAP BusinessObjects Business Intelligence suite.
  • Experience developing reports and dashboards against SAP Business Warehouse (BW) data sources, including Business Explorer (BEx) queries.
  • Familiarity with various types of data sources: OLAP data sources, SAP HANA, non-relational databases (NoSQL), big data technologies such as Hadoop or MapReduce.
  • Experience with modern web technologies, protocols and languages (REST, SOAP, JSON, XML).
  • MS, MBA or PMP.

    Work location: Mt. Washington, 5801 Smith Avenue, Davis 3200 – 2nd Fl, Baltimore, MD 21209

    On call requirements : Off hours support not expected; only in event of unlikely system events.

Job Scope/Complexity:

  • 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.

Specific Duties & Responsibilities:

Analysis & 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 & 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 & 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 & 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.

The responsibilities listed above 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.

Minimum Qualifications (Mandatory):

  • Bachelor’s Degree required. Additional experience may be substituted for education.
  • Five years of related work experience with computer systems and applications. Additional education may substitute for experience.

Preferred Qualifications:

  • Knowledge in the assigned application as well as the platform on which it runs.

Special Knowledge, Skills, & Abilities:

  • Must possess all requisite knowledge, skills, and abilities as posted in the supplemental section.
  • 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

JHU 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.

Classified Title: Software Engineer
Working Title: ​​​​​​​Software Engineer (BI)
Role/Level/Range: ATP/04/PE
Starting Salary Range: ​ Commensurate with experience
Employee group: Full Time
Schedule: Mon-Fri 8:30am-5:00pm
Exempt Status: Exempt
Location: ​​​​​​​Mount Washington Campus
Department name: ​​​​​​​IT@JH 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 atjhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711.

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons or because the individual is pregnant or attempting to become pregnant. Requests for an exception must be submitted to the JHU vaccination registry. 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 on which campus you will work. 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.

Equal Opportunity Employer
Note: Job Postings are updated daily and remain online until filled.

EEO is the Law
Learn more:
https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf

Mount Washington Campus


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 jhurecruitment@jhu.edu. 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.

EEO is the Law
Learn more:
https://www1.eeoc.gov/employers/upload/eeoc_self_print_poster.pdf
Important legal information
http://hrnt.jhu.edu/legal.cfm

Get job alerts

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

Create alert