Title: Epic Caboodle Developer

Location: Portland, OR

Job Type: Temp/Contract- on site

Job Description

This is a fantastic 7+ month contract opportunity with Oregon's most prestigious medical companies. Join an enterprise project leveraging SAP Business Objects Web Intelligence, Information Design Tool (Universe Development), and knowledge of SQL Server T-SQL, this position is responsible for working with Client Finance and ITG’s Business Intelligence and Advanced Analytics Teams to transition reporting from our Epic Clarity instance on Oracle RDBMS to Epic Clarity and Caboodle on Microsoft SQL Server RDBMS.

The ideal candidate will have prior healthcare or finance/accounting department data experience, preferably in a healthcare organization that utilizes Epic Systems Electronic Medical Record System.

Experience with Epic Clarity and Caboodle Data Warehouse is strongly desired. Beyond technical skills, English communication skills sufficient to capture requirements from customers shared in verbal and written form and translate these into business intelligence solutions using Business Objects Universes and Web Intelligence is necessary for success in this role.

Strong collaboration with hospital finance and ITG in order to capture requirements and execute these through iterative development approaches such as Agile are hallmarks of this position.

  • BI Systems Engineering/User Support: Develops Business Objects, T-SQL (SQL Server) and Epic BI solutions that provide robust end user layers for adhoc reporting use, visualizations, advanced dashboards, reports, and stories. Business Objects: Universe Design (information design tool), Web Intelligence and Crystal. Works closely with other CLIENT IT staff to meet expectations for design reviews and coding standards. Provides issue resolution during Quality Assurance / User testing. Assists with the move to production/implementation process. Work through established processes to resolve any system or data problems and communicate updates and status to affected groups. Recommend changes to ETL processes and/or the data warehouse model to improve existing structures and code to increase reliability and efficiency. Provides technical expertise to support end users developing ad-hoc queries and departmental reports. Support could include consulting on techniques/best practices, troubleshooting of their solutions, working with clinicians and Epic developers to improve user interfaces and templates for improved reporting, and promotion of user developed solutions to Quality Assurance and Production. Respond to and track issues using HP Service Manager issue management tools. Gather additional information from the customers. Triage the issue and resolve or escalate by involving additional team members as required.

  • System Analysis: Work with data warehouse architects, line of-business analysts and users to gather detailed requirements for and provide input into the design of Business Objects and Epic reports, visualizations, advanced dashboards, analyses, and adhoc end user layers. Work with BI Architects, Developers, Analysts and users to design, create and publish ETL processes and ETL metadata using SQL Server SSIS and other tools. Provide complete and consistent documentation of data warehouse content and ensure that users can determine what data is available in the warehouse, how this data is defined, how key metrics are defined and analysis is performed. Facilitate customer requests for new or changed solutions. Develops options with recommendations, creates functional specifications including performance requirements, and test plans to confirm delivered functionality.
  • Project and Systems Management: Will fully understand and utilize the System Development Life Cycle (SDLC) process and procedures. Will manage projects by creating timelines, identifying risks and milestones, and providing status reporting to others as defined. Provide support to data warehouse developers, line-of-business analysts and users to validate data in the data warehouse. Investigate and report on problems and work to ensure the validity of the data warehouse. This could include scheduling reports and dashboard refreshes in Business Objects Scheduler, Tableau, Microsoft SSIS, ActiveBatch or other scheduling tools. Use an approved query tool (SQL Developer, etc.) to identify data quality and data relationships to assist with the design of efficient and effective reporting solutions. Provide support to fellow data warehouse developers, line-of-business analysts and users to validate data in the data warehouse. Investigate and report on problems and work to ensure the validity of the data warehouse.
  • Data Modeling: Work with data warehouse developers, line-of-business analysts and users to develop data structures and data marts that support and enhance information access, analysis and reporting.

Required Qualifications

  1. Epic Caboodle Proficiency or Certification is required The ideal candidate will also possess a good understanding of Epic Resolute billing processes, Epic Clarity Resolute HB and PB data structures, healthcare terminology, and the data model of Epic Caboodle Data Warehouse.
  2. Bachelor’s degree in business or computer science or related field and six years work related experience in the information technology field
  3. Minimum two years paid work experience as an Application Engineer (or equivalent classification) using Business Objects
  4. Two years experience with developing Business Objects Web Intelligence reports and dashboards
  5. Two years experience with developing Business Objects Universes using the Information Design Tool (IDT)
  6. Experience with facilitating and documenting system requirements sessions
  7. Experience gathering and documenting business requirements
  8. Experience creating technical documentation of reports and data/report models
  9. Experience with utilizing star schema data stores as the basis for report development
  10. Minimum three years working with SQL Server T-SQL, including tuning of queries
  11. Proven communication, analytical, and problem solving skills
  12. Experience with Systems Development Life Cycle (SDLC) processes and procedures and/or Agile development
  13. Ability to read and explain a data model
  14. Experience gathering and documenting business requirements
  15. Knowledge of data warehousing architecture and dimensional modeling concepts
  16. Ability to read, write and maintain SQL code at an advanced skill level
  17. Exceptional customer service skills - both in person and on the phone.
  18. Exceptional interpersonal skills - able to resolve conflicts and to problem solve between parties.
  19. Demonstrated evidence of strong (English) written and verbal communication skills
  20. Ability to manage competing priorities. Ability to meet deadlines and urgent patient and system needs.
  21. Ability to work independently; willingness to serve as a positive and professional role model.
  22. Must have demonstrated record of reliable attendance, punctuality and proven successful performance in past and present.