Finance Architecture Engineer Jobs

1 job found

1d ago

Senior Financial Data & Analytics Engineer

Stony Brook University Stony Brook, NY

Stony Brook, NY

1d ago

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

Apply Now

Job Description

The Senior Financial Data & Analytics Engineer at Stony Brook University designs, builds, and sustains enterprise financial data infrastructure for the School of Medicine. The role covers creating data pipelines, integrating core systems, and delivering executive dashboards, with a high degree of independence to architect scalable, secure analytics that inform institutional financial strategy.

Role Overview

The incumbent operates under general direction to develop robust data architectures, support financial planning, and enable data-driven decision making for leadership across departments. This position requires collaboration with IT, enterprise data teams, and key stakeholders to ensure reliable, high-performance analytics aligned with institutional goals.

Responsibilities

Design and deploy a centralized financial data warehouse that consolidates data from PeopleSoft, HR, CPMP, Report Center, SOMDASH, and external sources.
Develop and sustain ETL and ELT pipelines for both structured and semi-structured data.
Build and manage API-based data ingestion pipelines.
Ensure the data architecture remains scalable, fast, and reliable.
Collaborate with IT and enterprise data teams on infrastructure and platforms design.
Develop analytics models for physician productivity (wRVUs), reimbursement, and compensation.
Incorporate benchmarking data such as Vizient for comparative performance analyses.
Construct predictive and trend models to support financial planning.
Analyze payer mix, revenue cycles, and department-level cost structures.
Design data models to support funds flow, ROI analysis, and All-Funds financial reporting.
Develop multi-dimensional datasets integrating clinical, academic, and financial data.
Establish standardized metrics and definitions for institutional reporting.
Support scenario modeling and financial forecasting efforts.
Develop and maintain executive dashboards using Tableau or equivalent BI tools.
Create self-service analytics tools for departments and leadership.
Design intuitive, scalable, and interactive reporting solutions.
Translate complex datasets into actionable insights for stakeholders.
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 in support of departmental and institutional research missions.

Requirements

A bachelor's degree (or foreign equivalent) in Data Science, Computer Science, Information Systems, Finance, Economics, or a related field.
Five or more years of full-time experience in data engineering, data analytics, or financial analytics within a healthcare or enterprise environment.
Experience with SQL and relational databases, data warehouse design (dimensional modeling, star schema), ETL/ELT pipeline development, API integration and data ingestion, and Tableau or equivalent BI platforms.
Experience integrating data across ERP systems (such as PeopleSoft), HR systems, and operational or clinical data sources.
Knowledge of physician productivity metrics (e.g., wRVUs) and healthcare financial data structures.

Technologies

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

Benefits

UUP annual location pay ($4000)

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:00 PM
Appointment Type: Permanent
Salary: $110,000-$120,000
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 must be met to maintain exemptions.
In addition to base salary, the position is eligible for $4000 UUP annual location pay, paid biweekly.
We are unable to sponsor candidates for work visas for this position.

View full job page →

Get Job Alerts

New jobs delivered to your inbox.