Description

You will act as the internal expert for data mining, processing, reconciliation, and analysis to drive strategic data frameworks.

Responsibilities

• Maintain data integrity across Salesforce CRM and the client data warehouse.
• Monitor daily data feeds to verify the accuracy of customer, facility, and deal data.
• Design and develop business requirements for financial reports, dashboards, and visualizations in Power BI.
• Develop and maintain data controls to ensure the accuracy and consistency of management reporting.
• Identify trends and patterns across multiple systems to improve business operations efficiency.

Required Skills

• 5+ years of relevant experience in data science, data analytics, or business intelligence.
• Advanced MS Excel proficiency, including nested formulas, macros, pivot tables, look-ups, and VBA.
• Strong SQL skills, including writing database queries and stored procedures.
• Experience with Power BI for dashboarding and visualization.
• Expertise in relational databases and online analytical processing (OLAP) tools.
• Experience with data mining, data quality assurance, and managing large, complex datasets.
• Proficiency with SQL Server Integration Services (SSIS) and Analysis Services (SSAS).
• Bachelor's degree or higher in Data Science or Computer Science.

Preferred Skills

• Knowledge of Salesforce, Qlik, Dealogic, Capital IQ, and SAS.
• Working knowledge of investment/corporate banking and capital market products.

Key Skills

Education

Bachelor's degree or above in data science, computer science