Sr. Financial Analyst - Data Analytics Focus

Sr. Financial Analyst - Data Analytics Focus

Chicago, IL (Willis Tower 3 days/week & WFH 2 days/week)

The Senior Financial Analyst – Data Analytics role requires a highly detail-oriented individual who is an analytical thinker, problem-solver, and a team player. This role will support the Director of Finance Operations and the FP&A Team. They will be supporting major FP&A processes by designing and developing tools, techniques, metrics, and dashboards for insights/data visualization. Advanced knowledge of extracting data from traditional data warehouse, Power BI dashboard creation, Excel/PowerPoint, and financial modeling. This role will support the budget and reforecast processes and projects that drive insight into financial performance, identify opportunities to enhance asset value, and create efficiencies through report automation.

What You'll Be Doing

• The Senior Analyst will be responsible for partnering with the asset management, executive and finance teams to translate the business needs to design and develop tools, techniques, metrics, and dashboards for insights/data visualization to effect company change
• Leverage Snowflake and other data sources to automate reporting, financial analysis and facilitate major FP&A processes such as forecasting and budgeting
• Own critical comprehensive analysis functions using statistical and financial techniques to create and manipulate complex datasets to identify trends, issues, opportunities, develop performance reports, financial statements, budgets, forecasts, and internal management reports
• Use Power BI (or other BI tools) to help the team make better decisions and Identify opportunities to unlock value
• Display complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner
• Track outcomes and portfolio performance in accordance with budget and strategic direction

Skills We're Seeking

• Bachelor's Degree, ideally in a Finance/Accounting or IT/Data field
• 2+ years with Data Analysis/Business Intelligence focused on extracting data and creating dashboards
• Must be comfortable with SQL (writing queries)
• At least 1+ year of experience working with financial data, and doing financial modeling
• Excellent communication
• Passion for creating business value and solving problems through data

• Power BI experience
• Snowflake experience, or experience extracting data from other cloud data warehouses
• Real estate experience