Business Intelligence Developer

Ampcus, Inc; Los Angeles (CA); Remote; USD 80,000 - 120,000; Full time

Job summary

An innovative firm is seeking a skilled Business Intelligence Developer to enhance reporting and analytics for healthcare data. In this role, you will lead the development of impactful solutions, collaborating with diverse teams to drive data-driven decision-making. Your expertise in BI tools and healthcare data management will be vital in optimizing operations and improving patient outcomes. Join a dynamic team where your contributions will shape the future of healthcare analytics, and enjoy the flexibility of a fully remote work environment that fosters professional growth and collaboration.

Benefits

Flexible working hours

Remote work options

Professional development opportunities

Health insurance

Retirement savings plan

Paid time off

Employee wellness programs

Collaborative work environment

Qualifications

• 5+ years of experience in a healthcare-related organization.
• Strong SQL programming skills and knowledge of data warehouse concepts.
• Experience with BI tools like Tableau and Power BI.

Responsibilities

• Lead development of reporting and analytics solutions for EHR systems.
• Collaborate with stakeholders to gather requirements and validate reports.
• Provide training and support on health informatics tools.

Skills

SQL Programming

Data Analysis

Business Intelligence Tools

Healthcare Data Management

Communication Skills

Problem-Solving

Project Management

Team Collaboration

Education

Bachelor's Degree in Computer Science or related field

Epic Clarity Data Model certification

Tools

Microsoft Excel

Tableau

Power BI

SSRS

Epic Systems

Job description

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)

SUMMARY STATEMENT:

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

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

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.

SKILLS AND EXPERIENCE:

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

General (Soft Skills)

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

Shift:

Day 5x8-Hour (08:00 - 17:00).





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.