Data Analyst II

About this role

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.

Job Location (Full Address):

Remote Work - New York, Albany, New York, United States of America, 12224 Opening:

Worker Subtype: Regular Time Type: Full time Scheduled Weekly Hours: 40 Department: 500402 Nursing Practice/SMH Work Shift: UR - Day (United States of America) Range: UR URG 108 Compensation Range: $52,300.00 - $73,300.00 The 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 FUNCTIONS Under the general direction of the Sr. Financial Analyst, conforming to URMC policies but retaining latitude for independent judgment and initiative: Report Maintenance and Data Analysis: • 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

Budget Planning and Fiscal Management: • 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.

Data Integrity and Quality Control: • 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

Collaboration and Support: • 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

MINIMUM EDUCATION & EXPERIENCE • 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 • Healthcare experience preferred

KNOWLEDGE, SKILLS AND ABILITIES • Attention to detail required • Accuracy and record keeping required • Data analysis and problem solving required • Advanced proficiency in Microsoft Excel required, including advanced for

Similar jobs

• Data Analyst II — Brex · Remote
• Data Analyst II — Brex · Remote
• Data Analyst II — Andersen · Cottage Grove, MN
• Data Science Analyst II — The University of Texas at Austin · UT MAIN CAMPUS
• Data Analyst III — CNI · Natick, MA
• Data Analyst III/II/I — Americanfidelity · Oklahoma City, Oklahoma
• Data Analyst I — Garnerhealth · New York City, New York
• Data Analyst I — Acorns · Remote