Business Systems Programmer/Analyst

UW Medicine   •  

Seattle, WA

Industry: Healthcare

  •  

5 - 7 years

Posted 24 days ago

UW Medicine’s mission is to improve the health of the public by advancing medical knowledge, providing outstanding primary and specialty care to the people of the region, and preparing tomorrow’s physicians, scientists and other health professionals. UW Medicine owns or operates Harborview Medical Center (HMC), Northwest Hospital & Medical Center (NWH), Valley Medical Center (VMC), UW Medical Center (UWMC), a network of UW Medicine Neighborhood Clinics (UWNC) that provide primary care, UW Physicians, UW School of Medicine, Airlift Northwest, and other owned, operated or affiliated entities as appropriate. In addition, UW Medicine shares in the ownership and governance of Children’s University Medical Group and Seattle Cancer Care Alliance a partnership among UW Medicine, Fred Hutchinson Cancer Research, and Seattle Children’s.

UW Medicine Finance Business Systems has an outstanding opportunity for a Business Systems Programmer/Analyst. This individual reports to the Finance Business Systems (FBS) Director and works directly with UW Medicine Accounting, Finance, Supply Chain and IT staff to analyze accounting and financial data and processes and to create, enhance, debug, test, deploy and support financial systems used at UW Medicine. The primary functions of this role are to analyze business processes, extract and analyze data sets and then use that information to create, correct, extend and improve system automation for FBS customers. The person in this position also provides application and technical support for custom and vendor financial system applications and integrations supported by FBS.

DUTIES & RESPONSIBILITIES:

  • Interface with business customers and colleagues to understand business processes and to support and enhance existing automations
  • Creation of complex SQL to extract data from multiple tables and/or databases for reporting, interfaces, visualizations
  • Perform data analysis to isolate and correct problem data, problem SQL, and problem automations
  • Design and create ETL packages to automate data manipulation processes
  • Create interface programs to move data between systems
  • Create visualizations to replace reports
  • Write thorough documentation as new processes are created or older ones are modified



REQUIREMENTS:

Bachelor's degree in Computer Science or Business Administration AND at least five years of experience to include:

  • 5+ years working withfinancial systems, preferably Allscripts ERP HEFM/HEMM or another ERP system within the healthcare field.
  • 5+ years as an applications analyst, business systems analyst applications analyst or programmer
  • 3+ years of data analysis and MS SQL Server experience including SSIS and SSRS
  • 2+ years developing reports in SSRS, Crystal Reports, BOE or a similar tool
  • 2+ years of programming experience using VB.NET or C#
  • 2+ years developing data visualizations
  • 2+ years developing and deploying SSIS ETL packages
  • Strong verbal and written communication skills
  • Demonstrated ability to build relationships and work effectively with management, end users and IT team members
  • An equivalent combination of education and experience may substitute for stated requirements.



DESIRED:

Experience

  • Financial applications experience in the healthcare industry
  • Project lead or project management experience
  • MS Access design and VBA programming experience
  • 2+ years of web programming experience
  • Advanced Excel design and VBA programming experience
  • Microsoft Powershell experience

164754