Job Title: Data Analyst
Location: Boston,MA
Duration: 9 Months + Extension
Bill Rate: $86/hour
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description
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.

Key Responsibilities:
• 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.

Required Qualifications:
• 5+ 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.

Preferred Qualifications:
• 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.