This job has closed.

Allstate · 4 days ago

Financial Analysis Senior Consultant I

United States

Full-time

Remote

Mid, Senior Level

$66K/yr - $110K/yr

3+ years exp

Allstate is a company dedicated to protecting families and their belongings from uncertainties. They are seeking a Financial Analysis Senior Consultant I who will analyze financial results, develop insights, and recommend actions to guide strategy and operations.

BankingFinanceFinancial ServicesInsuranceInsurTechVenture Capital

No H1B

Responsibilities

Isolate financial key drivers, quantify impacts, and forecast implications to the business recognizing how different data points fit together and integrating cross functional knowledge and/or sources

Collaborate with business partners to understand underlying trends and initiatives and build comprehensive storylines to explain financial results

Manage analysis projects of low to moderate complexity, addressing ambiguous business issues

Use analysis to influence and drive action within finance, leadership and our business partners by using fact-based, holistic and forward-looking perspectives to identify emerging issues and current trends, and assist in implementation of strategies

Provide accurate, timely reports with financial insight to support business partner decisions and performance improvement

Develop and participate in effective presentations

SQL Data Extraction & Filtering: The ability to use SELECT statements to pull specific data and WHERE clauses to filter relevant information, such as sales by country or profit by product

SQL Data Transformation: Using functions to clean, re-format, and convert data types, such as extracting years and months from date columns. Joining Multiple Tables: Combining data from different sources, like transaction data with market data, to gain a comprehensive view of financial performance

SQL Data Aggregation and basic calculation: Using GROUP BY clauses and functions like SUM() and AVG() to calculate total revenue, profit margins, or other key financial metrics

SQL Complex Queries: Writing more advanced queries with conditional logic (like CASE statements) to analyze trends, identify high-cost products, or perform customer segmentation

Qualification

SQLFinancial AnalysisFinancial ForecastingAdvanced ExcelPower BISAP S/4HanaBusiness StorytellingTrend AnalysisVariance AnalysisCollaborationInterpersonal SkillsTime ManagementCommunication Skills