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 automationsCreation of complex SQL to extract data from multiple tables and/or databases for reporting, interfaces, visualizationsPerform data analysis to isolate and correct problem data, problem SQL, and problem automationsDesign and create ETL packages to automate data manipulation processesCreate interface programs to move data between systemsCreate visualizations to replace reportsWrite thorough documentation as new processes are created or older ones are modifiedREQUIREMENTS:Bachelor's degree in Computer Science or Business Administration AND at least five years of experience to include:5+ years working with financial 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 programmer3+ years of data analysis and MS SQL Server experience including SSIS and SSRS2+ years developing reports in SSRS, Crystal Reports, BOE or a similar tool2+ years of programming experience using VB.NET or C#2+ years developing data visualizations2+ years developing and deploying SSIS ETL packagesStrong verbal and written communication skillsDemonstrated ability to build relationships and work effectively with management, end users and IT team membersAn equivalent combination of education and experience may substitute for stated requirements.DESIRED:ExperienceFinancial applications experience in the healthcare industryProject lead or project management experienceMS Access design and VBA programming experience2+ years of web programming experienceAdvanced Excel design and VBA programming experienceMicrosoft Powershell experienceStrengthsDemonstrates a balanced understanding of technological, operational and human dimensions in a business environment Credible presence with a professional image; develops trust quickly; highly collaborativeAble to communicate complex information to diverse audiencesCommitment to completing tasks with great attention to detail and with a routine, critical self-reviewTakes initiative in acquiring new skills and increasing proficiency for personal effectivenessHistory of successful interaction with all levels of personnel within an organizationEffective written and oral communication with internal as well as external customersRecord of strong analytical skills being practically appliedPersonal philosophy of continuous process improvementProactive; anticipates problems and seeks solutionsEffectively manages diversity in the workplaceHighest integrityValues UW Medicine's mission
Founded in 1861, the University of Washington is one of the oldest public institutions in the west coast and one of the preeminent research universities in the world. The University of Washington is a multi-campus university comprised of three different campuses: Seattle, Tacoma, and Bothell. The Seattle campus is made up of sixteen schools and colleges that serve students ranging from an undergraduate level to a doctoral level. The university is home to world-class libraries, arts, music, drama, and sports, as well as the highest quality medical care in Washington State and a world-class academic medical center. The teaching and research of the University’s many professional schools provide undergraduate and graduate students the education necessary toward achieving an excellence that will serve the state, the region, and the nation. As part of a large and diverse community, the University of Washington serves more students than any other institution in the Northwest.