Profile source and target data to find quality issues and migration risks
Write source-to-target mapping specs and migration validation rules
Run UAT, mock migrations and source-to-target reconciliations
Investigate anomalies and duplicates and recommend root-cause fixes
Prepare functional, technical and test documentation that meets audit rules
From the employer’s posting
Perform data analysis and profiling of source and target systems.
Develop source-to-target data mapping specifications.
Execute UAT, mock migrations, and production migration validation.
Investigate root causes and recommend remediation actions.
Ensure documentation complies with governance and audit requirements.
Education & alternatives
- Support project governance, reporting, and issue resolution.
Requirements:- Bachelor's Degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related discipline.
- Minimum 10 years of experience in Data Analysis, Data Migration, Data Management, or related data-focused roles.
About ABeam Consulting
Abeam Consulting is a global professional services company that specializes in delivering business transformation and technology solutions to clients across a wide range of industries.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications. We count a repost when the same title and location comes back as a new listing within 60 days of the last one coming down. Some hiring systems expire listings on a schedule, so repost rates vary by system.
How this job compares
Time since we first saw it
Day 5
543
Similar jobs usually come down between day 5 and day 43.
At ABeam Consulting, jobs usually come down by about day 35.
From 16,008 similar postings that came down, and 34 of ABeam Consulting’s. Coming down is not always a hire.
ABeam Consulting is hiring
10 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
SQL
Power BI
SQL Server
Where the posting names them
- Minimum 10 years of experience in Data Analysis, Data Migration, Data Management, or related data-focused roles.
- Strong hands-on experience with Microsoft SQL Server and advanced SQL development.
- Proficient in complex SQL queries, including joins, stored procedures, functions, views, CTEs, performance tuning, and data validation.
- Strong hands-on experience with Microsoft SQL Server and advanced SQL development.
- Proficient in complex SQL queries, including joins, stored procedures, functions, views, CTEs, performance tuning, and data validation.
- Strong understanding of relational databases, data modelling, data warehousing concepts, and data migration methodologies.
- Knowledge of data governance, data quality frameworks, and data management principles.
- Familiarity with Power BI or other reporting and analytics tools.
- Experience working in multinational banking or financial services environments is preferred.
Abeam Consulting is a global professional services company that specializes in delivering business transformation and technology solutions to clients across a wide range of industries. With a global presence and over 9000 employees worldwide we aim to be the transformation partner of choice for all of our clients.
Key Responsibilities: Data Analysis & Data Profiling
Perform data analysis and profiling of source and target systems.
Analyze customer, KYC, onboarding, and reference data to identify data quality issues and migration risks.
Conduct data discovery to understand data structures, relationships, and dependencies.
Define data quality metrics and baseline assessments.
Data Mapping & Migration Design
Develop source-to-target data mapping specifications.
Translate business requirements into functional and technical specifications.
Define migration rules, transformation logic, and validation criteria.
Work with stakeholders to resolve data mapping issues and gaps.
Technical & Functional Documentation
Prepare and maintain functional and technical documents, data mappings, validation documents, test plans, and test cases.
Ensure documentation complies with governance and audit requirements.
Data Quality & Anomaly Detection
Identify anomalies, duplicates, missing records, and data inconsistencies.
Investigate root causes and recommend remediation actions.
Execute data quality controls and support data cleansing activities.
ETL & Migration Pipeline Validation
Validate ETL processes, migration pipelines, and transformation logic.
Review data processing workflows and business rule implementation.
Troubleshoot migration issues, exceptions, and data discrepancies.
Testing & Reconciliation
Execute UAT, mock migrations, and production migration validation.
Perform source-to-target reconciliation and data verification.
Validate data accuracy, completeness, and record counts.
Stakeholder Management
Partner with Business, Compliance, Operations, Data Governance, and Technology teams.
Facilitate requirements workshops and data discussions.
Communicate findings, risks, and recommendations to stakeholders.
Support project governance, reporting, and issue resolution.
Requirements:
Bachelor's Degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related discipline.
Minimum 10 years of experience in Data Analysis, Data Migration, Data Management, or related data-focused roles.
Strong hands-on experience with Microsoft SQL Server and advanced SQL development.
Proficient in complex SQL queries, including joins, stored procedures, functions, views, CTEs, performance tuning, and data validation.
Strong understanding of relational databases, data modelling, data warehousing concepts, and data migration methodologies.
Experience working with ETL processes, data integration, and migration pipelines.
Proven expertise in data profiling, data mapping, data reconciliation, data quality assessment, and root cause analysis.
Experience analyzing large and complex datasets to support data migration and transformation initiatives.
Experience with data migration tools, frameworks, and best practices.
Knowledge of data governance, data quality frameworks, and data management principles.
Familiarity with Power BI or other reporting and analytics tools.
Experience working in multinational banking or financial services environments is preferred.
Proven experience delivering banking data transformation or migration projects is highly desirable.
Strong analytical, problem-solving, and critical thinking skills.
Excellent communication and stakeholder management capabilities, with the ability to collaborate effectively across business and technology teams.
Demonstrated ability to identify data anomalies, perform root cause analysis, and drive issue resolution.
Meticulous attention to detail with a strong commitment to data quality, accuracy, and governance.
Self-motivated with the ability to work independently in a fast-paced, project-driven environment.
Why Join Us At ABeam Consulting, we place a strong emphasis on collaboration, and helping our employees grow and develop their skills, offering a supportive and empowering work environment. With a presence in multiple countries and a diverse range of clients, ABeam Consulting offers an exciting and dynamic workplace for individuals looking to build a career in consulting. ABeam Consulting has also recently joined SAP’s regional strategic partner initiative as their first regional partner in the region and has also been recognized by UiPath as a Diamond Partner in providing RPA solutions. With such accolades, we aim to continue driving enterprise and digital transformation initiatives in order to transform the way people work and communicate in the digital age. In addition, our industry team is working tirelessly in order to bring more solutions to the banking and finance sector.
We regret only shortlisted candidates will be notified.
Demand for Analyst roles
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.