Epic Business Systems Analyst

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

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 systems. The responsibilities include, but are not limited to, data analysis and management reporting, utilizing software to generate metrics, data discovery applications, dashboards, and scorecards. 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

Duties and Responsibilities:

As a mission-driven organization, the core values of and the services offered at Sea Mar are based on the belief that everyone deserves to be respectfully treated in a way that preserves dignity and enhances self-worth. Sea Mar is an advocate for its clients and aims to achieve industry-leading, client-centered, culturally aware services. 

Sea Mar employees serve as an extension of this mission and demonstrate their commitment to an excellent client experience by:

• Understanding and empathizing with client needs
• Surpassing client expectations
• Demonstrating a high level of integrity
• Exhibiting compassion and commitment
• Advocating for social justice
• Taking pride in individual work as well as that of the team
• Continually learning to stay current with industry standards, best practices, and technology

As a Sea Mar employee, the individual in this position commits to adherence to these values to their utmost ability and endeavors to strengthen and embody this mission daily.

Essential Duties and Responsibilities:

• 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.)
• Perform data analysis functions across large data sets, encompassing multiple key measures and long-term trend analysis.
• Ensure that analysis and reporting solutions meet client (business owner) and departmental design requirements.
• 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.
• Design, build and deploy actionable reporting solutions while following established standards and working independently.
• Support the design and development of advanced analytic and reporting capabilities using Microsoft’s Business Intelligence Tools.
• Develop customized (ad hoc) analysis and reporting solutions as required by Operation and build automated solutions when appropriate.
• Support the creation and maintenance of business intelligence design standards and best practices.
• Collaborate with subject matter experts and business systems analysts to create end to end solutions which meet assigned business requirements.
• Develop collaborative partnerships with departments and business units to determine project requirements, achieve results, and improve performance, utilizing pragmatic and agile analysis and development principles to document and track project requirements.
• Identify and troubleshoot technical issues and work with stakeholders to resolve them.
• Write technical documents related to performance reports, including technical specifications, issue briefs, and review of technical topics for Organizational consideration.
• Assist with the development and preparation of project plans and schedules.
• 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.
• Monitor significant changes to key business statistics and performance indicators to demonstrate possible business trends.
• Perform related upgrades, apply patches, define security roles and standards, and migrate and convert data in coordination with vendors and the IT team.
• Install, configure, and test new products as required. Provide test scripts and procedures to ensure compliance with current standards and procedures.
• Participate in and coordinate the design and implementation of data collection, cleansing, and analysis. Assist in technical presentations to management and/or team members
• 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 comply with business requirements before user acceptance testing.
• Collaborate with system and network administrators to identify and resolve system 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.
• Cultivate and disseminate knowledge of best practices for application usage.

Qualifications:

Required

• 2+ years of EPIC clinical/patient database application support.
• 1+ years of experience with EPIC Cogito RWB/Radar reporting and report creation.
• 3 years’ experience in enterprise and business information system development, solution engineering, project management, and information application design and development
• 3 years’ experience in the development of BI strategies and associated policies.
• 2 years of experience in an analytics or development setting (data analysis/data visualization, graphic design, working with translating data into effective visualization); healthcare industry experience preferred.
• Demonstrated understanding of T-SQL and T-SQL reporting in SQL Server or a related RDBMS.
• Familiarity with client/server technology, LANs, and 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, Power BI, and SharePoint Report Builder are highly desirable. Experience working with healthcare systems, including Epic.  Knowledge of business objects and interfaces in hospitals and/or clinic settings or with a healthcare system vendor is preferred.
• Strong analytic and quantitative aptitude, including an understanding of statistics.
• Detail-oriented and demonstrated ability to work effectively on multiple complex projects simultaneously, managing multiple deadlines.
• Excellent oral and written communication skills, including the ability to communicate complex ideas to various audiences.  Presentation skills and poise are required to interact with operational and administrative groups.
• Self-directed; a self-starter who can work with minimal supervision.
• Strong interpersonal skills and poise to interact with senior leaders.
• Technical and detail-oriented.

Desired

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

Education, Certificates, Licenses, Registrations, and Medical Screening:

Required

• Bachelor’s / master’s Degree - Computer Science, Business Administration, or related discipline, or equivalent work experience,
• Bachelor’s degree - Computer Science, Healthcare Informatics, or advanced technical equivalent certifications and/or experience
• EPIC Certification REQUIRED; Cogito, Clarity, Caboodle preferred
• 2+ years of experience with system integration.
• 2+ years of experience with reporting and report creation.
• 2+ 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

Desired

• Health care applications analysis experience
• Knowledge of applicable data privacy practices and laws, including HIPAA and JCAHO
• EMR/EHR user support and/or training

Additional Requirements:

• Pre-hire annual employee health screening and TB test
• Annual influenza and Covid-19 vaccine required.  
• TB testing annually.

Salary Range: $80,000 - $105,000

Work Environment:

Standard office/technology work environment. Noise level in the work environment is usually low to moderate.  The employee may be required to share workspace with other employees. There is adequate lighting and equipment.  On-call availability required.

Physical Requirements:

Repetitive motions of hands/wrists. Sitting for extended periods. Must be able to lift/move up to 50 pounds. Occasionally required to climb or balance and stoop, kneel, crouch, or crawl. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Occasional lifting, bending, or carrying.

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 or more, receive an excellent benefit package of:

• Medical
• Dental
• Vision
• Prescription coverage
• Life Insurance
• 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. 

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