Sr. Business Intelligence Analyst Ii

We are seeking aSr. Business Intelligence Analyst II who will be responsible for writing and maintaining extract/transform/load routines to get data from institutional data sources for use by clinical researchers.  The position is also responsible for creating datasets from extracted "raw" data that support biostatistical analysis.

Position's roles & interactions

• This position will require a significant level of collaboration with the Core for Clinical Research Data Acquisition (CCDA) manager and other members of the CCDA team.
• Work closely with CCDA research customers to discern their needs and to understand and address changes that arise from end user acceptance testing.
  
• The analyst will use Jira to document and track assignments.
  
• Data must be delivered in a secure manner, following all applicable institutional policies and State and Federal regulations for privacy, security, and the conduct of human subject research.
  
• Partner with each clinical investigator, starting at the time of intake, to assess the customer's technical and analytic capacity and connect the team to biostatistical expertise where needed to remove data roadblocks and wheel-spinning.
  

• Provide data-related guidance beyond data extraction, at every project phase (pre- and post-data delivery).
• Post data delivery, hold data walk-through sessions, connect teams with training materials, and be on call to answer data-specific questions, ensuring that teams feel comfortable with their projected data.
  
• This position will also follow all applicable institutional policies and State and Federal regulations for privacy, security, and the conduct of human subject research.

Specific systems, applications, projects for which the position is responsible

• This position will work with CCDA analysts on extract/transform/load projects which could last in duration from 1 day to several months.
• The major systems with which the position interfaces are PMAP, Epic Clarity, Epic Caboodle, CaseMix Datamart and other systems ingested into PMAP.
  
• This position could work with about one hundred different users annually, primarily from the Johns Hopkins School of Medicine, but also from the Johns Hopkins School of Public Health, Nursing, and the Engineering Program at the Homewood Campus.
  
• The most complex part of this job is learning about the nuances of the data in large institutional databases, with data for about 7 million patient.

General Position Summary

• This role is responsible for data analytics and additional support of performance measures, ongoing measurement, data collection, reporting, data visualizations and information dissemination. Responsible for implementing the strategic design and maintenance of Business Intelligence applications. Identifies, researches, and resolves technical problems. Ensures that the use of Business Intelligence applications enhances business decision-making capabilities. Engages in data exploration exercises with a variety of complex Business Intelligence tools, requiring knowledge of relational database structures. A resource on complex technical and business matters. Work is highly independent. Will provide a leadership role for the work group through knowledge in the area of specialization. Collaborates with other analytic teams and central engineering team as directed. Works under the supervision of a Data Trust Analytic Team Leader or other data governance or analytic leadership appropriate for the scope of work. This supervision may be through a matrixed or direct reporting structure.
  

Job Scope/Complexity

• Ensures that the use of Business Intelligence applications enhances business decision making capabilities.
• Engages in data exploration exercises with a variety of complex Business Intelligence tools, requiring knowledge of relational database structures. A resource on complex technical and business matters.
• Work is highly independent.
• Will provide a leadership role for the work group through knowledge in the area of specialization.
• Collaborates with other analytic teams and central engineering team as directed.

Specific Duties & Responsibilities

• Responsible for data analytics and additional support of performance measures, ongoing measurement, data collection, reporting, data visualizations and information dissemination.
• Responsible for implementing the strategic design and maintenance of Business Intelligence applications. Identifies, researches, and resolves technical problems.
• Ensures that the use of Business Intelligence applications enhances business decision making capabilities.
• Engages in data exploration exercises with a variety of complex Business Intelligence tools, requiring knowledge of relational database structures.
• Serve as a resource on complex technical and business matters.
• Provide a leadership role for the work group through knowledge in the area of specialization.
• Collaborates with other analytic teams and central engineering team as directed.
• Makes appropriate decisions, using available resources, to achieve positive outcomes for patients, visitors, staff, and students in balance with sound business practice.
• Makes recommendations for changes in the current departmental systems and processes and contributes ideas and suggestions for solutions to the current system's problems.
• Responds to urgent, impromptu, and unplanned situations by assessing their level of importance, instituting appropriate action and information appropriate management.
• Communicates decisions to appropriate management.
• Prepares incident/occurrence reports as necessary.
• Prioritizes daily tasks and assignments appropriately.
• Completes mandatory Epic and/or other software or analytic tool training as required.
• Collaborates with other analytic teams as directed.
• Data mining/management, data collection instruction, including ability to show data in a user-friendly format for a variety of audiences.
• Report and follow-up on software problems resulting in delay in workflow.

Knowledge, Skills, & Abilities (KSA's)

• Knowledge of project and information management.
• Analytical ability required to gather data, perform transformation, perform complex analysis, solve both business and technical problems.
• Advanced knowledge of medical terminology and clinical informatics for positions working with patient-related data.
• Expert proficiency with Business Intelligence development tools to generate reports, dashboards and analytical solutions according to business rules and specifications.
• Advanced knowledge of relational databases. Knowledge of EMR data structure for positions working with patient-related data.
• Advanced ability to problem-solve creatively and analyze processes and systems.
• High level of understanding of structured programming, types of databases, file structures and programming tools.
• Requires a working knowledge of data warehouse and data management principles.
• Requires experience with data transformation and analytics projects.
• Must possess advanced written and verbal communication skills necessary to gather and exchange data (both internally and externally).
• Ability to independently assess and lead others in which data management and statistical strategies are needed to optimally report outcomes.
• Highly proficient with administrative skills, including advanced use of word processing, database, spreadsheet and desktop publishing software.
• Ability to analyze highly complex data sets.
• Good analytical and advanced problem-solving ability to assess, prioritize and solve highly complex clinical and systems problems.
• Strong problem identification and resolution skills.
• Advanced interpersonal and communications skills required to work with a diverse group of people.
• Ability to balance multiple tasks simultaneously and quickly switch between priorities/tasks.
• Ability to interact with all levels of staff and adapt to a rapidly changing work environment.
• Advanced critical thinking skills and ability to apply them in various situations.
• Ability and willingness to mentor colleagues and share experiences to strengthen the team's success.
• High analytical ability to solve complex technical problems.
• Able to lead the work of a diversified staff in various environments.
• Able to lead the work of staff in other groups.
• Advanced interpersonal skills to effectively interface with department heads, colleagues, vendors, and consultants, to lead projects.
• Able to effectively communicate and interact with JHHS staff as required.
• Advanced computer skills and the ability to operate audiovisual, general, and office equipment.
• Ability to balance multiple tasks simultaneously and quickly switch between priorities/tasks.
• Ability to interact with all levels of staff and adapt to a rapidly changing work environment.
• Advanced critical thinking skills and ability to apply these skills in various situations.
• Ability and willingness to mentor colleagues and share experiences to strengthen the team's success.
• High analytical ability to solve complex technical problems.
• Able to lead the work of a diversified staff in various environments.
• Able to lead the work of staff in other groups.
• Advanced degree of problem solving in a fast paced, high dynamic and complex environment.
• Awareness of the need for timely communication, ability to identify potential barriers and strategies, and ability to synthesize and integrate information.
• Knowledge of and ability to use multiple information systems and software.
• Expert proficiency with word processing, spreadsheet software, database structures, and the internet.

Required Licensure Certification, etc.

• If the candidate does not already have Epic Clarity Certification, then they will be expected to attend training sessions at Epic Headquarters in Verona Wisconsin for training leading to Clarity certification.
• Certification is required for this job.
• In order to remain employed in this position, the candidate must pass the certification test in 3 attempts.

Required Skills

• Bachelor's Degree in mathematics, computer science, physics, information systems, actuarial science or related computational field.

• Highly skilled in developing applications using PL/SQL, JavaScript, and HTML.
• Create design specifications for new research data extracts, and identify and validate the appropriate technological solutions for various research data requests
• Experience extracting, analyzing, cleaning and transform data.
  
• Performed data analysis, logical data modeling, created database objects, applying data normalization techniques and implementing data integrity.
  
• Project responsibilities are involved in designing, implementing, managing and troubleshooting databases and database objects.
  
• Project management skills using Agile Methodologies using Jira/Bit Bucket
  
• Experience with data quality, data profiling, metadata management and reporting. Ability to convey technical methods, approaches and plans to audience of varying degrees of technical understanding including clinical and business stakeholders and technical team.
  
• Excellent leadership skills with ability to negotiate and work collaboratively; service-oriented with excellent verbal and written communication and organization skills; knowledge of formal project management methodologies, structured software development/system design, and implementation of integrated technologies and processes; comprehensive understanding of business requirements gathering and analysis; understanding of change control/change management and the implications of technology solutions.
  
• Must be able to work closely with customers and understand and translate their functional needs into technical requirements. Experience in delivering effective technology solutions in a higher education environment or in the technology supported or enabled delivery of education is required.

• Bachelor's Degree in Mathematics, Computer Science, Information Systems, Actuarial Science or related computational field.

• Minimum of six years of experience in a professional environment where the required knowledge base and skills have been utilized, and a minimum of 3 years of data analytics.

• Highly skilled in developing applications using PL/SQL, JavaScript, and HTML.
• Experience extracting, analyzing, cleaning and transform data.
• Performed data analysis, logical data modeling, created database objects, applying data normalization techniques and implementing data integrity.
• Experience with data quality, data profiling, metadata management and reporting.
• If the selected candidate does not have Epic Clarity Certification, they will be expected to attend training sessions at Epic Headquarters in Verona Wisconsin for training leading to Clarity certification. Certification is required for this job. In order to remain employed in this position, the candidate must pass the certification test in 3 attempts.
• Additional education may substitute for required experience, to the extent permitted by the JHU equivalency formula and additional experience may be substituted for education to the extent permitted by the JHU equivalency formula.

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