Epic Business Intelligence Analyst I

Title: Epic Business Intelligence Analyst

Location: Administrative Office

City: Bellingham, WA

Position: Full-time, 40 hours/week, Monday to Friday, 8:00am – 4:30pm, non-exempt (hourly)

Job Summary:

The overarching goal of the position is to analyze clinical data for the purpose of imagining, proposing, and implementing missed or newly realized opportunities for Family Care Network. Under general supervision, the Epic Business Intelligence Analyst (BIA) creates analytic content for end users and third parties who require Epic data. The BIA will extract clinical and financial data from disparate sources, inspect, clean, and model the data to identify potential business opportunities for further exploration.

Compensation: The full wage scales are as follows:

Epic Business Intelligence Analyst I is $31.70 to $47.58.

Epic Business Intelligence Analyst II is $32.97 to $49.48.

Epic Business Intelligence Analyst Senior is $34.24 to $51.38

• Placement within the wage range is determined by the candidate’s relevant experience.

Benefits: At FCN, we offer a comprehensive benefits package designed to support your well-being and that of your family, with flexibility and quality care.

Health Benefits:

• Two Medical PPO plan options
• Flexible Dental coverage, including orthodontia for children and adults
• Employer-paid Vision coverage for employee and family members
• Expanded Employee Assistance Program (EAP) and mental health programs, including wellness and discounted gym memberships
• Flexible Spending Account (FSA), Healthcare and Dependent Care
• Health Savings Account (HSA) with an employer contribution of $1,500 (pro-rated based on enrollment eligibility)
• Health Reimbursement Account (HRA), up to $1,500 ($3,000 for family coverage)
• Employer-paid Life/AD&D insurance with optional supplemental additional coverage including a guaranteed issue amount with no health questionnaire
• Voluntary Accident and Hospital insurance plans with annual wellness benefits
• Eligibility for these benefits depends on your full-time or part-time status.

Time Off & Wellness:

• Paid Time Off (PTO), Paid Sick Leave (PSL), and Extended Illness Bank (EIB) to support your vacation, health, and personal needs
• PTO, PSL, and EIB accrue starting on your first day, and you can use paid time off after the applicable days of employment
• Full-time employees generally begin earning 18 days of PTO, increasing 33 days over time per our PTO policy. You can rollover unlimited PTO hours into the next year.
• PSL accrues at 1 hour per 40 hours worked
• EIB accrues up to 32 hours per year (pro-rated based on hours worked) for both part-time and full-time employees, with a maximum of 480 hours

Retirement:

• 401(k) plan with employer match, both Traditional and Roth options available
• 401(k) Profit Sharing Plan
• Free financial planning guidance to support your retirement goals
• Eligibility for these programs is based on your years of service and required hours.

Additional Benefits:

• Eligibility for FCN applicable bonuses
• Annual uniform allowance for clinical staff
• Reimbursement of renewal fees for required licensure for clinical staff

About FCN: As an independent, locally owned, physician-run network of family medicine providers, we are passionate about our community's well-being. We take the time to build strong, long-term relationships with our patients and our employees. We have 12 clinics and 3 urgent care centers in Whatcom and Skagit County, in a beautiful corner of northwest Washington where the mountains meet the sea.

Essential Job Functions

• Configures and tests Epic-released and Foundation System content for all applications including Reporting Workbench, SlicerDicer data models, Radar dashboards, and Cogito SQL
• Creates content to display Epic data from Chronicles, Clarity, and Caboodle.
• Writes SQL and configures Radar settings for customer metrics.
• Modifies and maintains reports, as necessary.
• Distributes analytics content to data consumers and reviews peer reports for accuracy.
• Collaborate with subject matter experts to understand user needs.
• Maintains the Analytics Catalog and associated metadata.
• Tests analytics build in test and live environments, including volume testing.
• Reviews upgrade documentation for Clarity and Caboodle; implement applicable changes.
• May be responsible for building and maintaining Cubes, Extracts, SlicerDicer custom filters, Third-party Business Intelligence (BI) tools and Custom Epic data in Caboodle.
• Develops, maintains, and performs processes to monitor data quality and integrity.
• Conducts internal and external data validation.
• Coordinates with external and internal partners to verify clinical data relevance.
• Identifies and evaluates external data sources relevant to FCN initiatives.
• Critically evaluates information gathered from multiple sources, reconciles conflicts and decomposes high-level information into details.
• Acts as technical advisor for strategic planning.
• Manages support requests and administrative needs.
• Seeks guidance and asks questions in a timely and appropriate manner.
• Maintains reliable attendance and punctuality.
• Participates in assigned company projects.
• Performs other duties as assigned.

Knowledge, Skills & Abilities

• Analytical mindset with exceptional critical thinking and problem-solving skills.
• Excellent communication, business writing, and presentation abilities.
• Proficiency with SQL and relational database concepts
• Proficiency and demonstrated experience with analytics tools.
• Familiarity with Epic applications and database structure; ability to learn data models relevant to specific content areas.
• Understanding of the data model through data model classes,
• Ability to understand data structures that could benefit the entire data environment.
• Desirable (but not required) experience with AR systems for financial reports and EMR systems for clinical reporting.
• Ability to apply business and systems process knowledge in analysis and solution development.
• Proficient with technology including Microsoft Office, database systems, data imports, report generation, records management.
• Ability to lead initiatives and balance technical capability, cost, and timelines with business needs.
• Strong organizational and project management skills.
• Understanding collaborative quality improvement and quality assurance.
• Knowledge of emerging industry practices for solving business problems.
• Capable of managing multiple tasks, prioritizing deadlines, and working independently or within teams.
• Effectively collaborate with physicians, executives, managers, and subject matter experts.
• Maintains confidentiality and professional conduct (e.g., HIPAA, proprietary information).
• Resilient under stress, with a customer-focused approach.
• Works as part of a team, models a positive work ethic and customer friendly relations.
• Accurately comprehends and conveys information verbally and in writing.

Epic Certification/Accreditation & Training Requirements

FCN is committed to investing in the growth and professional development of our all of team. As part of that commitment, we cover the cost of Epic training and certification or accreditation for the BID.

If the BID is not already Epic certified or accredited prior to hire, FCN will provide training at the appropriate time, based on readiness, demonstrated aptitude, and the Epic training schedule. Once training is completed, the BID will have the opportunity to earn the Epic certification or accreditation. While FCN is committed to supporting staff through the certification process, including offering up to two additional attempts if needed, certification is an essential requirement for this role. If a staff member is ultimately unable to achieve certification, FCN may determine that the individual is not able to meet the qualifications necessary for continued success in the position.

If the BID is Epic certified/accredited prior to hire, FCN will determine if additional Epic training is required to assure proficiency or currency in the new assigned role and may provide Epic training at the organization’s discretion.

Training Requirements – The Business Intelligence Developer attends the appropriate course track as designated by Epic and Family Care Network.

Education & Experience:

• Bachelor’s degree in Engineering, Physics, Computer Science, Math, Information Systems, Statistics, or a related field.
• Minimum 2 years previous Data and Business Developer or Business Intelligence Developer experience preferred.
• Healthcare experience preferred.
• Epic certification/accreditation within 2 years of employment.

Physical Requirements:

While performing the duties of this job, the employee is occasionally required to: stand; walk; sit; use hand to finger coordination, handle or feel objects, tools, or controls; reach with hands and arms; climb stairs; balance, stoop, kneel, crouch; talk or hear. The employee must occasionally lift and/or move up to 30 pounds. Specific vision abilities required include close vision, peripheral vision, depth perception and the ability to adjust and focus.

Immunization Requirements:

Employees are required to meet immunization standards in accordance with federal, state, and organizational health and safety guidelines, as applicable to the role. A simple process is in place for employees to request exemptions for medical or religious reasons.

Family Care Network is a Drug-Free, Equal Opportunity Employer.