Data Analyst

Data Analyst London, UK Contract Role Purpose 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.