Sr. BI Developer - Access and Revenue - Vancouver Clinic

• Participates in teams supporting high visibility strategic initiatives, including process improvement, clinical initiatives, strategic business line initiatives and financial initiatives.
• In-depth knowledge of end user workflows, clinical systems, and operations, with a primary focus on optimizing EPIC reporting metrics and reporting tools, primarily for Epic Cadence and Epic Professional Billing modules.
• Assists in the overall integrity of the CDM (Charge Master) with a focus on accuracy, revenue cycle integrity, and compliance with payer requirements.
• High degree of independent work as well as team collaboration to identify appropriate reporting solutions for end user needs, and ensures consumer satisfaction with reporting solutions.
• Design, create, test, validate, deploy, and maintain systems and reports to support patient care, revenue cycle and strategic initiatives.
• Builds Radar dashboards, Reporting Workbench reports, Crystal reports, Tableau reports, operational tools, creates custom SQL metrics, and assists in maintaining Analytics Catalog, as well as modifying existing reporting.
• Subject matter expert for self service and other analysis and reporting tools such as Tableau, Radar Dashboards, Reporting Workbench, Power BI etc.
• Demonstrates excellent communication and formatting skills to share data and transform into actionable information in an understandable manner.
• Develops and maintains appropriate documentation on all work products. Develops standard work as appropriate.
• Maintains the daily routines of organization's analytics data warehouse to support scheduled reporting and business reporting outside of EPIC.
• Evaluates SSIS ETL's to trouble-shoot automated reporting build between systems.
• Audits peer reports and reviews upgrade documentation related to Clarity features and Crystal reporting to determine how best to implement changes.
• Make recommendations to clinic leadership and teams on analytical approach to strategic projects; what questions to ask, what data to review and how to best analyze and report data to make decisions.
• Maintains highly effective partnerships with IT, Analytic partners, Finance, Operations, Population Health.
• Perform other related tasks as assigned.

SKILLS AND ABILITIES:

• Ability to perform complex mathematical calculations.
• Demonstrated ability to work independently and take initiative in areas of responsibility.
• Proven ability to communicate effectively, both written and verbal.
• Proven ability to analyze business reporting requirements and systems functionality to develop and support reporting systems.
• Ability to maintain a positive disposition and interact with individuals as well as groups.
• Proficiency with MS Office Suite software required.
• Advanced Microsoft Excel and Access skills including external data connections and PowerPivot development experience.

EDUCATION AND EXPERIENCE:

• High School diploma or equivalent.
• Bachelor's degree in Engineering, Physics, Computer Sciences, Math, Information Systems, Statistics, related field or equivalent work experience.
• Minimum of five (5) years with BI tools, preferably Epic reporting tools such as Radar Dashboards, Reporting Workbench, MS SQL, SAP Business Objects Crystal Reports, Cubes, and Tableau.
• Minimum five (5) years data analysis experience with respect to identifying and defining source data using SQL or data profiling tools.
• Minimum of (5) years of healthcare industry experience focused in Patient Access and/or Revenue using Epic BI tools (such as Radar dashboards, Reporting Workbench, Slicer Dicer).

Pay Range:
$93,850.00 - $140,775.00

The above information is intended to indicate the general nature and level of work required in this position. It is not designed to contain or be interpreted as a comprehensive description of all duties, responsibilities, and qualifications required of those assigned to this job.

We offer a competitive Total Rewards Program. Eligibility for benefits is dependent on factors such as position type and FTE. Benefit-eligible employees qualify for benefits beginning on the first of the month following one month of employment. Vancouver Clinic offers medical, dental, vision, life insurance, AD&D, long term disability, health savings account, flexible spending account, employee assistance program, and multiple supplemental benefits (voluntary life, critical illness, accident, hospital indemnity, identity theft protection, legal services, etc.). We also offer a 401k retirement plan, with employer contributions after your first year of employment. Benefits-eligible employees accrue PTO and Personal Time based on hours worked and State worked, totaling 120 hours in the first year for full time staff and 200 hours in the first year for full time supervisors and above, increasing in subsequent years. PTO and Personal Time accruals are pro-rated by FTE/hours worked. Non-benefits eligible employees will accrue Personal Time based on hours worked and State worked. Employees will also enjoy up to six paid holidays per year, depending on schedule. Contact your recruiter for more information.

Vancouver Clinic is proud to be an Equal Opportunity Employer. Vancouver Clinic does not discriminate on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, gender identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law.

Vancouver Clinic is an alcohol and drug-free workplace. Offers are contingent on successful completion of background screen and immunization requirements.