Data Analyst I

University of Rochester; City of Albany, Northern (NY, KY); Hybrid; USD 62,408,000 - 87,480,000; Full time

Job summary

The University of Rochester is seeking a data analyst to support Nursing Practice Finance operations, maintaining data processes, updating databases, and generating analytical reports.

You will collect, process, and maintain nursing performance data from multiple sources, including financial systems and clinical databases, ensuring data integrity and providing insights for variance analysis and budget planning. Advanced Excel and data modeling skills are essential.

Qualifications

• Bachelor's degree in statistical analysis, data base management, or related discipline and 1 year experience with data analysis or customer resource management systems required Or equivalent combination of education and experience Healthcare experience preferred

Responsibilities

• Maintain data processes, update databases, and generate analytical reports to support Nursing Finance operations.
• Collect, process, and maintain nursing performance data from multiple sources including financial systems, clinical databases, and operational platforms.
• Ensure data integrity through systematic validation, reconciliation, and quality control processes.
• Update and maintain complex data models, crosswalks, and index files that enable accurate financial and operational reporting.
• Run scheduled reports, update raw data files, and support Nursing Practice with data-driven insights for variance analysis and budget planning.
• Demonstrate technical proficiency in data management tools including advanced Excel, database systems, and reporting platforms.
• Assist 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.

Skills

Data analysis

Excel

Data management

Attention to detail

Communication

Education

Bachelor's degree in statistics or data management

Tools

Workday

Axiom

UKG

NPD

SQL

Job description

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 106 H Compensation Range: $21.78 - $30.53

Range: UR URG 106 H Compensation Range: $21.78 - $30.53 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 maintaining data processes, updating databases, and generating analytical reports to support Nursing Finance operations.
• Collects, processes, and maintains nursing performance data from multiple sources including financial systems, clinical databases, and operational platforms.
• Ensures data integrity through systematic validation, reconciliation, and quality control processes.
• Updates and maintains complex data models, crosswalks, and index files that enable accurate financial and operational reporting.
• Runs scheduled reports, updates raw data files, and supports Nursing Practice with data-driven insights for variance analysis and budget planning.
• 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:

• Assemble NDNQI data submission package for nursing indicators
• Update, 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
• Prepare and distribute routine reports such as Cost per Patient Day Detail Summary, medical supply purchase reports, and Manpower reports
• Provide support for ad hoc data analysis and reporting requests

Budget Planning and Fiscal Management:

• Support the monthly audit reconciliation process, including preparing templates and completing various reconciliation tasks
• 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 data compilation, report generation, and plan file reviews in Axiom
• Process basic FTE/budget modification requests, ensuring accurate data entry and system updates

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
• Protect the confidentiality of all sensitive patient, employee, and financial data
• Document data sources, transformations, report methodologies, and standard operating procedures for data management processes

Collaboration and Support:

• Provide clean, validated data 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
• Assist with audit processes by compiling and verifying necessary documentation
• Support the finance team by preparing data and reports for presentations to nursing leadership and executive groups

MINIMUM EDUCATION & EXPERIENCE

• Bachelor's degree in statistical analysis, data base management, or related discipline and 1 year experience with data analysis or customer resource management systems required Or equivalent combination of education and experience Healthcare experience preferred

KNOWLEDGE, SKILLS AND ABILITIES

• Strong attention to detail and commitment to data accuracy required
• Strong organizational, data analysis and problem solving skills required
• Familiarity with statistics and statistical analysis preferred
• Advanced knowledge of Microsoft Excel preferred, including advanced formulas and a foundational understanding of data modeling concepts or experience managing relational databases
• Ability to visually portray data through dashboards, charts, and reports preferred
• Ability to learn and navigate multiple software platforms including UR Financials, UKG, Axiom, and clinical databases

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.

Located in western New York, Rochester is our namesake and our home. One of the world’s leading research universities, Rochester has a long tradition of breaking boundaries—always pushing and questioning, learning and unlearning.

We transform ideas into enterprises that create value and make the world ever better. If you’re looking for a career in higher education or health care, the University of Rochester may offer the perfect opportunity for your background and goals. At the University of Rochester, we are committed to fostering, cultivating, and preserving an inclusive and welcoming culture and are united by a strong commitment to be ever better—Meliora. It is an ideal that informs our shared mission to ensure all members of our community feel safe, respected, included, and valued.