Business Intelligence Developer, Ambulatory Transformation and Performance
Company: American Health Quality Association
Location: Los Angeles
Posted on: November 8, 2024
Job Description:
Description The Ambulatory Ops Business Intelligence Developer
is an integral member of the Ambulatory Transformation and
Performance (ATP) team, responsible for developing and delivering
advanced reporting and analytics solutions to support the ATP
mission in ensuring the efficient operation of ambulatory clinics
to enhance financial viability, optimize performance, and foster
informed, data-driven decision-making. This senior technical expert
leads the design, implementation, and optimization of clinical
informatics systems, with a focus on solving complex technical
problems and mentoring junior analysts. The incumbent collaborates
closely with clinical, technical, and business teams to ensure data
integrity and system reliability, driving the development of
actionable insights through advanced analytics. Responsible for
developing reporting and analytics solutions for the
department/health system users by gathering business needs,
documenting requirements, identifying appropriate data sources,
developing reports and dashboards, and delivering them to
stakeholders. This involves designing and writing of new and/or
modifying the existing applications to facilitate goals and meet
information and automation needs of department/health system users.
Interacts with key stakeholders, leadership, and subject matter
experts to develop a deep understanding of analytical needs and
translates requirements into business intelligence solutions that
drive business decisions, insight, and outcomes through actionable,
easy-to-read dashboards and reports.
- Lead the development and optimization of complex SQL queries,
views, and stored procedures for data analysis and reporting for
ambulatory operations
- Design, develop, and perform thorough functional testing of
reports and dashboards utilizing reporting tools and data sources
such as CDW/Clarity, Reporting Workbench, Data Marts, Tableau, and
other Business Intelligence Tools.
- Monitor the performance of reports and take corrective action
to optimize or improve the performance when necessary.
- Perform advanced quality assurance testing and document system
changes to ensure high standards of performance.
- Track operational metrics and perform sensitivity analysis to
explain the contribution of factors affecting various
measures.
- Assess the impact of attributes (e.g., physicians, departments,
practice locations) on measures at both summary and drill-down
levels.
- Serve as a subject matter expert in clinical informatics,
providing advanced technical support and troubleshooting.
- Lead the development and implementation of the organization's
clinical information systems and tools, ensuring they align with
the needs of ambulatory operations.
- Collaborate with business, technical, and clinical leaders to
plan, develop, implement, and analyze complex clinical informatics
systems.
- Design integrated architecture to ensure optimal user
experience, functionality, integrity, and reliability of
systems.
- Manage the operational analytics program life cycle through
initiation, planning, validation, execution, and deployment.
- Lead project teams, including advanced business and clinical
staff, to improve clinical informatics results and provide
sophisticated metrics and analytics to support management's
decision-making processes.
- Provide operational analysis and calculate physician
productivity; produce the PSRA Summary Report.
- Produce monthly Tableau dashboards for senior department
leadership and ambulatory operations directors, focusing on
referral leakage, KPI metrics, new patient lag days, exam room
utilization, and financial and operational trends.
- Assist in the collection of data from clinic and division
Managers, Operations Directors, Departmental Finance, and other
offices.
- Collaborate with stakeholders to understand business needs for
reporting requests. Gather requirements, document, clarify, and
interpret specifications, reviewing for completeness and
accuracy.
- Work closely and collaboratively with end-users and other
stakeholders to ensure the right reporting tools are used to
maximize value.
- Provide guidance to other team members to promote the use of
published data reports.
- Work with end-users to resolve problems promptly, ensuring
tasks are completed with quality and within expected
timeframes.
- Provide ongoing user training and produce and deliver user
training curricula. Salary range: $102500- $227700 Qualifications
Required Skills:
- Minimum of 3+ years of experience in a healthcare-related
organization.
- Minimum of 5+ years of experience in data architecture with
strong SQL programming skills (MS T-SQL and/or Oracle PL/SQL).
- Bachelor's degree in healthcare information technology,
computer science, or a related area, or equivalent combination of
experience and training.
- Proficient understanding of controlled terminology, clinical
workflows, user interface optimization, clinical decision support,
rules development, data integration and mining, clinical
ontologies, and the adoption of technology in healthcare
settings.
- Advanced organizational and project management skills,
including the ability to lead teams, prioritize tasks, and manage
projects from inception to completion, ensuring timely
delivery.
- Strong interpersonal communication skills, with the ability to
clearly and concisely convey highly technical information to all
levels of clinical users, provide technical support, and develop
and deliver training materials as needed.
- Advanced problem-resolution skills, capable of diagnosing
complex issues quickly and implementing effective solutions in a
timely manner.
- Expertise in analytical skills, documentation, and reporting,
with the ability to apply metrics, design and run queries, collect
and analyze performance data, and produce sophisticated reports for
management use.
- Proven ability to serve as a technical leader and information
resource, working collaboratively with senior staff and management
across departments to provide advice, counsel, and analysis on
policy, system functionality, efficiency, upgrades, business
analytics, and industry trends. Preferred Skills:
- 2+ years of experience in Tableau.
- Experience with Python.
- Experience with Databricks.
- Experience with Azure DevOps.
- Experience with Microsoft Forms.
- Experience with Power Automate.
- Experience with Microsoft Visual Studio.
- Experience with Git.
#J-18808-Ljbffr
Keywords: American Health Quality Association, Azusa , Business Intelligence Developer, Ambulatory Transformation and Performance, IT / Software / Systems , Los Angeles, California
Didn't find what you're looking for? Search again!
Loading more jobs...