Key Responsibilities
- Working with another Data Analyst to deliver a data management program.
- Writing and using queries for mass data cleansing and enrichment projects.
- Working with MBD to capture and analyse data to measure ROI on MBD activities.
- Collaborate with other departments to share data to deliver client analytics and reporting.
- Building management reports with accurate BD data to support strategic decision making.
- Bring together multiple internal and external data sets to identify trends, track pipeline and identify opportunities.
Skills, Knowledge and Expertise
- Ability to review, analyse and manage large volumes of data
- Strong organisational skills and ability to understand requirements and prioritise
- Excellent communication skills with both technical and non-technical audiences
- An aptitude for analysis and client reporting
- Curiosity and desire for continuous learning
Essential
- A relevant statistics, computer science or mathematics degree or equivalent
- Knowledge of InterAction or CRM database structures
- Advanced knowledge of Excel (pivot tables)
- Knowledge of SQL, Python or other programming languages
- Familiarity with APIs. REST, GraphQL
- Experience with reporting tools PowerBI and SSRS
- Knowledge of Vuture, Aderant or ViewPoint
- Understanding of other sources of marketing data such as Google Analytics, LinkedIn
- Experience in professional services
About Ogier
Department
Business Development
Employment Type
Permanent
Location
London
Workplace type
Hybrid