1872 Consulting
Data/Financial Analyst
1872 Consulting, Chicago, Illinois, United States, 60290
Data/Financial AnalystNew York City (midtown) – WFH 2 days/week
SummaryWe are an industrial real estate supply chain platform that is growing rapidly in the real estate industry.
You will be working on a team of 4 to develop
the annual budget and quarterly property NOI reforecasting processes that involves planning; supporting budgeting and forecasting tools; determining financial goals and related guidance; communicating process and guidance to teams in the field; and reporting on results to field teams and senior management.
You will be the most technical person on this team, responsible for developing the analytics and data visualizations for the FP&A group.
What you'll be doing
Gather, synthesize, and analyze financial and operating information through recurring and ad hoc reports.Improve Link's financial and operational reporting through enhanced data quality testing, automation of processes, and leveraging of our Snowflake-based data platformServe as the Capital Markets team's primary liaison with Link's Data & Analytics and Research teams, partnering with them in the build-out of Link's dashboard and analytical platformsPrepare visualizations that effectively communicate trends, patterns, and predictions using relevant dataCommunicate results and conclusions of analyses through Excel tables, PowerPoint charts, PowerBI dashboards, and brief write-ups.Develop value add tools and assist in system and process improvement projects as needed.Work with large quantities of data and master ability to analyze and audit results.Understand and master a multitude of financial systems and processes to provide support and training as needed.Perform special ad hoc projects and analysis on a frequent basis.Understand the Budgeting & Forecasting systems process and play an important role in training and assisting the Asset Management team during the Budgeting & Forecasting processSkills we're seeking
Bachelor's Degree1-5 years of experience as a Data Analyst, Data Scientist or Financial Analyst focused on delivering data solutionsProficient with ExcelExperience with Power BI, Tableau, Python and/or RExperience working as a financial analyst, or as a data analyst in the finance department or the finance industry (working with financial data)Nice to haves
Experience with data warehouses (ideally Snowflake, as that's what we use) or relational databasesSQL experience (writing queries)Real estate experience
#J-18808-Ljbffr
SummaryWe are an industrial real estate supply chain platform that is growing rapidly in the real estate industry.
You will be working on a team of 4 to develop
the annual budget and quarterly property NOI reforecasting processes that involves planning; supporting budgeting and forecasting tools; determining financial goals and related guidance; communicating process and guidance to teams in the field; and reporting on results to field teams and senior management.
You will be the most technical person on this team, responsible for developing the analytics and data visualizations for the FP&A group.
What you'll be doing
Gather, synthesize, and analyze financial and operating information through recurring and ad hoc reports.Improve Link's financial and operational reporting through enhanced data quality testing, automation of processes, and leveraging of our Snowflake-based data platformServe as the Capital Markets team's primary liaison with Link's Data & Analytics and Research teams, partnering with them in the build-out of Link's dashboard and analytical platformsPrepare visualizations that effectively communicate trends, patterns, and predictions using relevant dataCommunicate results and conclusions of analyses through Excel tables, PowerPoint charts, PowerBI dashboards, and brief write-ups.Develop value add tools and assist in system and process improvement projects as needed.Work with large quantities of data and master ability to analyze and audit results.Understand and master a multitude of financial systems and processes to provide support and training as needed.Perform special ad hoc projects and analysis on a frequent basis.Understand the Budgeting & Forecasting systems process and play an important role in training and assisting the Asset Management team during the Budgeting & Forecasting processSkills we're seeking
Bachelor's Degree1-5 years of experience as a Data Analyst, Data Scientist or Financial Analyst focused on delivering data solutionsProficient with ExcelExperience with Power BI, Tableau, Python and/or RExperience working as a financial analyst, or as a data analyst in the finance department or the finance industry (working with financial data)Nice to haves
Experience with data warehouses (ideally Snowflake, as that's what we use) or relational databasesSQL experience (writing queries)Real estate experience
#J-18808-Ljbffr