Junior Data Analyst

Job Title: Junior Data Analyst (Data Migration & Quality)
Location: Dublin, Ireland (Hybrid – 3 days onsite per week)
Contract Type: 6-Month Initial Contract (High likelihood of extension)
Industry: Banking / Financial Services

About the Role
We are seeking a proactive Junior Data Analyst (2–4 years’ experience) to join a high-profile, large-scale banking transformation programme with a leading financial institution in Dublin.
This hands-on role centres on data migration, data quality, testing, reconciliation, and issue resolution. Working closely with cross-functional business stakeholders, technical teams, and Subject Matter Experts (SMEs), you will ensure that critical financial datasets are clean, reconciled, thoroughly tested, and ready for migration.

Key Responsibilities

• Data Cleansing & Reconciliation: Perform hands-on data extraction, cleansing, transformation, and validation to ensure complete accuracy across legacy and target platforms.
• Issue Investigation & Root-Cause Analysis: Proactively identify data anomalies, discrepancies, and quality defects; collaborate with technical and business teams to trace root causes and track issues through to final resolution.
• Testing & UAT Support: Support User Acceptance Testing (UAT) cycles, execute validation test cases, document results, and track defects in issue logs.
• Documentation & Audit Readiness: Maintain comprehensive documentation, including field-level data mappings, data dictionaries, issue trackers, test evidence, and audit trails.
• Stakeholder Engagement: Act as an active liaison between technical workstreams and business SMEs, confidently asking clarifying questions, following up on dependencies, and resolving roadblocks.
• Workstream Management: Balance multiple concurrent tasks and deliver against strict project milestones within an active transformation environment.

Required Skills & Experience

• Experience: 2–4 years of demonstrable experience as a Data Analyst, Junior Technical Analyst, or Data Migration Analyst.
• Advanced Excel & Power Query: High proficiency with intermediate to advanced Excel functions (XLOOKUP, INDEX/MATCH, SUMPRODUCT, nested IF/IFS) and hands-on experience using Power Query for data wrangling, cleansing, and automated preparation.
• SQL Proficiency: Practical SQL querying skills to extract, filter, join, and inspect relational datasets for validation and audit checks.
• Data Validation & Quality Assurance: Solid background in data reconciliation, exception handling, and structured defect tracking.
• Communication & Organization: Strong interpersonal skills with the confidence to communicate with business stakeholders, maintain ownership of tasks, and meet tight delivery schedules.

Desirable / Advantageous Skills

• Previous experience within banking, credit, regulatory reporting, or broader financial services transformation projects.
• Hands-on exposure to dedicated data migration toolsets or cutover programmes.
• Working knowledge of Power BI for reporting or building validation dashboards.