Job Description
Job Description
JOB TITLE: Finance Data Analytics
LOCATION: New York City
Main Skills: Power BI, Dashboard creation, constructing and design new metrics and measures
Work schedule: Hybrid – Alternate weeks staggered Thurs – Fri
Main Skills: High Power BI dashboarding skills, experience in finance industry and can articulate well to non-technical audience.
· Bachelor’s degree in Finance, engineering or a related field
· Finance Data Analytics Consultant
· Main Skills Power BI, validate data and have soft skills knowledge of cost center, expenses that are part of EPM.
· Data analyst to work on the business side
· Part of project in which they are converting from Hyperion to Oracle EPM
· Run reports and validate migration of data is done correctly
· Build a dashboard that keeps track of validation. Build reports and track UAT of data that is migrated.
Job Description:
· We are seeking a skilled Data Analytics Consultant to support Finance in a critical implementation of a EPM tool called OneStream and decommissioning existing Oracle-based Hyperion Financial Management (HFM). There is already a System Integrator (SI) and a project roadmap in place. The ideal candidate has experience in investment banking industry, is skilled in data validation and designing Power BI dashboards. This role requires both business and technical expertise, a meticulous approach to data accuracy, and the ability to collaborate with cross-functional teams during a transformative phase.
Job Responsibilities:
· Partner with finance, IT and 3rd party system integrator (SI) to validate data integrity during the one-time data migration, ensuring accuracy in financial records, hierarchies, and reporting structures.
· Execute data validation and UAT test scripts provided by SI, reconciling discrepancies between legacy Hyperion data and OneStream outputs.
· Design, build, and maintain interactive Power BI dashboards using data extracted from OneStream, to automate reporting and deliver actionable insights on revenue, expense, and balance sheet datasets.
· Train end-users on Power BI dashboards and OneStream reporting functionalities to support adoption.
Technical Skills:
· Basic Qualifications:
· Bachelor’s degree in Finance, engineering or a related field
· 3+ years of experience in business intelligence, data analysis, or a related role in financial services industry
· Power BI dashboarding skills
· Proficiency in BI tools especially Power BI and SQL, and writing DAX code for complex measures or ETL
· Good understanding of databases and OLAP cubes, to ingest required data into Power BI semantic layers
· Excellent problem-solving skills and attention to detail
· Story-telling and presentation skills to engage both technical and non-technical audiences.
· Preferred Qualifications:
· Master’s in Data Analytics or a related field
· Knowledge of General Ledger concepts (profit/cost center, trade books, variable, allocated, direct expenses etc) at an investment bank
· Experience with EPM tools such as Hyperion and OneStream and ERP tools such as SAP
Company DescriptionFinancial Data Analytics Consultant experienced with Power BI for dashboard creation, constructing and designing new metrics and measures for a financial services organization in NYC.
Company Description
Financial Data Analytics Consultant experienced with Power BI for dashboard creation, constructing and designing new metrics and measures for a financial services organization in NYC.