Business Intelligence Developer

Summary

Join the University of Maryland Medical System (UMMS) as a Business Intelligence Analyst! Under minimal supervision, you will collaborate with internal and external customers to analyze requirements and develop BI solutions. You will contribute to the design, development, testing, and maintenance of analytic solutions, requiring expertise in relational databases and BI technologies. The ideal candidate possesses strong critical thinking and analytical skills, along with the ability to create insightful visualizations and compelling narratives from data. You will support key organizational priorities, including population health management and clinical performance. This role reports to the Senior Manager, Clinical & Business Intelligence.

Requirements

• Bachelor's Degree in mathematics, computer science, physics, actuarial science or related computational field or equivalent experience using demonstrated BI skill sets in a working environment. Ability to generate highly complex optimized SQL code and an understanding of various database models
• At least four (4) years in Business intelligence and analytics experience in a working environment developing medium to complex projects using data discovery/visualization applications, implementing hardware/software configuration as needed building database extractions using data access/programming tools (such as SQL, Python)
• Hands-on experience with business intelligence and statistical programming/analysis tools in two or more of the following: Business Objects, Tableau, Qlik, R, or similar applications. Proven proficiency in a computer programming language (e.g., C, C#, C++, Java, Python etc.) in a working environment
• Using exploratory analysis, demonstrating ability to make sense of the data, offer insights and critical analysis; determine the appropriate ensuing questions to ask, how to frame them, and how to approach them
• Using storytelling concepts, demonstrating an ability to build a narrative around a set of data and its accompanying visualizations to help convey the meaning of that data and resulting insights in a powerful and compelling fashion; determine the appropriate set of visualizations with evidence-based justification
• Basic understanding of statistical concepts including distributions, probability, correlations, confidence Intervals, significance testing (type I and type II errors), testing means, analysis of variance, regression, moving averages, and Chi-Square; demonstrate ability to determine which statistical concept appropriate to use and be able to use them correctly
• Proven knowledge of database design, problem analysis, and relational database concepts in a working environment
• Must be proficient with technical assessment delivered by D&A team
• Epic Certification in a Clarity Data Model (Clinical, Access, or Revenue) or completion of Epic Certification (must be obtained within 3 months of training completion)

Responsibilities

• Serve as a member of cross-functional teams to achieve goals of BI (and broader Data & Analytics) projects, including work plans, system design, and testing of solutions
• Develop dynamic data discovery and visualization analytics environments using exploratory analysis, storytelling and statistical concepts
• Assist project sponsors in the interpretation and use of the results; ensure that the data is understood by users
• Develop data flow diagrams for BI solutions and projects
• Support projects conducting research, collecting and analyzing data
• Develop medium to complex reports, visualizations and applications using a variety of tools including Unix scripting, SQL, R, Python Crystal, Tableau, HTML, Java
• Identify project risks and impediments; proactively work with other members of the team to complete assigned tasks as defined by project scope, timelines, and budgets
• Perform troubleshooting of implementation issues; test security of roll-outs
• Support technical development/maintenance of BI solution applications, and other tools
• Read and interpret conceptual, logical, and physical models to include context, data flow, process flow, logical diagrams, and data dictionaries. Read and interpret design documents
• Perform medium to complex data queries and mapping. Understand data modeling concepts (e.g., the entity-relation model) and their applications: entities and tables, relations and constraints, attribute datatypes, and column data types
• Write, validate, and execute test plans for solutions, applications, and/or operating systems. Ensure a high level of availability for all critical applications
• Prepare supporting documentation, reports, and presentation materials
• Coordinate prototype review, integration, system, and user acceptance testing (UAT)
• Develop healthcare subject matter expertise related to specific products, data elements, business processes, data marts, and BI applications
• Demonstrate basic understanding of the strategic alignment of IT solutions with business objectives
• Estimate software development efforts based on high level specification and/or logical system design. Provide technical expertise as required. Responsible for issue reporting, tracking, analysis, and follow-up
• Validate 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
• Develop medium to complex software in a variety of environments and platforms to address stated system goals and needs. Resultant software should confirm to accepted standards for robustness, re-usability, modularity, efficiency, etc. Software development efforts should result in defect-free applications
• Perform routine and ad-hoc data analysis and offer insights that may inform strategic and operational decisions and provide ongoing analytical support
• Perform basic statistical analysis to determine efficacy of strategic or operational clinical and business initiatives
• Provide application support and guidance to end-users and provide technical guidance to less experienced personnel and support staff. Serve as a point of contact for resolution of complex application problems
• Conduct and/or participate in in-service and various educational programs for professional development. Orient, and transfer knowledge to peers

Preferred Qualifications

• Master’s Degree
• Familiarity with HL7 interfaces and ETL processes desired
• Prior experience in healthcare including business and clinical aspects
• Prior experience with one or more of the following transaction systems (Epic, Lawson or similar enterprise transaction systems in other industries) preferred