Data Analyst II

University of Rochester; City of Albany (NY); Hybrid; USD 52,000 - 73,000; Full time

Job summary

The University of Rochester is seeking a Nursing Finance Data Analyst to develop and maintain data collection, analysis, and reporting processes that support Nursing Finance operations and decision-making. You will extract, validate, and prepare data from Workday, Axiom, UKG, NPD, SQL servers, and other sources for financial and operational reporting.

Responsibilities include developing, maintaining, and enhancing data models, queries, crosswalks, and reporting tools to ensure accurate

Qualifications

• Bachelor's degree in statistical analysis, database management, or related field, plus 3 years of data analysis experience.
• Advanced Excel skills with data modeling knowledge.
• Experience with UR Financials, UKG, Axiom, or clinical databases preferred.

Responsibilities

• Develop and maintain data collection, analysis, and reporting for Nursing Finance operations and decision-making.
• Extract, validate, and prepare data from Workday, Axiom, UKG, NPD, SQL servers for financial and operational reporting.
• Develop and maintain data models, queries, crosswalks, index files, databases, and reporting tools for accurate financial reporting.
• Provide analytical support for budget development and ongoing fiscal management.
• Deliver dashboards and presentations to Nursing Practice leadership and executives.

Skills

Data analysis

Excel (advanced)

Problem solving

Attention to detail

Education

Bachelor's degree in statistics/data analysis/related field

Tools

UR Financials

UKG

Axiom

Clinical databases

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

• 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 formulas and a foundational understanding of data modeling concepts or experience managing relational databases required
• 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

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.

Learn. Discover. Heal. Create.

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.