1872 Consulting
Sr. Financial Analyst - Data Analytics Focus
1872 Consulting, Chicago, Illinois, United States, 60290
Sr. Financial Analyst - Data Analytics Focus
Chicago, IL (Willis Tower 3 days/week & WFH 2 days/week)
Overview 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
#J-18808-Ljbffr
Overview 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
#J-18808-Ljbffr