Data Analyst II

University of Rochester • New York, NY

9d • $52,300 - $73,300 • Remote

About The Position

As 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.

This role is responsible for developing and maintaining data collection, analysis, and reporting processes to support Nursing Finance operations and decision-making. The Data Analyst II 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. They partner with the 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. The role involves developing, maintaining, and enhancing complex data models, queries, crosswalks, index files, databases, and reporting tools to ensure accurate and consistent financial and operational reporting. The Data Analyst II applies independent judgment in evaluating data, investigating discrepancies, determining appropriate analytical approaches, and communicating findings. They provide 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.

Requirements

• 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

Responsibilities

• 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

Benefits

• The 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level