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 attuned to client needs

• Drive, enable and support the business, partnering with our leaders, clients, and consultants across our practices to take the best of emagine to our clients through opportunity identification/qualification, solution development/presentation