IT, Business Systems Analyst 3

Yale University; New Haven (CT); On-site; USD 86,300 - 129,425; Full time

Job summary

Yale University seeks a skilled financial analyst to monitor and manage Financial Reporting and Analytics support, providing user support and improving financial systems. In this role, you will apply AI knowledge and develop informative dashboards using Power BI.

The ideal candidate will possess strong analytical skills, a Bachelor's degree, and experience in business analysis. Your contributions will include leading projects and enhancing reporting accuracy through innovative solutions.

Qualifications

• Bachelor's Degree and four years of experience or equivalent education and experience.
• Strong analytical, critical thinking, and problem‑solving skills.
• Developed interpersonal, written, communication, presentation, and organizational skills.

Responsibilities

• Monitor and manage the Financial Reporting and Analytics support queue.
• Contribute to medium- and large-scale projects.
• Apply working knowledge of AI to enhance financial reporting.
• Design, develop, and maintain Power BI reports.

Skills

Analytical skills

Leadership and project management

Interpersonal and communication skills

Business analysis

Expertise in SQL

Power BI proficiency

Education

Bachelor's Degree

Tools

Workday Financials

Power BI

SQL

Job description

Overview

• Monitor and manage the Financial Reporting and Analytics support queue, providing timely user support and partnering with IT to keep financial systems (e.g., Finance Datamart, SSAS models) stable and reliable.
• Contribute to medium- and large-scale projects, ensuring assigned tasks and deliverables are completed on time.
• Apply working knowledge of AI to identify and advance enhancements to financial reporting that improve accuracy, efficiency, and insight.
• Partner with end users and stakeholders to gather and document requirements for Workday Financials and Power BI reporting, supporting enhancements and new development.
• Design, develop, test, and maintain Power BI reports and dashboards that enable accurate, insightful, and actionable reporting.

Required Skills And Abilities

• Strong analytical, critical thinking, and problem‑solving skills.
• Developed interpersonal, written, communication, presentation, and organizational skills.
• Proven ability to lead and manage projects and staff.
• Expertise in business analysis and functional solution design.
• Knowledge of commonly used concepts, practices, and procedures.

Preferred Skills And Abilities

• Working knowledge of AI and automation tools, with practical experience using them to improve financial reporting, analytics, and business processes.
• Experience designing, building, and maintaining Power BI reports and dashboards, including data modeling, DAX, and performance tuning.
• Experience writing and optimizing SQL and/or other query languages to extract, transform, and analyze data; familiarity with data warehouses or datamarts preferred.
• Hands‑on experience with Workday Financials reporting and Worksheets, including development, enhancement, and support of standard and custom reports.

Principal Responsibilities

• Perform a diverse range of analytical duties in the development of technology solutions for business processes.
• Plan, organize, and define requirements, methods, and end‑user objectives, coordinating effort with team members, other IT staff, users, and vendors.
• Interview, analyze, and document end‑user processes and systems requirements for enhancement and/or workflow improvements or new system development.
• Develop and execute system test plans to ensure application performance aligns to specifications.
• Prepare technical reports, design workflow maps or other documents to facilitate system understanding.
• May lead segments of larger projects, develop trainings, presentations, and communications.

Education and Experience

Required: Bachelor’s Degree and four years of experience or equivalent education and experience.

Compensation

Salary Range: $86,300.00 - $129,425.00

EEO Statement

The University is committed to basing judgments concerning the admission, education, and employment of individuals upon their qualifications and abilities and seeks to attract to its faculty, staff, and student body qualified persons from a broad range of backgrounds and perspectives. In accordance with federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of sex, sexual orientation, gender identity or expression, race, color, national or ethnic origin, religion, age, disability, status as a special disabled veteran, veteran of the Vietnam era or other covered veteran.