Institutional Data Analyst

Weill Cornell Medicine; Gary (IN); In loco; USD 83.000 - 95.000; Tempo pieno

Descrizione del lavoro

Weill Cornell Medicine in Midtown is seeking an Institutional Data Analyst to develop data-driven insights and deliver reliable reporting solutions onsite. You will build dashboards using Power BI and Tableau, transform data with SQL and Python, and support institutional reporting infrastructure.

You will collaborate with stakeholders to gather requirements, automate processes, and document analyses for surveys like IPEDS, AAMC, and LCME.

Competenze

• Bachelor's degree in a technical field (math, statistics, CS, or related).
• Approximately 3–5 years of experience as a Data Analyst.
• Experience modeling and visualizing with Power BI and Tableau.
• Advanced data handling with SQL, Python (Pandas/Numpy), and VizQL.

Mansioni

• Create complex standard and ad hoc reports using DAX, drill-through, and custom layouts.
• Apply knowledge of higher education fund and general ledger data to reporting and forecasting.
• Partner with stakeholders to gather, document, and validate reporting requirements.
• Design, develop, and maintain reporting infrastructure, dashboards, and visualizations.
• Improve workflows via automation and improved usability; integrate data from multiple sources.
• Produce documentation and provide end-user support across teams.
• Support surveys such as IPEDS, AAMC, LCME; perform other duties as assigned.

Conoscenze

DAX

Power BI

Tableau

SQL

Python

Pandas

Numpy

VizQL

OLAP

IPEDS

AAMC

LCME

Formazione

Bachelor's degree

Strumenti

DAX

Power BI

Tableau

SQL

Python

Pandas

Numpy

VizQL

OLAP

IPEDS

AAMC

LCME

Descrizione del lavoro

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.

What you’ll do

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

What you bring

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

Tools you’ll use

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

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