Data Analyst

Client’s Enterprise Research Services team is seeking a Data Analyst to support research administration, financial reporting, and enterprise data initiatives across the university’s research ecosystem. This role will focus on developing and maintaining Power BI reporting solutions, supporting research and financial analytics, and partnering with business stakeholders to deliver actionable insights. The ideal candidate will combine strong technical reporting and data management skills with a solid understanding of finance, accounting, and administrative operations. The Data Analyst will work closely with research administration, finance, IT, and business teams to gather reporting requirements, develop dashboards and data models, support federally mandated reporting, and help expand Yale’s enterprise data capabilities., * Design, develop, and maintain Power BI dashboards, reports, and data visualizations for research administration and business stakeholders.

• Gather and document reporting requirements from business users and translate them into technical reporting solutions.
• Develop and optimize Power BI datasets, data models, and reporting frameworks to support enterprise decision-making.
• Write and maintain SQL queries to extract, transform, and analyze data from multiple sources.
• Partner with stakeholders to identify key metrics, reporting needs, and dashboard requirements.
• Support pre-award research administration reporting and financial reporting initiatives.
• Assist in the preparation and submission of federally required reports, including annual research reporting requirements.
• Work with technical teams to expand and enhance data marts that support enterprise reporting and analytics.
• Participate in testing, validation, and quality assurance activities for reporting and data initiatives.
• Help define business requirements and reporting specifications for new projects and enhancements.
• Analyze financial and operational data to identify trends, risks, and opportunities for process improvement.
• Collaborate with project managers, business teams, and technical resources to support reporting and analytics projects.
• Support data governance, data quality, and reporting standardization efforts across the organization.

• 10+ years of experience as a Data Analyst, Reporting Analyst, Financial Analyst, Business Intelligence Analyst, or similar role.
• Advanced experience developing reports and dashboards in Power BI.
• Strong experience creating Power BI data models, measures, calculations, and visualizations.
• Experience writing and optimizing SQL queries for reporting and analysis.
• Strong understanding of financial reporting, budgeting, accounting principles, and business operations.
• Experience gathering reporting requirements and translating business needs into reporting solutions.
• Knowledge of relational databases, database design, and data structures.
• Ability to analyze and interpret large datasets and communicate findings effectively.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication and stakeholder management abilities., * Experience supporting research administration, sponsored programs, grants management, or higher education environments.
• Experience with pre-award research reporting and research operations.
• Familiarity with federally required reporting and compliance requirements.
• Experience working in healthcare, higher education, research institutions, or other nonprofit organizations.
• Experience with Workday reporting and data structures.
• Experience supporting enterprise data warehouse or data mart initiatives.
• Experience with business intelligence architecture and enterprise reporting platforms.
• Project management or project coordination experience.
• Knowledge of data governance and reporting best practices.

Required :

• Power BI
• SQL
• Data Modeling
• Dashboard Development
• Financial Reporting
• Business Intelligence Reporting
• Relational Databases
• Requirements Gathering
• Data Analysis

Preferred:

• Workday
• Data Warehousing
• Data Mart Development
• Research Administration Systems
• ETL Processes
• Enterprise Reporting Architecture.