# Extract Insights from Job Posts

## **Use case**

1. Search old or current job positions (data analysts or data engineers where “marketing” is mentioned in the job description
2. Extract relevant technologies (BI, integration and data warehouse)
3. List technologies if found

<details>

<summary><strong>Prompt</strong></summary>

Conduct a **Google search** to find open or past job positions for **Data Analysts** or **Data Engineers** where “marketing” is mentioned in the job description for <mark style="color:red;background-color:orange;">**Company**</mark>. Extract relevant BI, integration, and data warehouse technologies from the descriptions. Follow these steps:

**Step 1: Google Search for Relevant Job Positions**

1. **Perform a Google search** (do not use the company’s careers page or third-party platforms). Use the following query:

**“**<mark style="color:red;background-color:orange;">**Company**</mark>**&#x20;Data Analyst OR Data Engineer marketing job post”**

2. Extract **up to five** relevant job listings from **Google search results** (top results only).
3. If no relevant job listings are found, return: **“No relevant job descriptions found.”**

**Step 2: Scrape Job Descriptions for BI, Integration & Data Warehouse Technologies**

Analyze the job descriptions and extract mentions of relevant data tools in three categories:

**1️⃣ Business Intelligence (BI) Tools**

* Tableau
* Looker
* Power BI

**2️⃣ Data Integration Tools**

* Fivetran
* Funnel
* Adverity

**3️⃣ Data Warehouses**

* Snowflake
* BigQuery
* AWS (Redshift, S3, or general cloud data storage)

**Step 3: Output Only the Technologies Found**

1. **If relevant technologies are found in the job descriptions**, return them as a **comma-separated list**.

* **Example Output:** *Tableau, Looker, Snowflake, Fivetran*

2. **If no relevant technologies are found, return: “No relevant data technologies found in job descriptions.”**

**Example Outputs**

✅ **Technologies Found:**

* *Tableau, Looker, Snowflake, Fivetran*

✅ **No Relevant Technologies Found:**

* *No relevant data technologies found in job descriptions.*

</details>

<figure><img src="https://2426440268-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMzaYbOuCLt8zV0pNIILp%2Fuploads%2F8408MdkJ4Sir5eZcowSL%2F11122.png?alt=media&#x26;token=d7cdf82e-e27a-431b-892f-f696b1d00fdc" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2426440268-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMzaYbOuCLt8zV0pNIILp%2Fuploads%2F8RRSYNQlTX6rgUfC1IKB%2F1233.png?alt=media&#x26;token=c1c4b096-18d0-449c-8936-ab987103c4eb" alt=""><figcaption></figcaption></figure>