Sr. BI Developer - Access and Revenue - Vancouver Clinic

Possesses detailed knowledge of technical solutions to assist in creating and providing high quality data, reports, and analysis. Must possess knowledge of healthcare and clinical operations, with a primary focus on clinician access and healthcare revenue cycle high visibility initiatives.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:

• 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.
• 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.
• 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.
• Maintains highly effective partnerships with IT, Analytic partners, Finance, Operations, Population Health.

• Ability to perform complex mathematical calculations.
• Proven ability to analyze business reporting requirements and systems functionality to develop and support reporting systems.
• Advanced Microsoft Excel and Access skills including external data connections and PowerPivot development experience.

EDUCATION AND EXPERIENCE:

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