Business Intel Analyst III
Job Summary: The Business Intelligence Analyst III plays a key role in the development of Crystal Reports, Dashboards, Stored Procedures and Business Intelligence Analytics for the organization. Collaborates with business partners with defining and implementing decision support and business intelligence (BI) software solutions to achieve business objectives. Provides guidance to Mary Washington Healthcare entities through enterprise reporting as well as clinical and financial systems data requests. Performs ad-hoc reports as needed. Familiar with a variety of the field's concepts, practices, and procedures. Relies on experience and judgment to plan and accomplish goals. May direct the work of other analysts.Essential Functions & Responsibilities:Performs value added analysis of all enterprise reporting and data requests to determine appropriate system, correct delivery method, and target audience. Understands (and facilitates through systems and reports) the integration of business processes and provides system and business consultation for the best integrated, automated process to solve the business problem. Monitors financial systems, data warehouse system databases and interfaces to ensure accurate internal and external reporting as well as correct functioning. Develops SQL Stored Procedures, data modeling and Queries to meet business needs. Responsible for development of Business Objects Universes, Crystal Reports, Business Objects Dashboards and Healthcare Query reporting. Promotes/ensures system data integrity by resolving system issues and identifying enhancements to improve data quality and operational efficiencies. Maintains/promotes excellent communications and interpersonal relationships, serving as liaison between business units and IS as well as assists with end user education and report/data Determines root cause analysis of data quality and process issues. Collaborates with users to refine requirements, develop specifications, coding, unit testing, user acceptance testing, documentation, andimplementation. Provides system related training materials, process documentation and performs end user training. Facilitates department efforts to analyze and document processes that could be improved by applying information technology. Provides documentation of all programs, systems, and enhancements to ensure continuity of program maintenance, including program logic flow charts, record layouts, and program Develops test plans; coordinates and executes testing of all Rules, Workflows, Interfaces, and Reports Monitors financial systems, data warehouse system databases and interfaces to ensure accurate internal and external reporting as well as correct functioning Responsible for development of Business Objects Universes, Crystal Reports, Business Objects Dashboards and Healthcare Query reporting. Follows best practices and tools for project execution and management. May serve as subject matter expert on Mary Washington Healthcare data, processes, and business methodologies. Participates in continuing professional development, initiates and participates in R&D activities. Monitors business use and utilization of reports. Supports staff in reporting and/or refining requirements. Performs other duties as assigned including resolving emergency issues/situations.Qualifications: Requires Bachelor's Degree in Computer Science, Business, Mathematics or technical based field of study. Requires 4-7 years of experience as a Reports Developer using Business Objects, SAP and Crystal RepoRequires 4-7 years of analytical reporting deployment, design, development and architecture experience using Business Objects.Requires strong knowledge of data quality management best practices. Requires at least 4 years of SQL query development experience.Prefer 4 years of experience in healthcare industry with understanding of data terminology. Must be proficient in all Microsoft Office Tools. Must be detail and process oriented.Must have knowledge of change-control, patch management, testing procedures.Prefer Master's degree (MIS, MBA, MHA, or related field).