Data Analyst – Associate

Job Description

Data Analyst – Associate

City of London

Contract

£350.00 per day

cer Financial are working alongside an international bank, within their leveraged finance origination team based in the City of London. They are looking for a Data Analyst – Associate to work with them on a contract basis to capture, record, reconcile and maintain a master data set.

The responsibilities of a Data Analyst – Associate will include:

Data Queries and Management: Craft and execute data queries upon request, maintaining consistent master data across all necessary platforms including DealCloud and various other databases. You will be expected to resolve data inconsistencies and errors, performing root cause analysis when needed. Data Visualisation and Reporting: Utilise Tableau and Power BI to present information through insightful reports and visualisations. Moreover, the data analyst will be tasked to provide both standard and complex reporting based on a defined set of metrics. CRM System Optimisation: Gain a comprehensive understanding of our CRM System (DealCloud) and leverage this knowledge to optimise the system for better efficiency and user experience. Utilisation of Microsoft Tools: Employ Microsoft Power Apps, Power Automate, and SharePoint sites for automation, process optimisation, and improving data accessibility. Data Cleansing and Optimisation: Perform Tasks related to data cleansing and optimisation to ensure our master data is accurate, complete, and consistent at all times. Part of the Data Analyst role will also involve conducting regular data audits to uphold data accuracy and quality. Stakeholder Collaboration: Work closely with key business stakeholders and Group IT to capture, clarify and address data-related requirements and potential issues. Continuous Improvement: Identify areas of improvement in our data management practices.

The successful Data Analyst – Associate will have:

Bachelors Degree in Engineering, Data Science, Computer Science or related field. 2 -3 years of experience as a Data Analyst, Business Intelligence Analyst, CRM Data Analytics experience, or similar role (financial services or professional services domains preferred) Tableau Certification Required Strong SQL server knowledge and experience to perform effective querying. Expertise in CRM systems such as Salesforce/ DealCloud Advanced Proficiency in Microsoft Power Apps, Power Automate, Excel and SharePoint Sites Extensive experience in data analysis, data optimisation and data cleansing Strong experience in diagnosing data-related issues, with the ability to work through systems and interfaces to identify the root cause. Excellent communication skills, both verbal and written Ability to translate business needs into technical specifications Strong problem-solving skills and attention to detail Diligent work ethic, resourcefulness, ability to multitask and is team oriented