Data Jobs in Stony Brook, NY

1 job found

Include remote jobs

10d ago

Senior Financial Data & Analytics Engineer

Stony Brook University Stony Brook, NY

Stony Brook, NY

10d ago

$110k - $120k/yr Full time Senior Analytics Business Analytics

Apply Now

Job Description

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.

View full job page →

Get Job Alerts

New jobs delivered to your inbox.