Job #1641: Financials/Data Analyst - New Jersey/Remote (7-6-21)
Job TitleFinancials/Data Analyst
Viventium Software is seeking a Financials/Data Analyst in Berkeley Heights, New Jersey.
They are looking for a savvy Financial Analyst to join their growing team who will be responsible for extracting raw data across multiple systems, consolidating and optimizing it into a usable format for presentations and other reporting including productivity metrics and productivity improvement analysis. The ideal candidate is a problem solver with experience in working with data in Excel and creating pivot tables, VBA and/or other systems and who enjoys data optimization and data cleansing using formulas. The Financial Analyst will support the team as needed with monthly closing, financial reporting, forecasting, and other reporting. This individual must be self-directed, solution-oriented and comfortable supporting the data needs of multiple teams, systems and products.
Essential Duties and Responsibilities
The essential functions include, but are not limited to the following:
Extract data from primary or secondary data sources and maintain databases, data integrity and handle data loads Create financial models in excel from concepts that can be used company wide Interpret data and analyze results using statistical techniques Develop and implement data collection and data analysis systems and other strategies that optimize statistical efficiency and quality Improve report automation Define and report on productivity metrics and targets by department Deliver detailed expenses report & analysis with major focus on headcount, KPI metrics and dashboards Maintain rolling forecast of headcount costs Improve KPI reporting process:
- Define and improve Board reporting package
- Facilitate consistent and timely delivery of required data elements to department heads
Present periodical financial reports to direct supervisor with detailed commentary on the variance analysis in comparison with plan and forecast. Partner with sales team in tracking and reporting sales pipeline and provide key sales metrics on a weekly basis to direct report Enhance client retention reporting with information on NJ vs. BK offices Actively engage in development of business plan and budgeting process
- Support senior management with ad hoc analysis as needed
Minimum Qualifications (Knowledge, Skills, and Abilities)
Advanced MS Excel knowledge including pivot tables, formulas and VBA code (Visual Basis for Application) Experience with writing macros, including macros that take user input (user interface experience is a plus) Strong analytical skills related to working with unstructured data A successful history of manipulating, extracting and merging data from discounted datasets
Interested candidates should e-mail resume to Addy Kotwal at email@example.com. Please mention that you are a member of EisnerAmper's Friends of the Firm program. Make sure to include Job #1641 in the subject line and to copy firstname.lastname@example.org on your email.