Data Analytics Specialist

Federal Reserve Bank of Philadelphia•New York, NY

4d•Onsite

About The Position

The Data Analytics Specialist designs, develops and implements business-driven analytical products such as models, reports, workflows and dashboards. You will work closely with People Leaders, business stakeholders to understand the decisions, opportunities, and challenges they are navigating, frame analytical questions, develop and test hypotheses, analyze workforce data, and communicate findings, implications, and recommendations in a clear and actionable way. Build strong partnerships with the Bank's technology providers with an eye toward integrating products with the Bank-wide analytics architecture.

Requirements

Root Cause Analysis (RCA)
Alteryx (data prep/ETL workflows)
Tableau / Power BI (dashboarding and visualization)
SQL (data querying, joins, aggregations across relational databases)
Python or R (data manipulation, automation, statistical analysis)
Workday Reporting & Discovery Boards (People Analytics-specific reporting)
Excel (advanced functions, pivot tables)
Predictive modeling / forecasting (e.g., attrition risk, headcount planning)
Statistical analysis (regression, correlation, hypothesis testing)
Data cleansing, validation, and integrity auditing
ETL / data pipeline development and maintenance
Workforce analytics methodologies (succession modeling, span-of-control analysis, org design metrics)
Trend and variance analysis for compensation/market benchmarking
Data governance frameworks and standards (metadata management, data lineage)
Experience integrating disparate data sources into unified reporting environments
Familiarity with data warehousing concepts (e.g., star schema, data marts)
Translating ambiguous business questions into structured analytical requirements
Data storytelling — building narrative-driven presentations for non-technical stakeholders

Responsibilities

Designs, develops and implements business-driven analytical products such as models, reports, workflows and dashboards.
Works closely with People Leaders and business stakeholders to understand decisions, opportunities, and challenges.
Frames analytical questions, develops and tests hypotheses.
Analyzes workforce data.
Communicates findings, implications, and recommendations in a clear and actionable way.
Builds strong partnerships with the Bank's technology providers with an eye toward integrating products with the Bank-wide analytics architecture.