Institutional Data Analyst

Weill Cornell Medicine is seeking an Institutional Data Analyst to develop and deliver data-driven insights that support strategic decision-making across the institution. This onsite role in Midtown focuses on creating reliable reporting solutions, turning complex data into usable analysis, and strengthening the institutional reporting infrastructure with BI dashboards and automation.

• Create complex standard and ad hoc reports using advanced techniques such as DAX, drill-through functionality, and custom layouts to address a range of business needs.
• Apply knowledge of higher education fund and general ledger data to support reporting, forecasting, and institutional performance tracking.
• Use institutional operations knowledge across budgeting, research, clinical, academic, and education functions to produce relevant, insightful analyses.
• Partner with stakeholders to gather, document, and validate reporting requirements, translating business needs into actionable data solutions.
• Design, develop, and maintain reporting infrastructure, dashboards, and visualizations using Power BI and Tableau.
• Maintain and improve existing reporting workflows by identifying opportunities for automation, efficiency, and better usability.
• Integrate, clean, and transform data from multiple sources using SQL and Python, ensuring accuracy, consistency, and optimal performance.
• Produce clear technical documentation and provide end-user support while managing multiple priorities and collaborating across teams.
• Support institutional data collection, review, analysis, and submission for surveys including IPEDS, AAMC, LCME, and others.
• Perform other related duties as assigned.

• Bachelor’s degree in math, statistics, computer science, or a related technical field.
• Budget subject matter experience preferred.
• Approximately 3-5 years of experience as a Data Analyst, including direct professional experience with:
  • Python (Pandas, Numpy, or similar libraries)
  • Modeling and visualization with Power BI and Tableau
  • Metrics customization with DAX and VizQL
• Experience accessing, cleansing, and analyzing data from one or more of the following: transactional tables, OLAP data models, BI data marts, SQL-based data warehouses, and semi-structured/unstructured data environments.
• Experience defining objectives, forming hypotheses, and conducting analysis to drive measurable business impact.
• Demonstrated critical thinking and initiative, with the ability to manage multiple responsibilities in a fast-paced environment.
• Ability to adjust and adapt to satisfy multiple priorities.

DAX, Power BI, Tableau, SQL, Python, Pandas, Numpy, VizQL, OLAP, IPEDS, AAMC, LCME

Location: Midtown (onsite)
Compensation: USD 83,400 - 94,800 per year