Senior Financial Data & Analytics Engineer

Stony Brook University is seeking a Senior Financial Data & Analytics Engineer to design, build, and maintain enterprise financial data infrastructure and analytics solutions for the School of Medicine.

Responsibilities

• Create a centralized financial data warehouse that consolidates PeopleSoft, HR, CPMP, Report Center, SOMDASH, and external data feeds.
• Develop and maintain ETL/ELT pipelines for structured and semi-structured data.
• Build and oversee API-driven data ingestion pipelines.
• Ensure the data architecture is scalable, high-performing, and reliable.
• Collaborate with IT and enterprise data teams on infrastructure and platform design.
• Develop analytics models for physician productivity (wRVUs), reimbursement, and compensation.
• Incorporate benchmarking data such as Vizient for comparative performance analysis.
• Build predictive and trend models to support financial planning.
• Analyze payer mix, revenue cycles, and cost structures across departments.
• Design data models to support funds flow, ROI analysis, and All-Funds financial reporting.
• Create multi-dimensional datasets integrating clinical, academic, and financial data.
• Define standardized metrics and definitions for institutional reporting.
• Support scenario modeling and financial forecasting.
• Develop and maintain executive dashboards using Tableau or equivalent BI tools.
• Build self-service analytics tools for departments and leadership.
• Design intuitive, scalable, and interactive reporting solutions.
• Translate complex datasets into actionable insights.
• Establish and enforce data quality, validation, and reconciliation processes.
• Support data governance frameworks and compliance with institutional policies.
• Collaborate with SOM Finance, Clinical Practice, HR, IT, and leadership stakeholders.
• Present findings and recommendations to executive leadership.
• Perform other duties and special projects aligned with departmental and institutional research missions.

Requirements

• Bachelor’s degree or higher (foreign equivalents accepted) in Data Science, Computer Science, Information Systems, Finance, Economics, or related field.
• Five or more years of full-time experience in data engineering, data analytics, or financial analytics within healthcare or enterprise environments.
• Proficiency with SQL and relational databases, data warehouse design (dimensional modeling, star schema), ETL/ELT pipeline development, API integration and data ingestion, and BI platforms such as Tableau or equivalents.
• Experience integrating data across ERP systems (eg, PeopleSoft), HR systems, and operational/clinical datasets.
• Knowledge of physician productivity metrics (eg, wRVUs) and healthcare financial data structures.

Technologies

• SQL
• Tableau
• Power BI
• Excel
• Snowflake
• Databricks
• Azure
• AWS
• Python
• R
• PeopleSoft

Benefits

• UUP annual location pay ($4,000)

Job Details

• Job number: 2601287
• Official job title: Assistant for University Financial Analysis
• Job field: Administrative & Professional (non-Clinical)
• Primary location: US-NY-Stony Brook
• Department/Hiring Area: Office Of Dean, Medicine
• Schedule: Full-time, Day Shift, 8:30 AM - 5:00 PM
• Posting start date: May 8, 2026
• Posting end date: Jun 7, 2026, 10:59 PM
• Salary: $110,000-$120,000
• Appointment type: Permanent
• Salary grade: SL4
• SBU area: Stony Brook University
• Special notes: This is a full-time, FLSA Exempt position not eligible for overtime. Minimum salary threshold applies for exemption. This role is not eligible for visa sponsorship. In addition to base salary, eligible for $4,000 UUP annual location pay, paid biweekly.