Financial Modeling & Visualization Analyst

Lockton Companies; Chicago (IL); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Parental leave

Community involvement

Wellness events

Generous rewards

Job summary

Lockton Companies LLC is seeking a Data Visualization Analyst who builds financial models and interactive dashboards to empower clients and internal teams to make strategic decisions.

The role blends statistical modeling with visualization, taking ownership from development to production monitoring. Strong Python/R, SQL, and BI tool experience are essential for success and collaboration across teams.

Qualifications

• 2–5 years of professional experience in financial modeling, data analysis, BI, or analytics.
• Proficiency with Python, R, or both for data manipulation and modeling.
• Strong SQL skills to write efficient queries and manage complex datasets.
• Experience building forecasting or scenario models (regression, time-series, Monte Carlo).
• Hands-on experience with Tableau, Power BI, or similar BI platforms.
• Excellent written and verbal communication; translate questions into quantitative solutions.

Responsibilities

• Design and build financial forecasting and risk modeling solutions using Python, R, and SQL.
• Develop scenario models from requirements through validation and deployment.
• Transform model outputs into interactive dashboards and reports for clients and internal teams.
• Design intuitive interfaces guiding clients through model scenarios and insights.
• Monitor production models, ensure data quality, and document methodologies and assumptions.

Skills

Python

R

SQL

Tableau

Power BI

Analytical thinking

Communication

Education

Bachelor's degree in Finance, Economics, Data Science, Statistics, Math

Tools

Git

Tableau

Power BI

Job description

Lockton Companies LLC is seeking a Data Visualization Analyst who builds financial models and interactive dashboards to empower clients and internal teams to make strategic decisions.

The role blends statistical modeling with visualization, taking ownership from development to production monitoring. Strong Python/R, SQL, and BI tool experience are essential for success and collaboration across teams.