PowerBI Finance Data Analyst
PowerBI Finance Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 63 - 67
1 Vacancy
Job Description
Our client a major bank in New York City is looking for Finance Data Analytics Consultant with strong PowerBI and SQL skills.
This is hybrid commute to NYC Office midtown location.
6 months initial contract with possible extensions or option to hire.
** Must be authorized to work for ANY employer in US NO H1 Visa support for this role
Rate: $6367 on W2 possible C2C as well.
Job Description:
Data Analytics Consultant to support Finance in a critical implementation of a EPM tool called OneStream and decommissioning existing Oraclebased 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 crossfunctional teams during a transformative phase.
Key Responsibilities:
- Partner with finance IT and 3rd party system integrator (SI) to validate data integrity during the onetime 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 endusers on Power BI dashboards and OneStream reporting functionalities to support adoption.
Basic Qualifications:
- Bachelors 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 problemsolving skills and attention to detail
- Storytelling and presentation skills to engage both technical and nontechnical 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
Required Experience:
IC
Employment Type
Full Time
