Business Data Analyst

eFinancialCareers; Greater London; On-site; GBP 101,000 - 111,000; Full time

Benefits offered by this job

Hybrid working model

Job summary

emagine is seeking a hands-on Data Business Analyst to drive data migration and transfer across systems within a regulated financial services context. You will collaborate with stakeholders to define data requirements, map transformations, and ensure data quality and governance throughout the migration lifecycle.

The role involves working with data engineers on ETL, producing reports and dashboards, and ensuring compliance with GDPR and related standards.

Qualifications

• Experience leading data migration or data transfer projects.
• Strong SQL querying, validation and reconciliation.
• Experience with ETL tools and data transformation.
• Understanding of data modelling and relational databases.
• Proficiency with BI tools for data visualisation.
• Knowledge of data governance, quality and compliance.
• Familiarity with cloud data platforms (AWS/Azure/GCP).
• Ability to translate business needs into data specifications.

Responsibilities

• Collaborate with stakeholders to gather and document business data requirements for data migration and data transfer.
• Analyse data structures, processes, data flows to identify gaps and risks for migration.
• Define mapping, transformation rules, and validation criteria for data transfer and migration.
• Work with data engineers to ensure ETL extraction, transformation and loading.
• Support data reconciliation, integrity checks, cleansing to ensure quality.
• Identify discrepancies and align with business rules.
• Assist in profiling and lineage documentation.
• Translate requirements into actionable data specifications for transfer team.
• Provide reports and dashboards to track progress and data integrity.
• Ensure activities align with data governance and regulatory requirements.
• Collaborate with risk/compliance to ensure audit readiness.
• Assist in strategies for retention, archiving, decommissioning.

Skills

SQL

Data modelling

Data governance

Stakeholder management

Data analysis

Cloud data platforms

Tools

Power BI

Tableau

ETL tools

AWS

Azure

Google Cloud

Alteryx

Informatica

Denodo

Power Query

Job description

Data Business Analyst

London x2-3 Days on-site

£550-600 p/d Inside

emagine is a high-end professional services consultancy and solutions firm Specialising in providing business and technology services to the financial services sector, we power progress, solve challenges and deliver real results through tailored high-end consulting services and solutions.

We have created a culture of openness and integrity by building genuine and strong relationships and partnerships, enabling us to be uncompromising in our dedication in delivering the optimal service for our clients. Our commitment is not just towards our clients but we aim to foster a positive and equitable working environment with our consultants and colleagues which stems from our core values: Confident, Dedicated, Responsible, Genuine.

We are seeking a hands-on Business Data Analyst with expertise in data migration and data transfer to support a transformation programmes, ensuring accurate, compliant, and efficient movement of data across systems while driving data quality, governance, and migration best practices.

Responsibilities:

• Collaborate with stakeholders to gather and document business data requirements for data migration and data transfer.
• Analyse current and future data structures, business processes, data flows, and dependencies to identify gaps and risks and ensure smooth data transition /transfer.
• Define data mapping, transformation rules, validation criteria and business logic for data transfer and data migration projects.
• Work closely with data engineers and migration teams to ensure accurate data extraction, transformation, and loading (ETL).
• Support data reconciliation, integrity checks, validation, and cleansing activities to ensure quality and consistency.
• Identify and resolve data discrepancies and ensure alignment with business rules.
• Assist in data profiling and data lineage documentation to track historical changes and data movements.
• Translate business requirements into actionable data specifications for the transfer/migration team.
• Provide reports, dashboards, and insights to track data transfer/data migration progress and data integrity.
• Ensure all data transfer/data migration activities align with data governance policies and regulatory compliance requirements.
• Work with risk and compliance teams to ensure migrated data meets audit and reporting standards.
• Assist in developing strategies for data retention, archiving, and decommissioning of legacy systems.

Key Requirements:

• Proven experience in data migration or data transfer/transition projects, preferably within financial services or regulated industries.
• Strong SQL skills for data querying, validation, and reconciliation.
• Experience with ETL tools and data transformation techniques.
• Solid understanding of data modelling, data structures, and relational databases.
• Proficiency in BI/reporting tools (e.g., Power BI, Tableau) for data visualisation.
• Strong stakeholder management and ability to translate technical concepts for business users.
• Knowledge of data governance, data quality, and compliance frameworks (e.g., GDPR, BCBS 239).
• Experience with cloud data platforms (AWS, Azure, or Google Cloud) is a plus.
• Understands the principles of Data Governance and Data Quality, Data Remediation.
• Documentation and Requirements Gathering.

Nice to Have:

• Familiarity with tooling (Alteryx, Informatica, Denodo, Power Query, Power BI, Tableau).
• Experience with Microsoft technology.

Our people

The ideal consultants will share our values and be aligned with our ways of working and as your career progresses, you can expect to work across all areas of the project lifecycle, from strategy to implementation. This will provide you with a broad base of experience from which to build an outstanding career.

The ideal consultants will share our values and be aligned with our ways of working and as your career progresses, you can expect to work across all areas of the project lifecycle.

We pride ourselves on;

• Providing our people with a supportive culture, rooted in our values and driven by our purpose.
• Promoting a culture of inclusion, collaboration, well-being, and learning and development.
• Providing increased agility and flexibility within our hybrid working model
• Investing in employees' growth through ongoing training and development
• Autonomy to take ownership of projects, making decisions and demonstrating individual expertise
• Providing an transparent performance and career management experience.

Our consultants are integral to delivering successful consulting engagements, addressing our clients' most pressing business challenges, and build lasting value in disciplines such as:

• Solve sophisticated, ambiguous business, change and technology problems, bringing structure and meticulous analysis and planning, acting, and taking decisions with little strategic direction
• Build, develop and sustain trusted senior client relationships in the C-suite by remaining highly attu