We are seeking an experienced Data Analyst with expertise in generative AI to assist in extracting project information and success stories from Gmail exports in JSON and MAIL formats.
The goal is to compile a spreadsheet report based on data analysis, interpretation of emails to and from clients, listing and description of projects referenced in the emails based on interpretation of the content by A.I. (e.g. ChatGPT4) to infer and list projects and descriptions of them, and the use of generative AI to document project success stories in brief for use in external communications to describe success stories.
Responsibilities:
1. Data Preparation:
- Import and organize the 2203 exported conversations from the JSON and MAIL files exported from Gmail into a structured dataset for analysis.
- Extract email content, sender/receiver information, and timestamps.
2. Data Preprocessing:
- If necessary, clean the dataset by removing duplicate emails, irrelevant information, and any sensitive data to ensure compliance with privacy regulations.
3. Data Analysis:
- Use NLP techniques and Python libraries to analyze the emails.
- Identify customer-related emails by matching email addresses with the provided client list (client list includes emails that use client domain for identification of relevant emails).
- Extract project-related information such as project names, descriptions, milestones, and steps.
- Identify positive language and references to successful outcomes.
- Extract quotes from customer emails that showcase successful outcomes.
4. Generative AI Storytelling:
- Use generative AI models, such as GPT-3, to create project stories.
- Provide the model with structured data extracted in the previous steps, including project details and positive language.
- Guide the AI to generate narratives that describe each project, steps taken, and successful outcomes.
- Refine the generated stories for clarity and coherence.
5. Documentation and Reporting:
- Compile the generated project stories into a comprehensive report.
- Include project descriptions, names, descriptions, milestones, and steps.
- Incorporate narratives of steps taken during each project.
- Integrate references to successful outcomes and positive language from emails.
- Include quotes from customer emails within the stories.
- Create a summary section providing an overview of all projects and their outcomes.
Requirements:
1. Proven experience as a Data Analyst with expertise in data extraction, analysis, and interpretation of client emails.
2. Familiarity with JSON and MAIL data formats from Gmail exports.
3. Proficiency in data analysis tools and programming languages like Python, Pandas, and NLP libraries.
4. Strong attention to detail and the ability to ensure data accuracy.
5. Expertise in generative AI tools for storytelling and experience working with AI models like GPT-4.
6. Excellent communication skills to present findings and generated stories effectively.
7. Ability to provide a detailed description of the process used to achieve the outcome, including methods and tools employed.
Bonus points: use of cloud based solutions like Alteryx or other recommended platforms in your application for this job will be considered first in awarding of this job.
How to Apply:
If you are an experienced Data Analyst with expertise in data analysis and generative AI storytelling, and you can provide a detailed description of your process, we would like to hear from you. Please submit your proposal, including:
1. A brief overview of your relevant experience.
2. Your approach to extracting project information and success stories from Gmail JSON and MAIL data.
3. Details of the generative AI tools and methods you plan to use for storytelling.
4. Your estimated hours for completing this project.
5. Any relevant portfolio or samples of similar work if available.
**Note:** This is a remote freelance opportunity. Please include your hourly rate or project-based fee in your proposal.