Business Intelligence Developer

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Business Intelligence Developer

Location(s): Los Angeles, CA
(Remote)

SUMMARY STATEMENT:
The BI Developer is responsible for leading the development of reporting and analytics solutions for University's electronic health record (EHR) system by gathering business needs, documenting requirements, identifying appropriate data sources, developing reports, and delivering them to stakeholders. The BI Developer takes direction from, and collaborates with, the Assistant Director of Decision Support Services and the Senior Director, Finance Operations on work priorities and manages the resolution of escalated issues. The BI Developer will perform in depth and precise investigation and documentation of future-state reporting specifications and application reporting functionality. The BI Developer must achieve in-depth knowledge of relevant software applications as well as understand policies, procedures and constraints.

TYPE OF SUPERVISION RECEIVED:
The BI Developer receives overall objectives, deliverables and priorities from the Assistant Director, Decision Support Services and the Senior Director, Financial Operations. The manager and team are expected to determine the most effective way to accomplish assigned tasks within the timeframes allowed, and to work independently with minimal supervision.

KEY RESPONSIBILITIES:

• Meet with stakeholders to understand business needs for data requests. Gather requirements, document, clarify, interpret specifications and review for completeness and accuracy.
• Design, develop, validate and perform thorough functional testing of extracts, reports, visualization dashboards utilizing analytics tools and data sources such as, including but not limited to: Microsoft Excel, Tableau, WebI, SSRS, Power BI, Caboodle, Clarity, Reporting Workbench, Radar Dashboards, Universes, Registry Framework and Data Marts, SlicerDicer, and other Business Intelligence Tools.
• Collaborate with interdisciplinary teams, including faculty practice team members, administrators, IT staff, and vendors. Effectively communicate technical concepts and analytical findings to both technical and non-technical stakeholders, facilitating collaboration and informed decision-making.
• Monitor performance of BI outputs and take corrective action to optimize or improve the performance when necessary.
• Gather, assess, and interpret substantial amounts of healthcare data, encompassing electronic health records, clinical data, financial data, and pertinent information. Offer insights and suggestions derived from the data analysis and interpretation.
• Streamline documentation, scheduling, billing, and other administrative tasks, ultimately enhancing operational efficiency and reducing errors.
• Provide training and support to healthcare staff on the use of health informatics tools and systems. Create educational materials, conduct workshops, and offer guidance to ensure proper utilization and understanding of dashboards, reports and other tools enabled by the team.
• Participate in application validation and QA efforts as they pertain to data, metrics, and analytics solutions creation and execution.
• Manage the inventory of BI objects and outputs. Assure that the metadata used for the Analytics Catalog is meaningful, standardized, complete, accurate, and up to date.
• Manage the data model for reporting for assigned Epic applications and/or business lines. Manage the inventory of Clarity & Caboodle objects used for both published and ad hoc analytics. Assure that all object metadata is meaningful, standardized, complete, accurate, and up to date.
• Manage the measures and metrics for assigned Epic applications and/or business lines. Assure that the metadata used for the Measures and Metrics catalog is meaningful, standardized, complete, accurate, and up to date. Note the content maintained in the Epic Metrics Catalog and use that as an anchor for University metrics.
• Review upgrade documentation related to analytics tools and content, determine the best implementation approach. Evaluate, anticipate and communicate risks to existing BI outputs and processes, and recommend ways to mitigate those risks.

GENERAL RESPONSIBILITIES:

• Work closely and collaboratively with end users, Application team, Epic TSs, Super Users, Training team, ISS support, fellow team members and other stakeholders to ensure the right reporting tools are used to maximize value to end users for reporting and analytics.
• Work with fellow team members and end-users to resolve problems promptly. Takes the proper initiative to meet the expectations and needs of the user base. Completes tasks with quality and within the expected timeframe. Follows through and follows up on tasks or requests (from end to end). Maintains a high level of professionalism. Prompt in attendance of meetings. Adequately prepared for meetings – materials have been adequately prepared, presentation is clear, concise and professional. Maintains a good work ethic, exhibits attitude of respect and integrity toward others. Manages personal work assignments and priorities. Communicate clearly and foster good relationship and partnership and provide input and support to other team members within FPG.
• Support and champion FPG enterprise strategy with regards to data, analytics and informatics.

University C-I-CARE/Patient Experience Practices: MY COMMITMENT TO CARE

• Observe and practice all the Service Standards listed in the “World Class Practices” (which I have read and signed). Practice C-I-CARE when interacting with patients, their families, visitors, or internal customers. Connect with the patient and family members by addressing them as Mr./Ms., or by the name that they prefer. Introduce yourself and your role. Communicate what you are going to do, how long it is going to take, and how it will impact the patient. Ask and anticipate patient and/or family needs, questions or concerns. Respond to patient and/or family questions and requests with immediacy. Exit courteously and/or with an explanation of what will come next (or when you will be back to check on them). Practice C-I-CARE phone etiquette during all phone interactions.
• Always exercise courtesy whenever patients, family members, visitors and co-workers are present. Respect privacy and dignity of our patients, family members, visitors and co-workers. Maintain professionalism in the presence of patients, their families, visitors and co-workers. Observe departmental Patient Experience plan, competencies and practices. Act as a role model, verbally and behaviorally demonstrating skill, enthusiasm, positive problem solving, commitment and loyalty to the profession and the organization. Participate in positive problem solving by providing suggestions and possible solutions to identified concerns/problems in the work place.
• Comply with Health System Workplace Conduct Policy. Engaging in disruptive behaviors that interfere with or prevent normal work functions or compromise patient safety, including passive or active behaviors will not be tolerated as stated in the HS Workplace Conduct Policy.
• Comply with Health System Dress Code Policy and practices.

INSTITUTIONAL AND/OR PROFESSIONAL STANDARDS:

• Comply with HIPAA and Confidentiality Policies and Procedures as they apply to the job.
• Comply with Department of Public Health (DPH), The Joint Commission and other accreditation and regulatory agencies standards.
• Adhere to all Hospital Policies and Procedures.
• Knowledge and adherence to Infection Control and Environment of Care Guidelines and Procedures as described in the annual education module.

PERFORMANCE IMPROVEMENT:

• Adhere to current organizational Performance Improvement priorities.
• Participate in coordination activities through meetings, data collection and dashboard data collection.
• Make recommendations and take actions to improve structure, system or outcomes.

OTHER DUTIES:

• Carry out tasks related to FPG projects that are relevant to Decision Support business intelligence and analytics domains.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.