Share this Job
Job Req ID:  162

Sr. Software Engineer

Range: PF

Level: 4

Salary: $78,298 - $107,629

Status: Full Time

School: School of Medicine

Location: JH at Franklin Square

Location City: Baltimore

Location State: MD

Resume Required for Application: Yes

Area of Interest: Technical

Contact: 410-955-2990



General Description


Department: CPA Medical Service Plan
Work Schedule/Hours: Monday-Friday 8:30a.m.-5:00p.m. 37.5 hrs.

The Sr. Business Intelligence (BI) Developer position exists to provide technical development of analytics and reporting solutions for the Clinical Practice Association (CPA). The position will have a broad scope that entails analytic and reporting projects from CPA leadership to meet operational and financial goals for the CPA and JHM enterprise initiatives. This position will work closely with business operations and finance leaders and their staff to understand how data can be effectively used. This position serves as a technical leader on complex dashboarding, reporting, and business intelligences projects; and a high degree of initiative and autonomy is expected with the ability to work independently with minimal supervision.

This position will develop, test, and implement new and enhanced reports/tools, define new data aggregation views, working with key stakeholders to develop and enhance the quality and presentation of operational metrics, trend analyses, and statistical models. Responsible to ensure that an Analytic/BI industry standard system development life cycle project management technique is used in all application development, implementation, and enhancements. JHM is a highly decentralized environment with staff working in a matrixes environment as part of the IT team or part of a customer led team. Agility to handle multiple priorities from different customers across JHM entities is required for success in this role.

Responsible for full life-cycle of large/long-term highly complex projects. Typically manages multiple projects of varying complexities. Based on expert technical knowledge, skills and experience, develops broad-based solutions involving multifaceted technologies, and business processes. Leads overall strategy, design & architecture for solutions.

Duties and Responsibilities:

Provide expert BI development and support for the CPA datamart team and end user community Collaborate with developers and end-users to understand requirements and specifically, how the desired products and deliverables drive the system architecture and data model. Work closely with data owners and data warehousing teams to understand various data sources. Design and development of the architecture for all data visualization components to include dashboarding, drill downs, automated reports, business intelligence and logic. Configuration, design and implementation of dashboard and analytic tools to support visual representation of operational and financial data. Develops data and metadata policies and procedures to build, maintain and, leverage the data model. Enriches data with 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 design, reporting solutions, and business intelligence tools. Supports the development and operation of the BI environment and the users on these systems so that the capabilities of the systems are effectively utilized for the benefit of goals and objectives. Assists in the research and development of new business intelligence tools and techniques for analytic projects.

Accountable for capacity planning activities in dashboarding and reporting tool and related analytical platforms. Work closely with IT team members (Data/System Architect, Senior Software and Software Engineer) to execute projects and daily support and to perform cross coverage of duties. Perform different roles in BI projects – Analyst, Data Profiler, Developer, Tester, Architect, ETL, and User Experience. Will manage and perform projects with varying size of user base. Some small, targeted developer-focused initiatives, others with initial user base of 20- 50 users; and projects with several hundred users. Gathers requirements and use cases from end users for visualization of data and reporting outputs. Reviews project requests describing (BI) user needs to estimate effort to accomplish project. Work with business and IT management to understand and prioritize data and information needs. Provides “as needed” project status reporting and is able to escalate issues to management. Carry out professional documentation of projects. Maintains high ethical standard in dealing with sensitive data. Successfully negotiates with vendors and customers to resolve the problem. Understand and develop KPIs with project champions.

Secondary Responsibilities: (Learn and perform to provide cross coverage for ETL and database duties). Develops ETL process using SQL Server Integration Services (SSIS). Plays role in contributing to the ETL design, evaluation, selection, implementation and support of databases solutions. Works closely with the Data/BI Architect, business analysts, software engineers on ETL development and BI Reporting. Troubleshoots problems regarding the databases, applications and provides technical support. Identifies and analyzes queries and stored procedures for optimization. Monitors databases for optimal performance acting quickly to mitigate performance issues.




Bachelor’s degree. Six years of related work experience with computer systems and applications. Additional experience may be substituted for education, to the extent permitted by the JHU equivalency formula. Additional education may substitute for experience.

Minimum of 3 years of experience with IBM Cognos BI Analytics – COGNOS 10.2.x (Framework Manager, Transformer, Power play client, COGNOS workspace, COGNOS Workspace Advanced, Report Studio, Analysis Studio, Query Studio, Active Reports) Experience with Autosys, HTML, Javascript, Java, LDAP Experience with SQL Server and SQL Query Proficiency with data analysis, modeling and design methodologies.

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 (semester hours) or 18 graduate degree credits may substitute for one year of experience.


Preferred Qualifications


Experience with Cognos Analytics 11.0. Experience with Tableau BI. Experience with TSQL including stored procedures, triggers, and user defined function. Experience with SSIS/ETL. Microsoft SQL Server Certifications (MCDBA/MCITP).

JH at White Marsh

Job Postings are updated daily and remain online until filled.
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 For TTY users, call via Maryland Relay or dial 711.

The following additional provisions may apply, depending on at 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
EEO is the Law. Learn more:
Important legal information:

Apply now »
Find similar jobs: