What are the responsibilities and job description for the Data Analytics Consultant (Investment Banking) position at Phyton Talent Advisors?
Our client, a Global Investment Bank, is seeking a Data Analytics Consultant in their New York, NY location:
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.
Key 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.
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
• Proficiency in BI tools especially PowerBI and SQL, and writing DAX code for complex measures or ETL
• Good understanding of databases and OLAP cubes, to ingest required data into PowerBI 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:
• Masters 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
Salary : $69 - $70
