Business Systems Analyst

About Yale University

Working at Yale means contributing to a better tomorrow. Whether you are a current resident of our New Haven-based community-eligible for opportunities through the New Haven Hiring Initiative or a newcomer, interested in exploring all that Yale has to offer, your talents and contributions are welcome. Discover your opportunities at Yale!

As a Business Systems Analyst, you will play a crucial role in supporting and enhancing financial reporting and analytics systems, ensuring their stability and reliability.

Overview of the Business Systems Analyst Role

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

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, coordinate 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 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.

Required Education and Experience

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

Key skills/competency

• Business Analysis
• Financial Reporting
• Power BI
• Data Modeling
• Workday Financials
• SQL
• AI & Automation
• Project Management
• System Test Planning
• Stakeholder Management