Data Analyst II - Remote Opportunity

About the Company

The University of Rochester is guided by its commitment to Meliora – Ever Better and values of equity, leadership, integrity, openness, respect, and accountability. The University is dedicated to creating an inclusive and welcoming community where everyone can thrive.

About the Role

The University of Rochester is seeking a Data Analyst to support Nursing Finance operations through data collection, analysis, reporting, and financial planning. This role involves analyzing financial, clinical, operational, and nursing performance data from multiple sources to identify trends, variances, and opportunities for improvement.

Working with the Nursing Finance Team and Nursing Practice leaders, the Data Analyst will develop reporting solutions, maintain complex data models and databases, support annual budget planning, and provide insights that inform financial performance and operational decisions.

Key Responsibilities

Report Maintenance and Data Analysis

• Manage the National Database of Nursing Quality Indicators (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 systems such as Workday, Axiom, UKG, NPD, and SQL servers for financial and operational reporting.
• Develop and distribute routine reports, including Cost per Patient Day Detail Summary, medical supply purchase reports, manpower reports, and other Nursing Finance analyses.
• Respond to ad hoc data analysis and reporting requests.

Budget Planning and Fiscal Management

• Support monthly audit reconciliation, including template management and related 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 by developing data models, generating reports, reviewing plan files, and validating information in Axiom and related systems.
• Submit basic FTE and budget modification requests.
• Track the team's FTE and budget modification submissions, including complex data validation and reconciliation, to ensure consistency across reporting systems.

Data Integrity and Quality Control

• Ensure data accuracy and consistency across relevant systems and sources.
• Maintain the integrity and structure of assigned databases and data files.
• Monitor data processes and reporting methodologies to identify opportunities to improve accuracy, efficiency, standardization, and automation.
• Protect confidential patient, employee, and financial information.
• Document data sources, transformations, analytical methodologies, report logic, and standard operating procedures to support consistent reporting processes.

Collaboration and Support

• Provide clean, validated data and analysis for departmental reporting, financial projections, and strategic initiatives.
• Collaborate with departments and stakeholders to support efficient and accurate data flow.
• Serve as a resource for nursing departments on UR Financials tasks and processes.
• Support internal and external audits by compiling, validating, and verifying required data and documentation and assisting with discrepancy resolution.
• Develop data analyses, reports, dashboards, and presentations for Nursing Finance, Nursing Practice leadership, and executive audiences.
• Assist the Director of Nursing Practice Finance and Senior Financial Analyst in preparing the annual Nursing operating budget presentation.

Required Qualifications

• Bachelor's degree in statistical analysis, database management, or related studies, along with three years of data analysis or customer resource management systems experience.
• An equivalent combination of education and experience may be considered.
• Strong attention to detail.
• Accuracy and record-keeping skills.
• Data analysis and problem-solving abilities.
• Advanced proficiency in Microsoft Excel, including advanced formulas.
• Foundational understanding of data modeling concepts or experience managing relational databases.

Preferred Qualifications and Skills

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

Employment Details

• Employment Type: Full-time, regular
• Work Arrangement: Remote work
• Location: New York, Albany, New York, United States
• Department: Nursing Practice/SMH
• Work Schedule: 40 hours per week
• Work Shift: Day shift
• Compensation Range: $52,300–$73,300 annually

Equal Employment Opportunity

The University of Rochester is committed to fostering and preserving an inclusive and welcoming culture in support of its mission to Learn, Discover, Heal, Create, and Make the World Ever Better.

The University does not discriminate on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military or veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status, or any other characteristic protected by federal, state, or local law. This commitment applies to the administration of University policies, admissions, employment, access, and recruitment, consistent with its values and applicable law.