IT, Business Systems Analyst

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.

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

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

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

Bachelor's Degree and four years of experience or equivalent education and experience.

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

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.

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.

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 this policy and in accordance with 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.

For more information, please refer to Yale's Policy Against Discrimination and Harassment.