✦ Luna Orbit — Data & Analytics

Performance Attribution Analyst

at Allstate

📍 Chicago River Point Hybrid 💰 $124K – $162K USD / year Posted March 29, 2026
Apply Now → ← Browse All Jobs

Position Details

Salary $124K – $162K USD / year
Type Full-Time
Experience mid
Exp. Years 5+ years
Education Not specified
Category Data & Analytics

About this role

Investment analytics role focused on performance attribution across fixed income and multi-asset portfolios, building production SQL queries and dashboards to communicate drivers of performance to senior management.

Key Responsibilities

  • Develop and maintain performance attribution frameworks across fixed income and multi-asset portfolios.
  • Perform top-down attribution analysis of a multi-strategy portfolio, comparing strategy allocations to a target benchmark.
  • Identify, document, and resolve data quality issues across investment systems and analytics platforms.
  • Translate attribution logic and analytics requirements into production ready SQL queries and stored procedures.
  • Build dashboards and reporting tools used by investment and risk teams.

Technical Overview

Stack includes SQL Server, Brinson-Fachler attribution methodologies, Python for analytics, and visualization via Tableau/Power BI; experience with Aladdin or similar platforms is a plus.

Ideal Candidate

The ideal candidate is a mid-senior investment analytics professional with 5+ years of experience, strong SQL (SQL Server), Brinson-Fachler attribution knowledge, and comfort with Aladdin or similar platforms; capable of delivering production-grade attribution and dashboards.

Must-Have Skills

5+ years of experience in investment analyticsProven expertise writing complex SQL queriesSQL Server preferredComprehensive understanding of performance attribution methodologiesStrong familiarity with fixed incomeequityand private assets attributionAbility to independently investigate data issuesCollaboration with investmentriskand technology teams

Nice-to-Have Skills

AladdinClearwatereFrontPythonTableauPower BICFACIPM

Tools & Platforms

SQL ServerAladdinTableauPower BIPython

Required Skills

Data IntegrityFixed Income AssetsInvestment AnalyticsInvestmentsSQLStructured Query Language (SQL)Brinson-Fachler attributionPerformance attributionRisk reportingPortfolio analyticsPythonTableauPower BIAladdinSQL Server

Hard Skills

SQLSQL ServerPerformance attributionBrinson style attributionData integrityInvestment analyticsRisk reportingPortfolio analyticsProduction SQL queriesStored proceduresData warehousePythonTableauPower BI

Soft Skills

Analytical thinkingAttention to detailCommunicationCollaborationProblem solvingOrganizational skills

Certifications

Preferred

CFACIPM

Industry & Role

Industry Financial Services
Job Function Provide data-driven performance attribution analytics and reporting for investment portfolios.
Role Subtype Performance attribution analyst
Tech Domains SQL / PostgreSQL, Python, Tableau, Power BI, Aladdin

Keywords for Your Resume

performance attributionbrinson fachlersqlsql serverdata integrityfixed incomeequitiesportfolio analyticspythontableaupower bialaddincfacipmrisk reportingdata warehousestored proceduresanalyticsinvestment analyticssql queriesSQL ServerSQLBrinson-FachlerAladdinPythonTableauPower BICFACIPM

Deal Breakers

Less than 5 years of investment analytics experience, Lack of SQL (especially SQL Server) experience, No familiarity with attribution methodologies

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile