Location: Ann Arbor,MI, USA
Business Systems Analyst SrApply NowJob SummaryProduction Financial Systems AnalystThe Michigan Medicine Financial Systems team provides theleadership, oversight, and technical support for the suite of financial products, applications, and datasets used by the Finance Organization of Michigan Medicine for financial reporting, planning, analytics, and decision-making. The team is responsible for deliveringon-time enterprise-level reporting and business intelligence systems, managing concurrent high-visibility projects to support new initiatives, guiding data stewardship, andinforming and supporting institutional enterprise objectives.The Financial Systems Production team focuses on administration and end-user support to deliveron-timeproduction systems, ensuring high data quality and exceptional business value toourstakeholders. Responsibilities include all aspects of administering enterprise-level reporting solutions.The Financial Systems Analyst's primary focus is on the production administration of the solutions the team manages and all underlying data sources and processes to support it. The role is responsible for providing timely, accessible, and accurate data according to the Finance department defined timelines.This role is responsible for managing and administering the enterprise-level reporting solutions, integrating cloud-hosted reporting applications, data warehouse and critical organization business processes . This position requiresa thorough understanding of accounting and finance principles to deliver financial systems solutions that drive value and decision making across the institution. This position is responsible foranalyzing and translating business, information, and technical requirements into enterprise-levelreporting solutions. This role is responsible for researchingand maintaining knowledge of current and emerging technologies to solve business problems, particularly with a focus on cloud-hosted solutions . Actively participating in problem-solving and developing integrated solutions within a complex, varied, and evolving technical landscape will be an essential part of this position. This role serves as a liaison between end users, stakeholders, and the solutions architects to propose changes in process, policy, standards, application and end user experience to peers and leadership. In addition, this position will partner with key stakeholders and leadership in requirement gathering and data analysis as well as work with team solutions architects to deliver enterprise reporting solutions.The Production Financial Systems Analyst must possess strong finance, accounting, and health care business practices knowledges. This role will require a strong technical understanding of relational database models, SQL and multiple Oracle technologies including Oracle Cloud Analytics and Cloud EPM applications.Mission StatementMichigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.Why Join Michigan Medicine?Why Join the Michigan Medicine Financial Systems Team?You will be a member of the team that provides leadership and oversight for the suite of financial products, applications, and technical support used to support the financial reporting, planning, analytics, and decision-making for the Finance Organization of Michigan Medicine.Responsibilities*Role and Responsibilities:Monthly Production Validations & Change Management Process - 40%Ensure data quality and consistency throughout all production applications:Finance BI (Oracle Cloud Analytics application used for decision support across Michigan Medicine Finance)Multiple Oracle Enterprise Performance Management (EPM) Cloud Applications.Change Management monthly processing of hierarchies and statistics in all applications.Analyze request for adherence to our ?one version of the truth? philosophy, as well as impact to application and technical processes.Partner with requestor on monthly hierarchy changes. Coordinating with the requester to complete request documentationImplement changes in Test environment and migrate changes to production.Communicate monthly changes to requestor and stakeholders and Financial Systems team.Tie out various financial systems datasets back to PeopleSoft (source system) and other source systems monthly in Test and Production environments for all applications.Monthly Unit of Service (UOS) static and metrics validationsManage all Test and Production data tie outs for monthly and annual processing in all applications.Manage all monthly report delivery solutions including maintaining distribution, automation, and development of enhancements.Report and Query Building for internal and external customers using tools such as Oracle BI Publisher, Oracle Analytics Cloud and Data Visualizer and Narrative ReportingWork with Solutions Architects on monthly and annual tie out processing and implement new processes to improve efficiency and accuracy.Possesses and applies a broad knowledge of principles, practices, and procedures of Financial Systems data sets.Collaborate with Vendor technical teams, internal enterprise architecture, and application infrastructure teams to resolve technical issues and understand systems dependencies and compatibility.Function as back-up for production Financial Systems Analyst teammates to support monthend, quarter-end and annual reporting tasks.Documentation, Validation and Governance - 40%Prepares and conducts comprehensive testing and validation procedures.Continuously review month-end, quarter-end, and year-end validation processes, ensuring completeness, accuracy, and efficiency.Full integration of new processes into documentation and trainingManaging the inventory of system documentation and instructions utilizing searchable dynamic solutionsMaintaining training and end-user documentationMaintaining and periodic scheduled testing of full application disaster recovery across all production systemsCreate and maintain Data Governance documentation including but not limited to:Data DictionariesData/Process flow diagramsData Model Fact MatricesAd Hoc - 20%Go to person for ad hoc analysis, end user requests to understand data flows, data dependencies and appropriate use and consumption of Finance presented data.Items may include but are not limited to:Conducting peer and end-user trainingSupport special projects within Financial Systems as well as Michigan Medicine FinanceSupport compliance efforts across organization.Assist with other projects as required to contribute to efficiency and effectiveness of the work.Helpdesk and end-user supportCoach and mentor junior staff.Required Qualifications*BA/BS degree1-5 years of financial systems, data analytics or financial analysis experience - Intermediate level5-7 years of financial systems, data analytics or financial analysis experience - Senior levelDesired Qualifications*Detailed knowledge and understanding of SQL.Experience with data modeling and relational databases.Demonstrated creative critical thinking skills.Ability to assess competing priorities, manage workflow and meet operational deadlines.Must work well independently and as part of a team.Able to demonstrate excellent interpersonal, written, and verbal communication skills.Excellent collaboration and coordination skills for an effective relationship with multiple teams, subject matter experts (SMEs), and customersExperience with Data Extraction, Transformation, and Loading (ETL)Experience integrating data from multiple sources.Knowledge and understanding of technical accounting principles.Experience with Oracle Analytics Cloud or similar BI tools.Experience with Oracle Enterprise Performance Management ProductsUnderstanding of common IT business analysis, and/or project management methodologies and best practicesExperience with Oracle Cloud InfrastructureExperience with Oracle Enterprise Performance Management Cloud applications.Experience with multidimensional DBMS.Experience with query, report writing, and data visualization tools.Clarity Certification or ProficiencyExperience working with Financial and Clinical Healthcare data.Modes of WorkPositions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about thework modes ( .Underfill StatementThis position may be underfilled at a lower classification depending on the qualifications of the selected candidate.Additional InformationIs this Job Right for You?This job might be right for you if you?Strive to work with technology used by top companies and multiple industries.Enjoy creative problem-solving and making new discoveries.Have a drive for designing, developing, and recommending innovative approaches, methodologies, and tools.Want to work on an embedded technical team that collaborates directly with our key partners.Have an interest in working with diverse dimensions of healthcare analytics, including financials, revenue reporting, patient care statistics, etc.Pay attention to detail and do not let anything fall through the cracks.Thrive while working in both team and individual settings.Are adaptable to changing conditions and maintain an elevated level of focus/energy.Feel confident offering support and expressing ideas to leadership.Background ScreeningMichigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.Application DeadlineJob openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.U-M EEO/AA StatementThe University of Michigan is an equal opportunity/affirmative action employer.Job DetailJob Opening ID254966Working TitleBusiness Systems Analyst SrJob TitleBusiness Systems Analyst SrWork LocationMichigan Medicine - Ann ArborAnn Arbor, MIModes of WorkHybridFull/Part TimeFull-TimeRegular/TemporaryRegularFLSA StatusExemptOrganizational GroupExec Vp Med AffairsDepartmentMM Financial SrvcsPosting Begin/End Date11/15/2024 - 12/31/2024Career InterestInformation TechnologyApply Now