Data Analyst – Associate

cer Financial; London; On-site; GBP 35,000 - 55,000; Full time

Job summary

A leading firm in leveraged finance is seeking a Data Analyst – Associate for their London team. This role involves data management, visualisation, and system optimisation using advanced tools such as Tableau and Power BI. The successful candidate will have strong technical skills, a relevant degree, and experience within financial or professional services, aiming to enhance data accuracy and reporting efficiency in collaboration with key stakeholders.

Qualifications

• 2-3 years of experience in data analysis or similar role.
• Strong SQL server knowledge for effective querying.
• Extensive experience in data cleansing and optimisation.

Responsibilities

• Craft and execute data queries, maintaining master data across platforms.
• Utilise Tableau and Power BI for insightful reporting.
• Collaborate with stakeholders to clarify data requirements.

Skills

Data Analysis

SQL Server

Data Visualisation

Data Optimisation

Problem Solving

Communication

Education

Bachelors Degree in Engineering, Data Science, Computer Science or related field

Tools

Tableau

Power BI

Microsoft Power Apps

Power Automate

SharePoint

Job description

Social network you want to login/join with:

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)
• 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