Data Analyst II

Summary

The University of Rochester is a higher education and healthcare institution committed to advancing learning, discovery, healing, and inclusive community values. The Data Analyst II supports Nursing Finance operations by managing data collection, analysis, reporting, budget planning, fiscal management, and data quality processes. The role develops analytical solutions, maintains data models and reporting tools, and provides insights to support financial and operational decision-making.

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
• Manage NDNQI submission process for nursing indicators
• Develop, maintain, and troubleshoot data models, queries, crosswalks, and index files to ensure data accuracy and consistency
• Extract, validate, and prepare data from various systems (e.g., Workday, Axiom, UKG, NPD, SQL servers) for financial and operational reporting
• Develop and distribute routine reports such as Cost per Patient Day Detail Summary, medical supply purchase reports, Manpower reports, and other analyses required by Nursing Finance
• Provide support for ad hoc data analysis and reporting requests
• Support the monthly audit reconciliation process, including template management and completing various reconciliation tasks
• Develop and maintain gift and education reconciliation file infrastructure
• Prepare and submit monthly standard journal entries for specific allocations and ledger transaction errors
• Support annual budget preparation through development of robust data models, comprehensive report generation, plan file review, and validation of information maintained within Axiom and related systems
• Submit 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 sources
• Maintain the integrity and structure of assigned databases and data files
• Monitors data processes and reporting methodologies for opportunities to improve accuracy, efficiency, standardization, and automation
• Protect the confidentiality of all sensitive patient, employee, and financial data
• Document data sources, transformations, analytical methodologies, report logic, and standard operating procedures to support consistent and sustainable reporting processes
• Provide clean, validated data and analysis to support departmental analysis, financial projections, and strategic initiatives
• Collaborate with other departments and stakeholders to ensure efficient and accurate data flow
• Serve as a resource to nursing departments related to UR Financials tasks and processes
• Supports internal and external audit activities by compiling, validating, and verifying required data and documentation and assisting with data-related aspects of discrepancy resolution
• Develops data analyses, reports, dashboards, and presentations for Nursing Finance, Nursing Practice leadership, and executive audiences

Skills

• * Bachelor's degree in statistical analysis, data base management, or related studies and 3 years data analysis or customer resource management systems experience required
• * Or equivalent combination of education and experience
• * Attention to detail required
• * Accuracy and record keeping required
• * Data analysis and problem solving required
• * Advanced proficiency in Microsoft Excel required, including advanced formulas and a foundational understanding of data modeling concepts or experience managing relational databases required
• * Healthcare experience preferred
• * Ability to learn and navigate multiple software platforms including UR Financials, UKG, Axiom, and clinical databases preferred
• * Strong organizational, data analysis, and problem-solving skills preferred
• * Ability to visually portray and communicate data through dashboards, charts, reports, and presentations preferred
• * Ability to collaborate effectively with stakeholders across departments and translate business needs into analytical and reporting solutions preferred

Qualifications

Must Haves

• * Bachelor's degree in statistical analysis, data base management, or related studies and 3 years data analysis or customer resource management systems experience required
• * Or equivalent combination of education and experience
• * Attention to detail required
• * Accuracy and record keeping required
• * Data analysis and problem solving required
• * Advanced proficiency in Microsoft Excel required, including advanced formulas and a foundational understanding of data modeling concepts or experience managing relational databases required

Nice to Haves

• * Healthcare experience preferred
• * Ability to learn and navigate multiple software platforms including UR Financials, UKG, Axiom, and clinical databases preferred
• * Strong organizational, data analysis, and problem-solving skills preferred
• * Ability to visually portray and communicate data through dashboards, charts, reports, and presentations preferred
• * Ability to collaborate effectively with stakeholders across departments and translate business needs into analytical and reporting solutions preferred

Benefits

• Hybrid work arrangement