At a Glance
- Tasks: Dive deep into legacy data systems and uncover hidden logic driving business reports.
- Company: Join a forward-thinking company in the heart of London.
- Benefits: Competitive pay, flexible working hours, and opportunities for skill development.
- Other info: Dynamic role with potential for career advancement in a tech-savvy environment.
- Why this job: Make a real impact by modernising data systems and enhancing business intelligence.
- Qualifications: 7+ years experience with expert SQL skills and familiarity with data profiling tools.
The predicted salary is between 60000 - 84000 £ per year.
The Data Analyst is responsible for interrogating legacy data systems to understand how they work. You will move beyond simple data profiling to perform technical forensics—identifying how data flows through complex legacy environments and uncovering the hidden logic that drives business reports.
Key Responsibilities
- Legacy Data Discovery: Perform deep-dive analysis into legacy databases and ETL metadata to map end-to-end data lineage.
- Logic Clustering: Identify repeatable patterns in legacy code to help simplify and group technical assets for modernization.
- Estate Rationalization: Assist in categorizing data assets into 'Keep, Merge, or Kill' buckets by analyzing usage logs and technical complexity.
- Data Profiling: Conduct thorough data quality assessments to identify anomalies or 'Hidden Logic' that could impact migration.
- Documentation: Create clear technical inventories and mapping documents that serve as the foundation for the engineering team.
Technology, Tools & Certifications
- Experience over 7 years
- Data Querying: Expert-level SQL skills (Oracle, SQL Server, or similar).
- Legacy Awareness: Familiarity with metadata from enterprise tools like Informatica PowerCenter or Business Objects.
- Analysis Tools: Proficiency in data profiling tools and Excel; experience with automated metadata scanning tools is a plus.
- Visualization: Ability to represent complex data flows using tools like Visio or Lucidchart.
Data Analyst in London employer: TAGMATIX360
As a Data Analyst at our London office, you will thrive in a dynamic work culture that values innovation and collaboration. We offer competitive benefits, including professional development opportunities to enhance your skills and advance your career. Join us to be part of a forward-thinking team dedicated to transforming legacy data systems into valuable business insights.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry on LinkedIn or at local meetups. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, especially those involving legacy systems. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data profiling techniques. Be ready to discuss how you've tackled complex data challenges in the past—real-life examples go a long way!
✨Tip Number 4
Don’t forget to apply through our website! We’ve got some fantastic opportunities waiting for talented Data Analysts like you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Data Analyst in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Analyst role. Highlight your experience with legacy data systems and any relevant tools you've used. We want to see how your skills match what we're looking for!
Showcase Your Skills:Don’t just list your skills—show us how you’ve applied them! Use specific examples from your past work that demonstrate your expertise in SQL, data profiling, and analysis tools. This will help us see the real impact you've made.
Be Clear and Concise:When writing your application, keep it clear and to the point. We appreciate straightforward communication, so avoid jargon unless it's necessary. Make it easy for us to understand your qualifications and experiences.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications better and ensures you get all the updates directly from us. Plus, it’s super easy!
How to prepare for a job interview at TAGMATIX360
✨Know Your Data Inside Out
Before the interview, make sure you brush up on your SQL skills and any relevant data profiling tools. Be prepared to discuss specific examples of how you've interrogated legacy data systems in the past, as this will show your depth of knowledge and experience.
✨Understand the Role's Technical Requirements
Familiarise yourself with the technologies mentioned in the job description, like Informatica PowerCenter or Business Objects. If you have experience with these tools, be ready to share how you've used them to perform data analysis and what insights you gained.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems related to data lineage or logic clustering. Think about how you would approach these scenarios and be ready to explain your thought process clearly and logically.
✨Showcase Your Documentation Skills
Since creating clear technical inventories is part of the role, bring examples of documentation you've created in previous positions. This could include mapping documents or data quality assessments, which will demonstrate your ability to communicate complex information effectively.
