Data AnalystEngineer

The Vacancy

Data Analyst/Engineer

Hybrid London - City

Full time 12 Month FTC

Salary: Up to 75000

Job Purpose:

The Data Analyst will play a pivotal role in ensuring the integrity accessibility and usability of our data systems while contributing to the broader strategic goals of the organisation and will report to the Data Architect.

The directorate delivers outstanding services to members customers and the wider sector through a modern customer-centric approach. By leveraging innovative technology it provides an exceptional customer and member experience; harnesses the power of data to generate meaningful insights that create value for the Institute and its members; and delivers impactful programmes of work that drive sustainable value operational excellence and meaningful outcomes for stakeholders.

Key Responsibilities:

Data Analysis and Reporting

• Conduct detailed analysis of large datasets to identify trends anomalies and actionable insights.
• Collaborate with business units to understand data requirements and deliver solutions that align with their goals.
• Ensure data models support accurate and scalable reporting by configuring data integrity exception models and insights
• Develop and maintain Power BI dashboards reports and visualisations to provide insights for stakeholders.

Data Engineering

• Assist the Enterprise or Data Architect in designing building and maintaining scalable ingestion data pipelines for the integration of diverse systems.
• Optimise data workflows and processes to ensure efficiency and reliability.
• Collaborate on database design and support database optimisation to enhance performance and scalability.

Data Governance and Compliance

• Support the implementation of data governance frameworks to ensure data quality consistency and regulatory compliance.
• Work alongside the Data Architect to ensure data security measures align with GDPR and organisational policies.
• Monitor and maintain data accuracy through validation processes and cleansing activities.
• Assist in the management of data subject access requests and breach notifications as needed.
• Work with DPO to build Records of Processing Activity
• Assist the Data Architect with building data flow maps for business processes

Collaboration and Stakeholder Engagement

• Work closely with the Data Architect to align data solutions with strategic organisational goals.
• Collaborate with IT project managers and business analysts to support data-driven projects and ensure effective data utilisation.
• Work with business stakeholders to ensure effective data process maps are established for as is and to be states.
• Train business users on self-service analytics tools including Power BI to promote data literacy across the organisation.

Innovation and Continuous Improvement

• Identify opportunities to enhance data processing and reporting capabilities using modern tools and technologies.
• Stay up-to-date on emerging trends and best practices in data analysis engineering and visualisation.
• Proactively suggest and implement improvements to current data workflows and reporting processes.

Key Requirements:

Educational Background

• Required certifications in Power BI Azure Data Analytics or related data technologies
• Desirable bachelors degree in data science Computer Science Mathematics Statistics or a related field.

Essential Skills and Experience

• Proven experience in data engineer and analysis and reporting including advanced Power BI / MS Fabric/Power platform skills.
• In-depth knowledge of SQL for querying and managing relational databases.
• Hands-on experience with ETL/ELT processes data pipelines and database technologies (e.g. SQL Server Azure SQL My SQL DB2).
• Hands-on experience with big data technologies
• Knowledge of data modelling and schema design for both structured and unstructured data.
• Strong knowledge of GDPR compliance and data governance best practices.
• Proficiency in integrating and working with various systems including CRM and ERP platforms such as Microsoft Dynamics 365.
• Experience working in Agile and DevOps environments

Desirable Skills

• Basic understanding of cloud data management services (e.g. Azure AWS).
• Knowledge of data migration processes and legacy system integration.

Personal Attributes

• Strong analytical and problem-solving skills with a keen eye for detail.
• Excellent communication and interpersonal skills for cross-functional collaboration.
• A proactive mindset able to manage multiple priorities in a dynamic environment.
• A commitment to delivering high-quality results while ensuring compliance and data security.

Interview process:

We understand that taking time to prepare for and to attend interviews is a big commitment and want the process to be as transparent as possible.

You can expect the following process from us:

• A short introductory phone call from our Talent Acquisition team.
• A formal 1st Stage Teams interview with the representatives of Data and Business Solutions & Programme Delivery teams.
• A formal 2nd Stage (Teams/In-person TBC) interview with leadership representatives of the Business Solutions & Programme Delivery Team.

Application deadline:

We will review applications ona rolling basis and the position will close once we have secured a shortlist.

Next steps:

If you would like to explore this opportunity with us for the next step in your career we look forward to receiving your application through the Apply feature at the top of this advert.

If you have any queries or you would like to see the full JD please get in touch on

We are an inclusive employer and welcome applications from all backgrounds. If you require any reasonable adjustments during the recruitment process please let us know. We are committed to ensuring all candidates have equal access and opportunity in line with the Equality Act 2010.

Please note: At the CII we work with a carefully selected Preferred Supplier List (PSL) for recruitment. We do not accept speculative CVs and kindly request that agency recruiters do not contact our managers directly to ensure a consistent and properly coordinated recruitment process.

If you are interested in working with us in the future please contact We review our PSL at set intervals and are happy to retain details for consideration when opportunities arise.

Agencies who do not follow this process will be excluded from any future opportunities to work with us including PSL reviews.

The overarching purpose of the Chartered Insurance Institute (the Institute) is to educate and support our members to deliver services to the highest professional standards and to advocate for the public good. By doing this the Institute builds and maintains public trust in the insurance financial planning and mortgage advice professions.

Our vision is that CII and PFS professionals build a world which delivers ever greater financial resilience for individuals and societies more broadly.