Cloud Quest #46: Hunt for Remote Work

[AYXAcademy]

 

Hi Community,

We posted the solution JSON file to Cloud Quest #45. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

Let’s dive into this week's quest!

1. Download the provided JSON file containing your starting data and workflow files.
2. Upload Start Cloud Quest 46.json file to your Alteryx One library.
3. All necessary datasets are contained within Text Input tools in the workflow.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.

 

Scenario:

For this week's quest, you are acting as a senior-level professional researching the data analysis job market. Identify the 5 best job opportunities for a senior-level (SE) professional seeking a full-time, 100% remote position.

You are provided with two datasets:

• Job Market Data: Contains information about data analysis job salaries and characteristics.

• Country Codes Data: Contains country codes and their corresponding full country names.

Requirements
The ranking of "best opportunities" should be based on the average salary in USD for each job title.

• Only consider jobs with salary in USD.
• Only consider job titles that appear more than once in the dataset.
• The final output should list the Top 5 Job Titles and the Country where these opportunities are primarily located.

Job experience levels:

• EN: Entry-level/Junior 
• MI: Mid-level/Intermediate 
• SE: Senior-level/Expert 
• EX: Executive-level/Director

Job location:
• If Remote_ratio = 0, the job is onsite.
• If Remote_ratio = 50, the job is hybrid.
• If Remote_ratio = 100, the job is remote.

Hint: Read the filtering requirements carefully.

Image: Generated by Google Gemini, Oct 23, 2025, OpenAI, https://gemini.google.com.

 

Earn Cloud Quest badges:

After completing your quest, head back to your Analytics Cloud library:

• Download your workflow solution file.
• In your reply, attach both your JSON solution file and a screenshot of your workflow.
• Keep submitting—every solution gets you closer to earning more Cloud Quest badges!

 

Here’s to a successful quest!

- The Academy Team

Download Start File

[RolandSchubert]

Spoiler

[Qiu]

I am quite lost between Sort and Sample tools. 

Spoiler

[marcus_keyrus]

Spoiler

[alexnajm]

Done!

Spoiler

[patrick_digan]

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

[RWvanLeeuwen]

Spoiler

[ScottMcV]

Spoiler

Where / when to join was really the tricky part.  We do these as a "team" (or pair) sometimes and we had some real debates about what the intent was as to where to filter the data before the joins.  Mine could have been more efficient.  I like the country joins earlier on I see in some others.

[bradshaw]

This one had me scratching my head for a while, but a fresh set of eyes after leaving it a few days unlocked it in no time.

Spoiler