Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a growing team to analyse and migrate data using D365 and SQL Server.
- Company: A dynamic data migration consultancy focused on innovation and growth.
- Benefits: Remote work, training opportunities, and a chance to collaborate with experienced consultants.
- Why this job: Make a real impact in data migration while enhancing your technical skills.
- Qualifications: Experience with D365 migrations and strong analytical skills are essential.
- Other info: Enjoy team meetings in Reading with social events to connect with colleagues.
The predicted salary is between 36000 - 60000 £ per year.
Our client is a small yet growing data migration consultancy that is currently seeking D365 Data Migration Technical Analysts due to an influx of new contracts. Prior experience working within a data migration team, particularly with 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.
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., Power BI
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.
D365 Data Analyst in London employer: Alphadog Recruit
Contact Detail:
Alphadog Recruit Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land D365 Data Analyst in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the data migration field, especially those who have experience with D365. A friendly chat can lead to insider info about job openings or even referrals that could give you a leg up.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your previous data migration projects, especially any work with D365. This will not only demonstrate your expertise but also give potential employers a taste of what you can bring to their team.
✨Tip Number 3
Prepare for interviews by brushing up on common data migration scenarios and challenges. Be ready to discuss how you've tackled similar issues in the past, as this will show your analytical mindset and problem-solving skills.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive and engaged with our company.
We think you need these skills to ace D365 Data Analyst in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the D365 Data Analyst role. Highlight your experience with data migration, especially with D365, and showcase your technical skills in SQL Server and T-SQL. We want to see how your background aligns with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data migration and how your analytical skills can benefit our team. Don’t forget to mention any relevant projects or experiences that demonstrate your expertise.
Showcase Your Technical Skills: In your application, be sure to highlight your proficiency in Microsoft SQL Server and T-SQL programming. If you have experience with SSIS or other relevant tools, let us know! We love seeing candidates who are technically savvy and ready to tackle challenges.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it gives you a chance to explore more about our company culture and values!
How to prepare for a job interview at Alphadog Recruit
✨Know Your D365 Inside Out
Make sure you brush up on your D365 migration knowledge before the interview. Familiarise yourself with the specific processes and tools used in data migration, as well as any recent updates or changes to the platform. This will show that you're not just a candidate, but someone who is genuinely interested in the role.
✨Show Off Your SQL Skills
Since proficiency in Microsoft SQL Server and T-SQL is crucial for this role, be prepared to discuss your experience with these technologies. You might even be asked to solve a problem on the spot, so practice writing T-SQL queries and think about how you can demonstrate your analytical mindset during the interview.
✨Engage with Real-World Scenarios
Think of examples from your past experiences where you've successfully handled data migration challenges. Be ready to discuss how you identified data issues, performed analysis, and collaborated with clients. This will help the interviewers see how you apply your skills in real-world situations.
✨Ask Insightful Questions
Prepare some thoughtful questions about the company's data migration projects and their approach to client engagement. This not only shows your interest in the role but also gives you a chance to assess if the company aligns with your career goals. Plus, it opens up a dialogue that can make you more memorable!
