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.
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.
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).
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 Baltimore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.