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

(100% Remote)

• The BI Developer is responsible for leading the development of reporting and analytics solutions for Organization'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.

• 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 organization 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.

• 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.

• Epic Clarity Data Model certification in one or more modules (EpicCare Inpatient, Hospital Billing, Prelude ADT, Radiant, Willow, Optime) or to be obtained within 120 days of hire.
• Experience in Quality Measures Reporting preferred.
• Epic build experience in a live environment strongly preferred.
• Epic implementation experience specific to clinical workflows and order management strongly preferred.
• 5+ years of experience in a healthcare related organization.
• 5+ years demonstrated expertise in MS SQL Server or Oracle.
• Strong SQL Programming Skills (MS SQL Server/Oracle platforms).
• Knowledge of data warehouse concepts, data structures and reporting.
• Extensive knowledge of Microsoft Excel, Tableau dashboard, functions, features, and capabilities.
• Extensive knowledge of best practices regarding reporting, workflows, policies, procedures, systems and culture in the healthcare environment.
• Strong analytical, problem-solving and metadata skills.
• Ability to translate business questions and requirements into reports, views, and BI query objects.
• Experience in gathering, documenting, prioritizing and tracking requirements.
• Strong organizational skills and customer service orientation.
• Must recognize and evaluate problems, and refer to the appropriate channels for action.
• High functioning team skills, including active listening and rapport building.
• Effective written & verbal communication.
• Ability to communicate with stakeholders at all levels to understand requirements.
• Ability to identify, document, resolve and/or escalate issues and maintain a complete issues log.
• Ability to accurately and precisely estimate development time.
• Ability to manage multiple and competing tasks while maintain timelines.
• Ability to work independently with general direction.
• Ability to work effectively as a team player with people of all backgrounds and at all levels.
• Ability to establish and achieve goals.
• Ability to establish and maintain a spirit of cooperation and respect, flourish in an unstructured environment, and always engage in professional and ethical conduct.
• Ability to remain calm in difficult and stressful situations.
• Ability to manage ambiguity.

• Customer focus.
• Outcomes/Results-oriented.
• Ability to establish and maintain a high level of customer trust and confidence.
• Team player.
• Adaptable/Ability to shift focus.
• Demonstrated ability to manage conflicting priorities.
• Excellent interpersonal, verbal, written communication and presentation skills.
• Demonstrated conflict resolution skills.
• Self-directed.