Data Analyst II

Nursing Finance Data AnalystAs a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.Job Location:Remote Work - New York, Albany, New York, United States of America, 12224Opening:Worker Subtype:RegularTime Type:Full timeScheduled Weekly Hours:40Department:500402 Nursing Practice/SMHWork Shift:UR - Day (United States of America)Range:UR URG 108Compensation Range:$52,300.00 - $73,300.00The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.Responsibilities:Responsible for developing and maintaining data collection, analysis, and reporting processes to support Nursing Finance operations and decision-making. Analyzes and interprets financial, clinical, operational, and nursing performance data from multiple sources to identify data trends, variances, relationships, and opportunities for data-driven insights. Partners with Nursing Finance Team and Nursing Practice leaders to identify analytical and reporting requirements, develop advanced reporting solutions, and provide comprehensive data analyses that inform actionable insights and recommendations in support of budget planning, financial performance, and operational improvement. Develops, maintains, and enhances complex data models, queries, crosswalks, index files, databases, and reporting tools to ensure accurate and consistent financial and operational reporting. Applies independent judgment in evaluating data, investigating discrepancies, determining appropriate analytical approaches, and communicating findings. Provides analytical support for the development of the annual Nursing operating budget and ongoing fiscal management. Demonstrates technical proficiency in data management tools including advanced Excel, database systems, and reporting platforms. Actively assists the Director of Nursing Practice Finance and Sr Financial Analyst in generating the overall annual Nursing operating budget presentation. Clear communication, strong attention to detail, and willingness to learn are essential for success.Essential FunctionsUnder the general direction of the Sr. Financial Analyst, conforming to URMC policies but retaining latitude for independent judgment and initiative:Manage NDNQI submission process for nursing indicatorsDevelop, maintain, and troubleshoot data models, queries, crosswalks, and index files to ensure data accuracy and consistencyExtract, validate, and prepare data from various systems (e.g., Workday, Axiom, UKG, NPD, SQL servers) for financial and operational reportingDevelop and distribute routine reports such as Cost per Patient Day Detail Summary, medical supply purchase reports, Manpower reports, and other analyses required by Nursing FinanceProvide support for ad hoc data analysis and reporting requestsSupport the monthly audit reconciliation process, including template management and completing various reconciliation tasksDevelop and maintain gift and education reconciliation file infrastructurePrepare and submit monthly standard journal entries for specific allocations and ledger transaction errorsSupport annual budget preparation through development of robust data models, comprehensive report generation, plan file review, and validation of information maintained within Axiom and related systemsSubmit basic FTE/budget modification requests; manage the overall team's FTE/budget modification submission tracking, including complex data validation and reconciliation, to ensure accurate and consistent reflection across all reporting systems.Ensure data accuracy and consistency across all relevant systems and sourcesMaintain the integrity and structure of assigned databases and data filesMonitors data processes and reporting methodologies for opportunities to improve accuracy, efficiency, standardization, and automationProtect the confidentiality of all sensitive patient, employee, and financial dataDocument data sources, transformations, analytical methodologies, report logic, and standard operating procedures to support consistent and sustainable reporting processesProvide clean, validated data and analysis to support departmental analysis, financial projections, and strategic initiativesCollaborate with other departments and stakeholders to ensure efficient and accurate data flowServe as a resource to nursing departments related to UR Financials tasks and processesSupports internal and external audit activities by compiling, validating, and verifying required data and documentation and assisting with data-related aspects of discrepancy resolutionDevelops data analyses, reports, dashboards, and presentations for Nursing Finance, Nursing Practice leadership, and executive audiencesMinimum Education & ExperienceBachelor's degree in statistical analysis, data base management, or related studies and 3 years data analysis or customer resource management systems experience requiredOr equivalent combination of education and experienceHealthcare experience preferredKnowledge, Skills and AbilitiesAttention to detail requiredAccuracy and record keeping requiredData analysis and problem solving requiredAdvanced proficiency in Microsoft Excel required, including advanced formulas and a foundational understanding of data modeling concepts or experience managing relational databases requiredAbility to learn and navigate multiple software platforms including UR Financials, UKG, Axiom, and clinical databases preferredStrong organizational, data analysis, and problem-solving skills preferredAbility to visually portray and communicate data through dashboards, charts, reports, and presentations preferredAbility to collaborate effectively with stakeholders across departments and translate business needs into analytical and reporting solutions preferredThe University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture to advance the University's Mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status, or any other characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law.