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 Business Systems Analyst - Posting #26394 Salary Range: $62,000 - $85,000 Position Summary: Full-time Business Systems Analyst position available at our headquarters in South Park, Seattle. Experienced Business Systems Analyst with primary area of responsibility in support of medical records 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 changes in the system are in compliance with business requirements prior to user acceptance testing. Working knowledge of data warehouse concepts. 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 topic 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 in order to demonstrate possible business trends. 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 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 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. Cultivate and disseminate knowledge of best practices for application usage. Qualifications Required Demonstrated SQL development with extensive experience in developing stores procedures, views, functions, triggers, and advanced logical methods. Knowledge and experience with VB, C#, ASP and/or MDX highly desirable. Strong analytic and quantitative aptitude, including an understanding of statistics. 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. SSRS/SSIS and Crystal Reports experience. Knowledge of and experience with VB, PowerBI, SharePoint Report Builder 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 preferred. Detailed oriented and demonstrated ability to work effectively on multiple complex projects simultaneously, managing multiple deadlines. Desired Competence with testing, flowcharting, and data mapping tools and procedures. Education, Certificates, Licenses, Registrations, and Medical Screening Required Bachelor’s or Master's degree in Computer Science, Business Administration, or related discipline or equivalent work experience. 3+ years EHR/PM application support or closely related medical/dental applications. 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 4+ 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 + + MCP knowledge of applicable data privacy practices and law including HIPAA and JCAHO Misys or Allscripts 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 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 24 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 NOW.

If you have any questions regarding the position, email Maryna Miles, Business Systems Analyst Manager, at marynamiles@seamarchc.org. Sea Mar is an Equal Opportunity Employer Posted 5/7/2024 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 Powered by JazzHR