Data Analytics & BI Engineer

Data Analytics & BI Engineer

Role:                       Data Analytics & BI Engineer

Location:              Cookham – Hybrid – 2 days office / 3 days remote

Salary:                   £36,000 + Benefits. 

As our Data Analytics & BI Engineer, you'll play a key role in delivering data engineering, business intelligence, reporting and data support services across CIM.

Working closely with stakeholders across the organisation, you'll translate business requirements into meaningful reports, dashboards and data solutions. You'll be responsible for developing and maintaining Power BI and SSRS reporting, managing data pipelines and integrations, and ensuring the accuracy, quality and integrity of our data.

You'll also act as a key point of contact for data and reporting-related queries, helping colleagues access and understand the information they need to make informed business decisions.

This is an excellent opportunity for an analytical and technically skilled professional who enjoys working with data, solving problems and turning complex information into valuable business insights.

What you'll be doing

Your key responsibilities will include:

• Stakeholder engagement: Work with business stakeholders to understand reporting requirements, translating business needs into clear technical specifications and effective data solutions.

• Business intelligence and reporting: Design, develop and maintain automated Power BI dashboards, interactive visualisations and operational SSRS reports.

• Data quality management: Carry out regular data audits, cleansing, deduplication and validation to maintain accurate and reliable data across CIM's systems.

• Data integration and pipelines: Build, monitor and optimise ETL processes and data integrations using SSIS, Azure Data Factory and Power Automate.

• Database management: Develop and maintain SQL queries, views and stored procedures to extract, structure and model data from legacy and modern business systems.

• CRM and business systems: Support data delivery across Microsoft Dynamics 365 (including legacy v8.2), SQL Server and associated platforms.

• Data governance: Ensure data handling and processes comply with GDPR and organisational data protection policies.

• Documentation and training: Create and maintain standard operating procedures, data dictionaries and user training materials to encourage the effective use of self-service BI tools.

• Helpdesk and user support: Act as the first point of contact for data, reporting and analytical support requests, managing tickets, prioritising workloads and resolving issues within agreed service levels.

What you'll bring

We're looking for a proactive and customer-focused data professional with strong technical expertise and the ability to turn business requirements into practical reporting and data solutions.

Ideally, you'll have:

• Proven experience gathering and translating business requirements from non-technical stakeholders.

• Strong hands-on experience with Power BI, including DAX, Power Query and data modelling.

• Experience developing and maintaining SSRS reports.

• Solid SQL Server skills, including writing queries, joins, views and stored procedures.

• Experience cleansing, validating, deduplicating and maintaining data integrity across relational databases and CRM systems.

• Practical experience with ETL processes and data integration tools, such as SSIS and/or Azure Data Factory.

• Experience working with Microsoft Dynamics 365 / CRM, ideally including legacy on-premises environments.

• Experience using Power Automate for workflow and process automation.

• A good 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.

• Excellent analytical and problem-solving skills, strong attention to detail and effective communication skills.

Desirable experience

It would be advantageous if you also have experience with:

• Microsoft Power Apps and Microsoft Fabric.

• Python scripting for data manipulation and automation.

• Cloud databases, such as Azure SQL, and REST APIs.

• Version control tools, such as Git, for managing SQL scripts and reporting templates.

What you’ll get:

• 25 days annual leave, plus bank holidays (pro rata)

• Pension contribution scheme

• Training and development opportunities

• Life assurance scheme

• Dedicated wellness initiatives and wellness hub that supports your wellbeing (including EAP)

CIM. The Chartered Institute of Marketing.  We are at the forefront of all that is vital in marketing.  From qualifications and consultancy to sustainable working and thought leadership, our impact is felt far and wide. 

We welcome applications from people of all backgrounds, experiences and identities. We are committed to creating an inclusive workplace where everyone feels they belong. If you require any reasonable adjustments during the recruitment process, please let us know and we'll be happy to support you.

CIM, we stand for better marketing. 

Values - Confidence, Curiosity, Collaboration and Integrity

Apply now to join our team!