Data Analyst

Alphadog Recruit
Sheffield
3 months ago
Applications closed

Related Jobs

View all jobs

Data Analyst

Data Analyst

Data Analyst

Data Analyst

Data Analyst

Data Analyst

Please note that these qualifications or experience within Data Migrations of D365 are essential for this role, as stipulated by our client.


Applications that do not meet these criteria will not receive a response.


Data Migration Technical Analyst D365


Our client is a small yet growing data migration consultancy that is currently a D365 Data Migration Technical Analysts due to an influx of new contracts.

Prior experience working within in data migration team and in particular experience of migrating D365 is essential.

The company is committed to providing training to enhance your core skills, enabling your growth into the role of a Data Migration Technical Analyst.

As a Data Migration Technical Analyst, you will be expected to possess the technical capability to extract, transform, and load data using predefined methodologies and tools. You will have the opportunity to work alongside our highly experienced consultants, gaining valuable insights into data migration practices and various ERP systems. In addition to your technical expertise, strong analytical skills are essential, as you will need to engage with clients to identify data cleansing tasks and establish field mapping rules. Familiarity with general business processes and system data structures will significantly benefit the core data migration team.

Main Responsibilities

  • Attain comprehensive understanding of the project's data scope, focusing specifically on the detailed scope of your assigned data process area.
  • Develop extraction processes from legacy systems to enable access to raw legacy data.
  • Consult with clients regarding known data issues.
  • Perform data analysis to pinpoint gaps and potential issues, quantifying these alongside known data concerns.
  • Create Data Quality reporting tools aligned with company standards to help users identify and rectify legacy data problems.
  • Collaborate with external System Implementation Consultants to understand how data is imported into the new system, including dependencies or constraints and linkage to system configuration.
  • Conduct mapping sessions with clients to determine how legacy data needs transformation for integration into the new system.
  • Document data issues, gaps, mappings, required business rules, and risks according to company standards, validating this documentation with stakeholders and key users.
  • Develop T-SQL transformation code that meets company standards.
  • Export target data in the required format for loading into the new system.
  • Import transformed data into the new system, resolving any loading errors.
  • Approve the export of newly imported data, ensuring it meets expectations.
  • Investigate and resolve any reconciliation issues or testing bugs related to the data.
  • Provide data extracts as necessary to assist users with reconciliation and testing tasks.

Skills and Experience

Essential Skills, Technologies & Experience:

  • Proficiency in Microsoft SQL Server (2017 and later)
  • Experience of D365 migrations
  • Strong knowledge of SSMS
  • Experience with relational database DDL and DML
  • Advanced T-SQL programming skills
  • Familiarity with T-SQL performance tuning
  • Excellent client-facing communication skills
  • Strong analytical mindset with meticulous attention to detail
  • Commitment to coding and documentation standards
  • Ability to work independently while meeting strict deadlines

Desirable Skills & Technologies (not essential):

  • Exposure to ERP-level or similar data migration projects
  • Familiarity with SSIS (SQL Server Integration Services)
  • Proficient in MS Visual Studio
  • Competence in MS Office, particularly Excel, Word, and SharePoint
  • Understanding of common business system areas (e.g., Finance, Supply Chain, CRM, HRMS, Marketing Systems)
  • Experience in technical team leadership
  • Report building skills, e.g., PowerBI

General Competency

The ideal candidate will be versatile, equally adept at technical work and client-facing analysis. They should rapidly comprehend problems and propose practical alternatives, assessing benefits to recommend solutions effectively. A sense of ownership over their work and a proactive attitude in tackling challenges are crucial. Experience collaborating with business stakeholders to set priorities and resolve issues, along with a comprehensive understanding of IT's role in client business processes, is essential. The candidate should excel in a dynamic environment, take pride in their work, and strive for excellence.

Although the role is remote there will be a need to travel to Reading 3 to 4 times a year for team meetings, normally followed by a social event the next day.

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Jobs

Portfolio Projects That Get You Hired for Data Science Jobs (With Real GitHub Examples)

Data science is at the forefront of innovation, enabling organisations to turn vast amounts of data into actionable insights. Whether it’s building predictive models, performing exploratory analyses, or designing end-to-end machine learning solutions, data scientists are in high demand across every sector. But how can you stand out in a crowded job market? Alongside a solid CV, a well-curated data science portfolio often makes the difference between getting an interview and getting overlooked. In this comprehensive guide, we’ll explore: Why a data science portfolio is essential for job seekers. Selecting projects that align with your target data science roles. Real GitHub examples showcasing best practices. Actionable project ideas you can build right now. Best ways to present your projects and ensure recruiters can find them easily. By the end, you’ll be equipped to craft a compelling portfolio that proves your skills in a tangible way. And when you’re ready for your next career move, remember to upload your CV on DataScience-Jobs.co.uk so that your newly showcased work can be discovered by employers looking for exactly what you have to offer.

Jobs Careers

Data Science Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

Data science has become one of the most sought‑after fields in technology, leveraging mathematics, statistics, machine learning, and programming to derive valuable insights from data. Organisations across every sector—finance, healthcare, retail, government—rely on data scientists to build predictive models, understand patterns, and shape strategy with data‑driven decisions. If you’re gearing up for a data science interview, expect a well‑rounded evaluation. Beyond statistics and algorithms, many roles also require data wrangling, visualisation, software engineering, and communication skills. Interviewers want to see if you can slice and dice messy datasets, design experiments, and scale ML models to production. In this guide, we’ll explore 30 real coding & system‑design questions commonly posed in data science interviews. You’ll find challenges ranging from algorithmic coding and statistical puzzle‑solving to the architectural side of building data science platforms in real‑world settings. By practising with these questions, you’ll gain the confidence and clarity needed to stand out among competitive candidates. And if you’re actively seeking data science opportunities in the UK, be sure to visit www.datascience-jobs.co.uk. It’s a comprehensive hub featuring junior, mid‑level, and senior data science vacancies—spanning start‑ups to FTSE 100 companies. Let’s dive into what you need to know.

Jobs

Negotiating Your Data Science Job Offer: Equity, Bonuses & Perks Explained

Data science has rapidly evolved from a niche specialty to a cornerstone of strategic decision-making in virtually every industry—from finance and healthcare to retail, entertainment, and AI research. As a mid‑senior data scientist, you’re not just running predictive models or generating dashboards; you’re shaping business strategy, product innovation, and customer experiences. This level of influence is why employers are increasingly offering compensation packages that go beyond a baseline salary. Yet, many professionals still tend to focus almost exclusively on base pay when negotiating a new role. This can be a costly oversight. Companies vying for data science talent—especially in the UK, where demand often outstrips supply—routinely offer equity, bonuses, flexible work options, and professional development funds in addition to salary. Recognising these opportunities and effectively negotiating them can have a substantial impact on your total earnings and long-term career satisfaction. This guide explores every facet of negotiating a data science job offer—from understanding equity structures and bonus schemes to weighing crucial perks like remote work and ongoing skill development. By the end, you’ll be well-equipped to secure a holistic package aligned with your market value, your life goals, and the tremendous impact you bring to any organisation.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.