Business Intelligence (Bi) Developer - Epic

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!

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.

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.

• Performs troubleshooting of implementation issues; tests security of roll-outs.
• 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.
• Supports technical development of BI reports, applications, and other tools.
• 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.
• 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.
• 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.
• 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.
• 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.
• Prepares supporting documentation, reports, and presentation materials.
• Coordinates prototype review, integration, system, and user acceptance testing (UAT).
• Develops data flow diagramming for BI reports and projects.
• Demonstrates basic understanding of the strategic alignment of IT solutions with business objectives.
• Develops dynamic data discovery and visualization analytics environments.
• Creates ad-hoc queries and reports as requested and provides ongoing analytical support for these requests.
• 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.
• Develops healthcare subject matter expertise related to specific products, data elements, business processes, data marts, and BI applications.

Qualifications

Education and Experience

• At least two years of business intelligence and analytics experience, including data discovery/visualization applications, hardware/software configuration, databases, and data access/programming tools.
• Knowledgeable about database design, problem analysis, and relational database concepts.
• Prior experience working directly with clinicians and/or pharmacists with the pharmacy (Epic Willow) module preferred.
• Bachelor's Degree in mathematics, computer science, physics, information systems, actuarial science or related computational field. Master’s Degree preferred.
• Familiarity with HL7 interfaces and ETL processes desired.
• 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.)
• Skilled in developing applications using PL/SQL, JavaScript, and HTML.
• Prior experience with one or more of the following transaction systems (Epic, McKesson, Lawson) preferred.
• Prior experience in healthcare and with clinical claims data preferred.

Additional Information

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