Data Analyst
Posted Today by TAGMATIX360
Negotiable
Undetermined
Undetermined
London Area, United Kingdom
Summary: The Data Analyst role in London involves in-depth analysis of legacy data systems to understand their functionality and data flow. The position requires technical forensics to uncover hidden logic in business reports and to assist in data asset categorization for modernization. The analyst will also conduct data quality assessments and create documentation for the engineering team. This contract role demands extensive experience and expertise in SQL and data profiling tools.
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.
Key Skills:
- Experience over 7 years.
- Expert-level SQL skills (Oracle, SQL Server, or similar).
- Familiarity with metadata from enterprise tools like Informatica PowerCenter or Business Objects.
- Proficiency in data profiling tools and Excel; experience with automated metadata scanning tools is a plus.
- Ability to represent complex data flows using tools like Visio or Lucidchart.
Salary (Rate): undetermined
City: London
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: Other
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.