Title: Epic Cogito SQL Administrator

Location: Administrative Office – IT Department

City: Bellingham, WA

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

Compensation: The full wage scale is $26.20 - $36.67 per hour starting, Once the applicant gains Epic Certification/Accreditation the full wage scale is $29.37 - $44.08. 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

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.

Join a team that cares. FCN is currently recruiting for individuals with a strong technical background to join our IT team and participate in the implementation and ongoing management of our new Electronic Health Record, Epic. We welcome interested candidates with Epic experience or those who have a similar relevant technical background that are seeking to learn and grow their knowledgebase.

Job Summary

The Epic Cogito Systems Administrator installs and maintains the Clarity Console and Caboodle Console used to transfer data nightly from the Epic operational database into the Clarity database, and then into the Caboodle database. They also monitor and ensure that the extract, transfer, and load ETL process is completed daily.

Family Care Network Standards

• Vision, Mission, and Goals: Actively supports the vision, mission, values, goals, and objectives of Family Care Network. Interacts with other individuals, groups, and/or departments in making the vision a reality.
• Policies and Procedures: Adheres to all company policies and procedures. Adheres to guidelines for HIPAA, WISHA and other State and Federal regulatory agencies.
• Professionalism: Demonstrates in interactions with patients, colleagues, outside vendors, attitude, demeanor, and communication style consistently supports values and standards.
• Effective Communication skills: Demonstrates ability to communicate with patients, colleagues, and outside vendors in an appropriate, courteous, and respectful manner.
• Documentation: Consistently documents all pertinent information in all forms of electronic records accurately and concisely, in accordance with company guidelines.
• Compliance: Consistently adheres to all FCN Confidentiality and HIPAA policies and procedures regarding company and patient information.
• Team Responsibilities: Works to ensure success of company and of team members. Is accountable and takes ownership of opportunities, concerns, breakdowns, and results. Works collaboratively while evoking and producing trust. Anticipates, plans, learns, and innovates. Adheres to team standards and contributes to the team mood for success.

Essential Job Functions

• Verifying that the Clarity and Caboodle ETL processes are completed daily.
• Verifying that the SlicerDicer JumpStart is completed daily.
• Troubleshooting and resolving Clarity and Caboodle ETL process errors.
• Working with the Cogito Database Administrator to ensure optimal performance and integrity of all ETL processes by maintaining Epic best practices.
• Installing, updating, maintaining, and troubleshooting the Clarity, Caboodle, SlicerDicer, BI RESTful, SSAS cubes, and Interconnectbased Cogito tools.
• Modifying the Clarity and Caboodle ETL processes to meet organizational reporting needs.
• Adding new Clarity tables and columns to the data model as needed.
• Moving custom Caboodle data model and ETL development to production by working with the Caboodle ETL Developer.
• Working with Business Intelligence Developers to provide data needed for reports.
• Responding to emergency and afterhours issues.
• Cross training in the roles and responsibilities of other IT team members to ensure adequate coverage for FCNs operational needs.
• Assisting IT team members in responding to general phone calls and documenting problems in ticketing system.
• Other duties as assigned.

Core Competencies

• Adaptability/flexibility: Demonstrating flexibility with respect to changing end-user business needs and priorities.
• Analytical skills: Gathering and analyzing of information, generating solutions, and identifying and evaluating the risks of each alternative.
• Critical thinking: Addressing requests and changes in an open-minded way and examining an idea from as many angles as possible.
• Dependability: Taking ownership of work activities and ensuring that they are completed accurately, efficiently and in a timely manner.
• Initiative: Recognizing projects or tasks that need to be completed, seeking out additional assignments or tasks, and helping others.
• Interpersonal Skills: Communicating clearly and concisely with end-users, project leadership and subject matter experts.
• Learning: Aptitude for learning new software and systems.
• Logical reasoning: Developing logical conclusions, inferences, and judgments based upon available data and facts.
• Problem solving: Seeking, logically examining and interpreting information from different sources for root cause analysis as well as issue resolution and prevention.
• Work ethic: Striving for competence and willingly put forth extra effort when necessary.

Knowledge, Skills & Abilities

• Windows Server administration experience or training.
• Ability to perform basic troubleshooting on Microsoft SQL Server, Windows Server, and IIS.
• Ability to create, understand, and follow processes to ensure successful execution of critical maintenance procedure.

Epic Certification/Accreditation & Training Requirements

If a staff member 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 organizations discretion.

If a staff member is not Epic certified/accredited prior to hire, FCN will provide Epic training at the appropriate timeframe based upon demonstrated aptitude, readiness for the training and the Epic training schedule. It is expected, that after the training is completed, the staff member will take the Epic Certification exam and become certified/accredited.

Although the staff member may be provided with up to two additional attempts to achieve certification/accreditation, if the employee is unable to do so, at the discretion of FCN, the staff member may no longer be considered qualified to meet the requirements of the position.

Training Requirements The Epic Cogito Systems Administrator attends the appropriate course track as designated by Epic.

Education & Experience:

• Computer Science Related Degree (CS, Network Engineering, Specialty Training)
• Epic Certifications a plus
• SQL DBA experience a plus
• Experience working in a medical environment a plus

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.