Providence Health & Services Senior EMR Business Intelligence Developer in Oregon
Providence St. Joseph Health is calling an Senior EMR Business Intelligence Developer to our location in Renton, WA.
We are seeking a Senior EMR Business Intelligence Developer to be accountable for the development and implementation of semantic data layers such as Business Objects Universes, custom database objects, third party data extracts, and report visualizations using Crystal Reports and Power BI. This position requires advanced SQL skills and extensive experience with the Epic Clarity database. This position will support EMR users - predominately PHS Community Technologies clients. Support will include client specific requests, major Epic initiatives, new client implementations, upgrades, and optimization projects. This position will work closely with Community Technologies clients to understand business requirements and provide high quality and relevant data solutions. This position will also work closely with Epic Applications and Informatics teams to ensure a seamless end user experience for data and analytics needs.
In this position you will have the following responsibilities:
Develop, implement and maintain data/technical architecture utilizing primarily Oracle SQL, Business Objects, and Toad. Requires understanding of full HI offerings (SQL Developer, Tableau, SAP HANA) to ensure duplicative solutions are not provided, and existing HI offerings are leveraged. Create Business Objects Universes and custom database objects required to build the underlying semantic layer for fulfilling business needs. Leverages detailed knowledge of performance data warehouse tuning techniques to manage system performance and capacity. Create functional requirements and technical specifications documentation.
Work closely with the end user to define requirements, understanding what is needed to answer the business question (which may be different from what is asked). Demonstrate an open willingness to listen and learn clinical or business needs, then create standard universes that are of excellent quality (as measured by performance, data integrity, following HI coding standards). Universes should also provide complex and integrated answers to a suite of questions.
Periodically review and update Universes, reviewing usage, optimizing for performance, and enhancing with new content to ensure continued relevance and tracking with regulatory, environmental and business changes.
Partner with the Strategic Data Consultants when reviewing new business requirements to inform and develop roadmaps with timelines for Universes. Updates should be on a predictable cadence to continually mature with the business.
Partner with EMR Business Intelligence Analysts and other HI teams to provide rich training content for the end user. Deliver presentations to business customers (or internal HI audiences) in a clear and concise way.
Demonstrate deep understanding of the technical aspects of applications and integrated tools, as well as client/server and host-based systems. Demonstrate deep understanding of all aspects of design, development an testing and best practices of enterprise relational databases (i.e., Oracle, SQL).
Demonstrate expertise in the application of data management practices, logical data design, data modeling and abstraction.
Develop a fluency in the HI 1-page summary to fully understand the scope of HI delivered solutions. Ensure all universe design enhances the suite of HI solutions (by avoiding duplication, and collaborating and communicating across teams).
Maintain current knowledge of Epic capabilities and roadmap, to ensure designed solutions are current and take the best advantage of Epic capabilities. Lead discussions and present conclusions and recommendations for technical design and approach.
Develop universes in accordance with relevant PHI and other security measures, given their self-serve nature and purpose. Ensure currency of understanding of the complex affiliation and business or legal partnerships of PSJH and the impact on the development and use of data.
Required qualifications for this position include:
Bachelor's Degree in Computer Science, Engineering, Information Services, Public Health, Business Management or equivalent education/experience.
5 years Healthcare setting or related field.
5 years Relational databases, SQL.
5 years Automated reporting tools.
5 years Epic Certification, or other relevant EMR certifications.
Preferred qualifications for this position include:
Master's Degree in Computer Science, Engineering, Information Services, Public Health, Business Management.
5 years Clinical, financial, or operational experience.
About the department you will serve.
Providence Strategic and Management Services provides a variety of functional and system support services for all eight regions of Providence St. Joseph health from Alaska to California. We are focused on supporting our Mission by delivering a robust foundation of services and sharing of specialized expertise.
We offer comprehensive, best-in-class benefits to our caregivers. For more information, visit
As expressions of God’s healing love, witnessed through the ministry of Jesus, we are steadfast in serving all, especially those who are poor and vulnerable.
Providence is a comprehensive not-for-profit network of hospitals, care centers, health plans, physicians, clinics, home health care and services continuing a more than 100-year tradition of serving the poor and vulnerable. Providence is proud to be an Equal Opportunity Employer. Providence does not discriminate on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, sexual identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law.
Job Category: Infrastructure
Other Location(s): Oregon-Beaverton, California, Oregon, Washington-Redmond, Washington-Seattle, Washington, California-Irvine
Req ID: 321029