Senior Financial Data & Analytics Engineer

Stony Brook University, onsite in Stony Brook, NY, is seeking a Senior Financial Data & Analytics Engineer to design, develop, and maintain the School of Medicine's enterprise financial data infrastructure and analytics solutions. The role focuses on building data pipelines, integrating enterprise systems, and delivering executive-level dashboards, exercising significant independent judgment to architect scalable, secure, high-performance analytics that support institutional financial strategy.

Salary

USD 110,000 - 120,000 per year

Location

Stony Brook, NY (onsite)

Schedule

Full-time, Day Shift, 8:30 AM - 5:00 PM

Responsibilities

• Design and implement a centralized financial data warehouse that unifies PeopleSoft, HR, CPMP, Report Center, SOMDASH, and external data feeds.
• Develop and maintain ETL/ELT pipelines for structured and semi-structured data.
• Develop and oversee API-driven data ingestion pipelines.
• Ensure the data architecture scales, performs reliably, and remains robust.
• Collaborate with IT and enterprise data teams on infrastructure and platform design.
• Create analytics models for physician productivity using wRVUs, reimbursement patterns, and compensation.
• Incorporate benchmarking data such as Vizient for comparative performance analysis.
• Develop predictive and trend models to inform financial planning.
• Analyze payer mix, revenue cycles, and departmental cost structures.
• Design data models that support funds flow, ROI analysis, and All-Funds reporting.
• Develop multi-dimensional datasets combining clinical, academic, and financial data.
• Create 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 as assigned in support of departmental and institutional research missions.

Requirements

• Bachelor's degree or higher in Data Science, Computer Science, Information Systems, Finance, Economics, or a related field.
• At least five years of full-time experience in data engineering, data analytics, or financial analytics within healthcare or enterprise environments.
• Experience with SQL and relational database systems, data warehouse design (including dimensional modeling and star schemas), ETL/ELT pipeline development, API integration and data ingestion, and BI platforms such as Tableau or equivalents.
• Experience integrating data across ERP systems (e.g., PeopleSoft), HR systems, and operational/clinical datasets.
• 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 ($4,000)