Data Operations Analyst (AI-Assisted Data Transformation & Structuring)

Summary

Looking for a detail-oriented Data Operations Analyst to independently handle data extraction, transformation, and validation across structured (CSV) and unstructured (PDF) datasets. The role involves converting complex raw datasets into highly structured JSON formats using defined schemas, with zero data loss and strict quality standards. AI tools can be used to improve speed and efficiency, but 100% accuracy and manual validation is mandatory.

Key Responsibilities

1. Data Extraction

Extract and organize data from:

• CSV datasets (NASA materials data)

• PDF documents (BGS mining directory)

Use tools where needed, while ensuring data accuracy

2. Data Transformation

• Convert raw data into structured JSON formats

• Map all fields according to strict schema rules

• Handle:

  • Complex property grouping (NASA dataset)

  • Supplier + site grouping (BGS dataset)

3. Data Structuring

Build:

• Material-level JSON records

• Supplier-level JSON objects

Ensure:

• Correct categorization

• Proper grouping of related data

• Consistent naming conventions

4. Quality Assurance (Critical)

Validate every record before submission

Ensure:

• No missing data

• No incorrect mappings

• No duplicates

Follow strict SOP and validation checklist

5. AI-Assisted Workflow

Use AI tools to:

• Speed up the transformation

• Assist in structuring data

  Independently verify all AI-generated outputs

Final accountability for accuracy remains with the analyst

Candidate must be comfortable using AI tools responsibly for productivity, not blindly:

• ChatGPT – for structuring, reasoning, and transformation assistance

• Claude – for long document parsing and summarization

• Microsoft Excel (with AI features like Copilot) – for data handling

• Adobe Acrobat or similar – for PDF extraction

  Optional:

• Python (basic scripting)

• Google Sheets

Key expectation: Ability to use AI as an assistant, not a replacement for thinking

Qualifications

Bachelor’s degree in:

• Computer Science / Engineering

• Mathematics / Statistics

• Or any relevant field with strong data handling experience

Operations / Material Science background is a plus.