IT, Business Systems Analyst 3

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

Job summary

Yale Cancer Center in New Haven is seeking a skilled professional to manage financial reporting and support analytics. The ideal candidate will design and maintain Power BI dashboards while closely partnering with users to gather requirements for Workday Financials.

This role involves critical thinking, analytical abilities, and strong project management skills, requiring a Doctor’s or Master’s degree and relevant experience. Join us to enhance financial reporting and drive improvements.

Qualifications

• Doctor’s or Master’s Degree and four years of experience or equivalent education and experience.
• Proven ability to lead and manage staff.
• Experience with financial reporting and analytics tools.

Responsibilities

• Monitor and manage Financial Reporting and Analytics support queue.
• Design, develop, and maintain Power BI reports and dashboards.
• Gather and document requirements for Workday Financials.

Skills

Analytical skills

Communication skills

Project management

Problem-solving skills

Business analysis

Education

Doctor’s or Master’s Degree

Tools

Power BI

SQL

Job description

Salary Range

$86,300.00 - $129,425.00

Job Requisition ID

136391WD

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/s understanding.
• May lead segments of larger projects, develop trainings, presentations, and communications.

Required Education and Experience

Doctor’s or Master’s Degree and four years of experience or equivalent education and experience.

Skills and Abilities

• Developed analytical, critical thinking and problem‑solving skills.
• Developed interpersonal, written, communication, presentation, and organizational skills.
• Proven ability to lead and manage staff.
• Proven expertise with systems and process analysis methods and techniques.
• Proven project management skills and knowledge of commonly used concepts, practices, and procedures.

Background Check Requirements

All candidates for employment will be subject to pre‑employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. For additional information on the background check requirements and process visit "Learn about background checks" under the Applicant Support Resources section of Careers on the It's Your Yale website.

Health Requirements

Certain positions have associated health requirements based on specific job responsibilities. These may include vaccinations, tests, or examinations, as required by law, regulation, or university policy.

Posting Disclaimer

The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the position. Employees will be assigned specific job‑related duties through their hiring department.
University policy is committed to affirmative action under law in employment of women, minority group members, individuals with disabilities, and protected veterans. Additionally, in accordance with Yale's Policy Against Discrimination and Harassment, and as delineated by federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of that individual's 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.
Inquiries concerning Yale's Policy Against Discrimination and Harassment may be referred to the Office of Institutional Equity and Accessibility (OIEA).