Business Intelligence

Company Description Renowned as the academic flagship of the University of Maryland Medical System, our Magnet-designated facility is a nationally recognized, academic medical center with opportunities across the continuum of care. Come join UMMC and discover the atmosphere where talents and ideas come together to enhance patient care and advance the science of nursing. Located in downtown Baltimore near the Inner Harbor and Camden Yards, you won’t find a more vibrant place to work

Job Description General Summary: Under minimal supervision, works with internal and external customers to understand and analyze requirements and develop business intelligence (BI) solutions using underlying technologies. Contributes to the design, development, testing, documentation, and maintenance of reporting and analytic solutions. Supports key strategic organizational priorities, including population health management, clinical performance, and quality/operational performance. This position will serve as key BI Developer responsible for the system Antimicrobial Stewardship, leadership quality metrics and similar dashboards which includes produces exploratory analysis; gathering requirements and insights; determining business problem/purpose, identifying questions to answer; and creating data sources, wireframes and visualizations. Principal Responsibilities and Tasks: The following statements are intended to describe the general nature and level of work being performed by people assigned to this classification. These are not to be construed as an exhaustive list of all job duties performed by personnel so classified. Serves as a member of cross-functional teams to achieve goals of BI and IT projects, including work plans, system design, and testing of solutions. Develops data flow diagramming for BI reports and projects. Identifies project risks and impediments; proactively works with other members of the team to complete assigned tasks as defined by project scope, timelines, and budgets. Develops dynamic data discovery and visualization analytics environments. Performs troubleshooting of implementation issues; tests security of roll-outs. Supports technical development of BI reports, applications, and other tools. Reads and interprets conceptual, logical, and physical models to include context, data flow, process flow, logical diagrams, and data dictionaries. Reads and interprets design documents. Performs medium to complex data queries and mapping. Understands data modeling concepts (e.g., the entity-relation model) and their applications: entities and tables, relations and constraints, attribute datatypes, and column data types. Writes, validates, and executes test plans for solutions, applications, and/or operating systems. Ensures a high level of availability for all critical reports and applications. Assists in updates and upgrades of BI software. Assists project sponsors in the interpretation and use of the results; ensures that the data is understood by users. Prepares supporting documentation, reports, and presentation materials. Coordinates prototype review, integration, system, and user acceptance testing (UAT). Creates ad-hoc queries and reports as requested and provides ongoing analytical support for these requests. Develops healthcare subject matter expertise related to specific products, data elements, business processes, data marts, and BI applications. Demonstrates basic understanding of the strategic alignment of IT solutions with business objectives. Estimates software development efforts based on high level specification and/or logical system design. Provides technical expertise as required. Responsible for issue reporting, tracking, analysis, and follow-up. Validates development of prototypical systems or system components to demonstrate technical feasibility. Prototype construction may include the utilization of hardware and software development tools and techniques. Develops medium to complex software in a variety of environments and platforms to address stated system goals and needs. Resultant software should confirm to accepted standard.

Qualifications Education and Experience Bachelor's Degree in mathematics, computer science, physics, information systems, actuarial science or related computational field. Master’s Degree preferred. At least two years of business intelligence and analytics experience, including data discovery/visualization applications, hardware/software configuration, databases, and data access/programming tools. At least two years of hands-on experience with business intelligence and statistical programming/analysis tools (e.g., Business Objects, Tableau, Olik, R, or similar applications). SAP experience preferred as well as proficiency in one computer programming language (e.g., C, C++, Java, Perl, etc.) Knowledgeable about database design, problem analysis, and relational database concepts. Skilled in developing applications using PL/SQL, JavaScript, and HTML. Familiarity with HL7 interfaces and ETL processes desired. Prior experience in healthcare and with clinical claims data preferred. Prior experience with one or more of the following transaction systems (Epic, McKesson, Lawson) preferred. Prior experience working directly with clinicians and/or pharmacists with the pharmacy (Epic Willow) module preferred.

Additional Information All your information will be kept confidential according to EEO guidelines.

#J-18808-Ljbffr