About this role
Salary: £36,000 - 36,000 per year
Requirements
- Proven experience gathering and translating business requirements from non-technical stakeholders
- Hands-on experience with Power BI, including DAX, Power Query and data modelling
- Experience developing and maintaining SSRS reports
- Solid SQL Server skills, including queries, joins, views and stored procedures
- Experience cleansing, validating and deduplicating data, and maintaining data integrity across relational databases and CRM systems
- Practical experience with ETL processes and integration tools such as SSIS and/or Azure Data Factory
- Experience with Microsoft Dynamics 365/CRM, ideally in legacy on-premises environments
- Experience using Power Automate for workflow and process automation
- Understanding of GDPR, data protection and data governance
- Experience managing data and reporting support requests through a helpdesk or ticketing system, prioritising and resolving issues within agreed SLAs
- Strong analytical and problem-solving skills, attention to detail and effective communication skills
- Desirable: experience with Microsoft Power Apps, Microsoft Fabric, Python scripting, cloud databases such as Azure SQL, REST APIs, and version control tools such as Git
Responsibilities
- Work with stakeholders to understand reporting requirements and translate business needs into technical specifications and data solutions
- Design, develop and maintain automated Power BI dashboards, interactive visualisations and operational SSRS reports
- Conduct data audits, cleansing, deduplication and validation to maintain accurate and reliable data
- Build, monitor and optimise ETL processes and data integrations using SSIS, Azure Data Factory and Power Automate
- Develop and maintain SQL queries, views and stored procedures to extract, structure and model data from business systems
- Support data delivery across Microsoft Dynamics 365, SQL Server and associated platforms
- Ensure data handling and processes comply with GDPR and our data protection policies
- Create and maintain standard operating procedures, data dictionaries and user training materials to support self-service BI
- Serve as the first point of contact for data, reporting and analytical support requests; manage tickets, prioritise work and resolve issues within agreed service levels
- Deliver data engineering, business intelligence, reporting and data support services across our organisation
Technologies
- Azure
- Business Intelligence
- Cloud
- CRM
- DAX
- ETL
- Fabric
- Support
- Marketing
- Power BI
- Power Query
- Python
- REST
- SQL
- SSIS
- Office 365
- Git
More
We are CIM, the Chartered Institute of Marketing, at the forefront of what is vital in marketing. Through qualifications, consultancy, sustainable working and thought leadership, our impact is felt far and wide. This Data Analytics & BI Engineer role is based in Cookham on a hybrid schedule of two office days and three remote days, with a salary of £36,000 plus benefits. We offer 25 days annual leave plus bank holidays (pro rata), a pension contribution scheme, training and development opportunities, life assurance, and wellbeing initiatives including an employee assistance programme. We welcome people of all backgrounds, experiences and identities and are committed to an inclusive workplace; we can support reasonable adjustments during recruitment. Our values are Confidence, Curiosity, Collaboration and Integrity.
last updated 46 week of 2026