EPIC Business Systems Analyst (Data Analyst)

Job Description

Sea Mar Community Health Centers, a Federally Qualified Health Center (FQHC) founded in 1978, is a community-based organization committed to providing quality, comprehensive health, human, housing, educational and cultural services to diverse communities, specializing in service to Latinos in Washington State. Sea Mar proudly serves all persons without regard to race, ethnicity, immigration status, gender, or sexual orientation, and regardless of ability to pay for services. Sea Mar's network of services includes more than 90 medical, dental, and behavioral health clinics and a wide variety of nutritional, social, and educational services. We are recruiting for the following position:

Sea Mar is a mandatory COVID-19 and flu vaccine organization

EPIC Business Systems Analyst II (Data Analyst) – Posting #23539-01

Position Summary:

Full-time on-site position available immediately in South Park, Seattle. Experienced Epic Business Systems Analyst with primary area of responsibility in support of health information and practice management systems. Data analysis and report generation in support of internal and external reporting requirements. Create ad hoc query reports based on the requirements provided by the users and design reports using SSRS when required. Build developer test cases to ensure compliance with business requirements prior to user acceptance testing. Working knowledge of data warehouse concepts.

Essential Duties and Responsibilities

• Experienced business systems analyst with primary area of responsibility in support of Epic Solutions medical records systems.
• Play a key role in the planning, development and production of performance reports and interactive analytic applications addressing health quality and resource use for the Organization.
• Support the design and development of advanced analytic and reporting capabilities using Microsoft’s Business Intelligence Tools.
• Support the creation and maintenance of business intelligence design standards and best practices.
• Collaborate with business subject matter experts, business analysts from other disciplines to come up with end to end solutions to meet assigned business requirements.
• Identify technical issues that arise and work with project teams and associated stakeholders to address and resolve issues.
• Develop technical documents related to performance reports including technical specifications, issue briefs, write-ups of technical items for committee consideration.
• Assist with the development and preparation of project plans and schedules.
• Provide daily and ongoing technical support as required by the user community: Interface between end users and vendor support to resolve technical issues; provide end-user support as required for daily functional activities; track issues and change requests; submit, manage and track escalated issues with vendor technical support; monitor application operations; and maintain data (clear tables, check transaction logs, validate interfaces to other applications (pharmacy, labs, accounting, etc.)
• Report development. Maintain and document existing recurring and one-time reports, changes to reports and new reports. Maintain version control of all reports and their associated code.
• Data analysis and report generation in support of internal and external reporting requirements
• Provide training and direction as required by the user community: Prepare training documentation for end -user support as required; conduct end -user training as required.
• Process Improvement: Install, configure, and maintain application modules as required in coordination with vendors and the IT team. Perform related upgrades, apply patches, define security roles and standards, migrate and convert data in coordination with vendors and the IT team.
• Install, configure, and test new product introductions. Provide test scripts and procedures to ensure compliance with current standards and procedures.
• Develop and maintain forms. Responsible for maintenance of current forms and design and development of new forms in EHR and PM applications. Maintain and document all forms, changes to forms and additional new forms. Maintain version control of all forms and their associated code. Maintain the EHR/PM software with respect to revisions and updates, including but not limited to functional testing of upgrades.
• Recognize and identify potential areas where existing policies and procedures require change or where new ones need to be developed.
• Assist in presentations to management and/or team members in order to propose projects, plans or ideas. Perform business process analysis with respect to systems, and devise cost-effective solutions based on current and future technology.
• Ensure that applications meet business requirements and fulfill end-user needs.
• Extensive direct vendor coordination of patches and updates as well as escalation of production issues for resolution.
• Build developer test cases to ensure changes in the system are in compliance with business requirements prior to user acceptance testing.
• Collaborate with system and network administrators to identify and resolve systems issues.
• Collaborate in testing new application services.
• Research and make recommendations on software products and services in support of development efforts, and assist in contract negotiations as needed.
• Develop curricula, training plans, and training schedules, and provide training and documentation for end users, primarily for EMR/EHR and PM application services. Provide assistance to business owners with development of training plans and curricula for other applications as appropriate.
• Develop, distribute, and coordinate in-depth end-user reviews for modified and new systems and applications.
• Cultivate and disseminate knowledge of best practices for application usage.

Qualifications – Required

• 3+ year’s EPIC clinical/patient database application support.
• 1+ years of experience with EPIC Cogito RWB/Radar reporting and report creation.
• Demonstrated understanding of T-SQL and T-SQL reporting in SQL Server or related RDBMS.
• Familiarity with client/server technology, LANs, end user reporting tools.
• Excellent skills with Microsoft Office products.
• Demonstrated history of working successfully as a team member.
• 1+ years’ hands on experience with SQL Server, SSAS, SSIS, SSRS, SharePoint, Excel Services.
• Knowledge of and experience with VB, PowerBI, SharePoint Report Builder highly desirable.
• Experience creating compelling and meaningful end-user reports displaying health quality and cost information for a wide range of audiences.
• Strong analytic and quantitative aptitude, including an understanding of statistics.
• Ability to work effectively on multiple complex projects simultaneously, manage multiple deadlines.
• Excellent oral and written communication skills including ability to communicate complex ideas in a simple way.
• Demonstrated ability to execute on cross-organizational initiatives.
• Self-directed; a self-starter who can work with minimal supervision.
• Strong inter-personal skills and poise to interact with senior leaders.
• Technical and detail oriented.

Qualifications - Desired

• Competence with testing, flowcharting, and data mapping tools and procedures.

Education and/or Experience – Required

• Bachelors or Master’s Degree in Computer Science, Business Administration or related discipline or equivalent work experience,
• EPIC Certification REQUIRED; Cogito, Clarity, Caboodle preferred
• 2+ years of experience with system integration.
• 2+ years of experience with reporting and report creation.
• 3+ years’ experience in data warehouse development, dimensional modeling, OLAP, ETL design
• 3+ years’ hands on experience with SQL Server 2005/2008, SSAS, SSIS, SSRS, SharePoint, Performance Point, Excel Services
• Experience creating compelling and meaningful end-user reports displaying health quality and cost information for a wide range of audiences

Education and/or Experience – Desired

• Microsoft Certified Professional (MCP)
• Knowledge of applicable date privacy practices and laws including HIPAA and JCAHO
• EMR/EHR experience and/or training

What We Offer:

Sea Mar offers talented and motivated people the opportunity to work in a dynamic and growing community health organization. Working at Sea Mar Community Health Centers is more than just a job, it’s a fulfilling career with opportunity for advancement. The fringe benefits surpass most companies. For example, Full-time employees working 30 hours more, receive an excellent benefit package of Medical, Dental, Vision, Life Insurance, Prescription coverage, Long Term Disability, EAP (Employee Assistance Program), paid-time-off starting at 27 days per year + 10 paid Holidays. We also offer 401(k)/Retirement options and an exciting opportunity to work in a culturally diverse environment.

How to Apply:

To apply for this position, complete the online application and click SUBMIT or APPLY. If you have any questions regarding the position, email, Rich Dixson-M'Ricerd, Applications Manager at [email protected]

Sea Mar is an Equal Opportunity Employer

Posted 05/05/2022

Please visit our website to learn more about us at www.seamar.org. You may also apply thru our Career page at https://www.seamar.org/jobs-general.html