Applicant ID Full Name Job Position Application Date & T
AID0123548 Pam Beesly Data Analyst 2/14/23 3:22 PM
AID0123549 Michael Scott Business Intelligence Analyst 5/9/23 9:45 AM
AID0123550 Kevin Malone Data Engineer 7/21/23 5:30 PM
AID0123551 Pam Beesly Business Intelligence Analyst 9/4/23 7:15 AM
AID0123552 Jim Halpert Data Scientist 11/18/23 5:00 PM
AID0123553 Ryan Howard Machine Learning Engineer 1/11/24 12:45 PM
AID0123554 Kevin Malone Business Intelligence Analyst 3/3/24 4:30 PM
AID0123555 Ryan Howard Data Analyst 4/26/24 8:10 AM
AID0123556 Stanley Hudson Data Scientist 6/15/24 5:50 PM
AID0123557 Angela Martin Data Engineer 7/7/24 2:35 PM
AID0123558 Dwight Schrute Data Scientist 6/12/24 6:50 AM
AID0123559 Oscar Martinez Machine Learning Engineer 1/25/23 1:15 PM
AID0123560 Ryan Howard Data Engineer 3/17/23 11:45 AM
AID0123561 Phyllis Vance Machine Learning Engineer 6/1/23 10:00 AM
AID0123562 Meredith Palmer Machine Learning Engineer 8/30/23 5:30 PM
AID0123563 Michael Scott Data Scientist 10/19/23 7:40 AM
AID0123564 Jim Halpert Data Engineer 2/28/24 5:15 PM
AID0123565 Kelly Kapoor Data Scientist 5/6/24 5:25 PM
AID0123566 Jim Halpert Machine Learning Engineer 7/23/24 7:00 AM
AID0123567 Jim Halpert Machine Learning Engineer 5/10/24 5:45 PM
Email Street City State Zip
[Link]@[Link] 457 Oak St San Jose, CA, 95101
[Link]@[Link] 203 Birch St Chicago, IL, 60601
[Link]@[Link] 790 Pine St Chicago, IL, 60601
[Link]@[Link] 457 Oak St San Jose, CA, 95101
[Link]@[Link] 459 Oak St Philadelphia, PA, 19101
[Link]@[Link] 204 Birch St Philadelphia, PA, 19101
[Link]@[Link] 790 Pine St Chicago, IL, 60601
[Link]@[Link] 204 Birch St Philadelphia, PA, 19101
[Link]@[Link] 123 Elm St Chicago, IL, 60601
[Link]@[Link] 123 Elm St Los Angeles, CA, 90001
[Link]@[Link] 123 Elm St San Diego, CA, 92101
[Link]@[Link] 202 Birch St Chicago, IL, 60601
[Link]@[Link] 204 Birch St Philadelphia, PA, 19101
[Link]@[Link] 123 Elm St Chicago, IL, 60601
[Link]@[Link] 456 Oak St Chicago, IL, 60601
[Link]@[Link] 203 Birch St Chicago, IL, 60602
[Link]@[Link] 459 Oak St Philadelphia, PA, 19101
[Link]@[Link] 456 Oak St New York, NY, 10001
[Link]@[Link] 459 Oak St Philadelphia, PA, 19101
[Link]@[Link] 459 Oak St New York, NY, 10001
Skills List Full Address
Kafka, DataBricks, Spark, Python, GCP
Power BI, GCP, Airflow, Hadoop, R
Azure, Java, SQL, DataBricks
Kafka, DataBricks, Spark, Python, GCP
DataBricks, Hadoop, Java
Snowflake, Airflow, DataBricks
Azure, Java, SQL, DataBricks
Snowflake, Airflow, DataBricks
Scala, Azure, R, Kafka
Snowflake, Excel, Scala
Excel, Power BI, R
Scala, R, Hadoop, Power BI, SQL
Snowflake, Airflow, DataBricks
Java, Scala, R
DataBricks, Azure, Scala
Power BI, GCP, Airflow, Hadoop, R
DataBricks, Hadoop, Java
Snowflake, Power BI, Tableau, Airflow, SQL
DataBricks, Hadoop, Java
DataBricks, Hadoop, Java
First Name Last Name Applicant ID (Short) Find and MID (State)
and MID (State)
Applicant ID Full Name Job Position Application Date & Email
AID0123548 Pam Beesly Data Analyst 2/14/23 3:22 PM [Link]@o
AID0123549 Michael Scott Business Intelligence Analyst 5/9/23 9:45 AM [Link]
AID0123550 Kevin Malone Data Engineer 7/21/23 5:30 PM [Link]
AID0123551 Pam Beesly Business Intelligence Analyst 9/4/23 7:15 AM [Link]@o
AID0123552 Jim Halpert Data Scientist 11/18/23 5:00 PM [Link]@
AID0123553 Ryan Howard Machine Learning Engineer 1/11/24 12:45 PM [Link]
AID0123554 Kevin Malone Business Intelligence Analyst 3/3/24 4:30 PM [Link]
AID0123555 Ryan Howard Data Analyst 4/26/24 8:10 AM [Link]
AID0123556 Stanley Hudson Data Scientist 6/15/24 5:50 PM [Link]
AID0123557 Angela Martin Data Engineer 7/7/24 2:35 PM [Link]
AID0123558 Dwight Schrute Data Scientist 6/12/24 6:50 AM [Link]
AID0123559 Oscar Martinez Machine Learning Engineer 1/25/23 1:15 PM [Link]
AID0123560 Ryan Howard Data Engineer 3/17/23 11:45 AM [Link]
AID0123561 Phyllis Vance Machine Learning Engineer 6/1/23 10:00 AM [Link]
AID0123562 Meredith Palmer Machine Learning Engineer 8/30/23 5:30 PM [Link]
AID0123563 Michael Scott Data Scientist 10/19/23 7:40 AM [Link]
AID0123564 Jim Halpert Data Engineer 2/28/24 5:15 PM [Link]@
AID0123565 Kelly Kapoor Data Scientist 5/6/24 5:25 PM [Link]
AID0123566 Jim Halpert Machine Learning Engineer 7/23/24 7:00 AM [Link]@
AID0123567 Jim Halpert Machine Learning Engineer 5/10/24 5:45 PM [Link]@
Street City State Zip
457 Oak St San Jose, CA, 95101
203 Birch St Chicago, IL, 60601
790 Pine St Chicago, IL, 60601
457 Oak St San Jose, CA, 95101
459 Oak St Philadelphia, PA, 19101
204 Birch St Philadelphia, PA, 19101
790 Pine St Chicago, IL, 60601
204 Birch St Philadelphia, PA, 19101
123 Elm St Chicago, IL, 60601
123 Elm St Los Angeles, CA, 90001
123 Elm St San Diego, CA, 92101
202 Birch St Chicago, IL, 60601
204 Birch St Philadelphia, PA, 19101
123 Elm St Chicago, IL, 60601
456 Oak St Chicago, IL, 60601
203 Birch St Chicago, IL, 60602
459 Oak St Philadelphia, PA, 19101
456 Oak St New York, NY, 10001
459 Oak St Philadelphia, PA, 19101
459 Oak St New York, NY, 10001
Skills List Full Address
Kafka, DataBricks, Spark, Python, GCP 457 Oak St San Jose, CA, 95101
Power BI, GCP, Airflow, Hadoop, R 203 Birch St Chicago, IL, 60601
Azure, Java, SQL, DataBricks 790 Pine St Chicago, IL, 60601
Kafka, DataBricks, Spark, Python, GCP 457 Oak St San Jose, CA, 95101
DataBricks, Hadoop, Java 459 Oak St Philadelphia, PA, 19101
Snowflake, Airflow, DataBricks 204 Birch St Philadelphia, PA, 19101
Azure, Java, SQL, DataBricks 790 Pine St Chicago, IL, 60601
Snowflake, Airflow, DataBricks 204 Birch St Philadelphia, PA, 19101
Scala, Azure, R, Kafka 123 Elm St Chicago, IL, 60601
Snowflake, Excel, Scala 123 Elm St Los Angeles, CA, 90001
Excel, Power BI, R 123 Elm St San Diego, CA, 92101
Scala, R, Hadoop, Power BI, SQL 202 Birch St Chicago, IL, 60601
Snowflake, Airflow, DataBricks 204 Birch St Philadelphia, PA, 19101
Java, Scala, R 123 Elm St Chicago, IL, 60601
DataBricks, Azure, Scala 456 Oak St Chicago, IL, 60601
Power BI, GCP, Airflow, Hadoop, R 203 Birch St Chicago, IL, 60602
DataBricks, Hadoop, Java 459 Oak St Philadelphia, PA, 19101
Snowflake, Power BI, Tableau, Airflow, SQL 456 Oak St New York, NY, 10001
DataBricks, Hadoop, Java 459 Oak St Philadelphia, PA, 19101
DataBricks, Hadoop, Java 459 Oak St New York, NY, 10001
Applicant ID Full Name Job Position Application Date &
AID0123548 Pam Beesly Data Analyst 2/14/23 3:22 PM
AID0123549 Michael Scott Business Intelligence Analyst 5/9/23 9:45 AM
AID0123550 Kevin Malone Data Engineer 7/21/23 5:30 PM
AID0123551 Pam Beesly Business Intelligence Analyst 9/4/23 7:15 AM
AID0123552 Jim Halpert Data Scientist 11/18/23 5:00 PM
AID0123553 Ryan Howard Machine Learning Engineer 1/11/24 12:45 PM
AID0123554 Kevin Malone Business Intelligence Analyst 3/3/24 4:30 PM
AID0123555 Ryan Howard Data Analyst 4/26/24 8:10 AM
AID0123556 Stanley Hudson Data Scientist 6/15/24 5:50 PM
AID0123557 Angela Martin Data Engineer 7/7/24 2:35 PM
AID0123558 Dwight Schrute Data Scientist 6/12/24 6:50 AM
AID0123559 Oscar Martinez Machine Learning Engineer 1/25/23 1:15 PM
AID0123560 Ryan Howard Data Engineer 3/17/23 11:45 AM
AID0123561 Phyllis Vance Machine Learning Engineer 6/1/23 10:00 AM
AID0123562 Meredith Palmer Machine Learning Engineer 8/30/23 5:30 PM
AID0123563 Michael Scott Data Scientist 10/19/23 7:40 AM
AID0123564 Jim Halpert Data Engineer 2/28/24 5:15 PM
AID0123565 Kelly Kapoor Data Scientist 5/6/24 5:25 PM
AID0123566 Jim Halpert Machine Learning Engineer 7/23/24 7:00 AM
AID0123567 Jim Halpert Machine Learning Engineer 5/10/24 5:45 PM
Email Street City State Zip
[Link]@o457 Oak St San Jose, CA, 95101
[Link] 203 Birch St Chicago, IL, 60601
[Link]@790 Pine St Chicago, IL, 60601
[Link]@o457 Oak St San Jose, CA, 95101
[Link]@h 459 Oak St Philadelphia, PA, 19101
[Link]@204 Birch St Philadelphia, PA, 19101
[Link]@790 Pine St Chicago, IL, 60601
[Link]@204 Birch St Philadelphia, PA, 19101
[Link] 123 Elm St Chicago, IL, 60601
[Link] 123 Elm St Los Angeles, CA, 90001
[Link] 123 Elm St San Diego, CA, 92101
[Link] 202 Birch St Chicago, IL, 60601
[Link]@204 Birch St Philadelphia, PA, 19101
[Link] 123 Elm St Chicago, IL, 60601
meredith.palm456 Oak St Chicago, IL, 60601
[Link] 203 Birch St Chicago, IL, 60602
[Link]@h 459 Oak St Philadelphia, PA, 19101
[Link]@ 456 Oak St New York, NY, 10001
[Link]@h 459 Oak St Philadelphia, PA, 19101
[Link]@h 459 Oak St New York, NY, 10001
Skills List First Name Last Name
Kafka, DataBricks, Spark, Python, GCP #NAME? #NAME?
Power BI, GCP, Airflow, Hadoop, R #NAME? #NAME?
Azure, Java, SQL, DataBricks #NAME? #NAME?
Kafka, DataBricks, Spark, Python, GCP #NAME? #NAME?
DataBricks, Hadoop, Java #NAME? #NAME?
Snowflake, Airflow, DataBricks #NAME? #NAME?
Azure, Java, SQL, DataBricks #NAME? #NAME?
Snowflake, Airflow, DataBricks #NAME? #NAME?
Scala, Azure, R, Kafka #NAME? #NAME?
Snowflake, Excel, Scala #NAME? #NAME?
Excel, Power BI, R #NAME? #NAME?
Scala, R, Hadoop, Power BI, SQL #NAME? #NAME?
Snowflake, Airflow, DataBricks #NAME? #NAME?
Java, Scala, R #NAME? #NAME?
DataBricks, Azure, Scala #NAME? #NAME?
Power BI, GCP, Airflow, Hadoop, R #NAME? #NAME?
DataBricks, Hadoop, Java #NAME? #NAME?
Snowflake, Power BI, Tableau, Airflow, SQL #NAME? #NAME?
DataBricks, Hadoop, Java #NAME? #NAME?
DataBricks, Hadoop, Java #NAME? #NAME?
Unique Jobs Check Applicant ID Applicant ID (Short)
#NAME? 1 0123548
#NAME? TRUE 0123549
#NAME? TRUE 0123550
#NAME? TRUE 0123551
#NAME? TRUE 0123552
TRUE 0123553
TRUE 0123554
TRUE 0123555
TRUE 0123556
TRUE 0123557
TRUE 0123558
TRUE 0123559
TRUE 0123560
TRUE 0123561
TRUE 0123562
TRUE 0123563
TRUE 0123564
TRUE 0123565
TRUE 0123566
TRUE 0123567
Applicant ID Full Name Job Position Application Date &
AID0123548 Pam Beesly Data Analyst 2/14/23 3:22 PM
AID0123549 Michael Scott Business Intellige 5/9/23 9:45 AM
AID0123550 Kevin Malone Data Engineer 7/21/23 5:30 PM
AID0123551 Pam Beesly Business Intellige 9/4/23 7:15 AM
AID0123552 Jim Halpert Data Scientist 11/18/23 5:00 PM
AID0123553 Ryan Howard Machine Learning 1/11/24 12:45 PM
AID0123554 Kevin Malone Business Intellige 3/3/24 4:30 PM
AID0123555 Ryan Howard Data Analyst 4/26/24 8:10 AM
AID0123556 Stanley Hudson Data Scientist 6/15/24 5:50 PM
AID0123557 Angela Martin Data Engineer 7/7/24 2:35 PM
AID0123558 Dwight Schrute Data Scientist 6/12/24 6:50 AM
AID0123559 Oscar Martinez Machine Learning 1/25/23 1:15 PM
AID0123560 Ryan Howard Data Engineer 3/17/23 11:45 AM
AID0123561 Phyllis Vance Machine Learning 6/1/23 10:00 AM
AID0123562 Meredith Palmer Machine Learning 8/30/23 5:30 PM
AID0123563 Michael Scott Data Scientist 10/19/23 7:40 AM
AID0123564 Jim Halpert Data Engineer 2/28/24 5:15 PM
AID0123565 Kelly Kapoor Data Scientist 5/6/24 5:25 PM
AID0123566 Jim Halpert Machine Learning 7/23/24 7:00 AM
AID0123567 Jim Halpert Machine Learning 5/10/24 5:45 PM
Email Street City State Zip
[Link]@[Link] 457 Oak St San Jose, CA, 95101
[Link]@[Link] 203 Birch St Chicago, IL, 60601
[Link]@[Link] 790 Pine St Chicago, IL, 60601
[Link]@[Link] 457 Oak St San Jose, CA, 95101
[Link]@[Link] 459 Oak St Philadelphia, PA, 19101
[Link]@[Link] 204 Birch St Philadelphia, PA, 19101
[Link]@[Link] 790 Pine St Chicago, IL, 60601
[Link]@[Link] 204 Birch St Philadelphia, PA, 19101
[Link]@[Link] 123 Elm St Chicago, IL, 60601
[Link]@[Link] 123 Elm St Los Angeles, CA, 90001
[Link]@[Link] 123 Elm St San Diego, CA, 92101
[Link]@[Link] 202 Birch St Chicago, IL, 60601
[Link]@[Link] 204 Birch St Philadelphia, PA, 19101
[Link]@[Link] 123 Elm St Chicago, IL, 60601
[Link]@[Link] 456 Oak St Chicago, IL, 60601
[Link]@[Link] 203 Birch St Chicago, IL, 60602
[Link]@[Link] 459 Oak St Philadelphia, PA, 19101
[Link]@[Link] 456 Oak St New York, NY, 10001
[Link]@[Link] 459 Oak St Philadelphia, PA, 19101
[Link]@[Link] 459 Oak St New York, NY, 10001
Find and MID (State)
11 13 CA
10 12 IL
10 12 IL
11 13 CA
15 17 PA
15 17 PA
10 12 IL
15 17 PA
10 12 IL
14 16 CA
12 14 CA
10 12 IL
15 17 PA
10 12 IL
10 12 IL
10 12 IL
15 17 PA
11 13 NY
15 17 PA
11 13 NY
=TEXTJOIN(", ", TRUE, Data!H2:H21)
Kafka, DataBricks, Spark, Python, GCP, Power BI, GCP, Airflow, Hadoop, R, Azure, Java, SQL, DataBricks, Kafka, DataBricks, Spar
=TEXTSPLIT(A3, ", ")
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
=UNIQUE(TRANSPOSE(6:6)) =COUNTIF($6:$6,A9)
#NAME? 3
#NAME? #NAME? Skill Count of Applicants
#NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME?
#NAME? #NAME?
#NAME?
#NAME? #NAME?
#NAME?
#NAME? #NAME?
#NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME?
#NAME? #NAME?
#NAME?
#NAME? #NAME?
#NAME?
0 0.5 1 1.5 2 2.5 3 3.5
taBricks, Kafka, DataBricks, Spark, Python, GCP, DataBricks, Hadoop, Java, Snowflake, Airflow, DataBricks, Azure, Java, SQL, DataBricks, Sno
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
pplicants
2 2.5 3 3.5
zure, Java, SQL, DataBricks, Snowflake, Airflow, DataBricks, Scala, Azure, R, Kafka, Snowflake, Excel, Scala, Excel, Power BI, R, Scala, R, Hado
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
cel, Power BI, R, Scala, R, Hadoop, Power BI, SQL, Snowflake, Airflow, DataBricks, Java, Scala, R, DataBricks, Azure, Scala, Power BI, GCP, Air
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Azure, Scala, Power BI, GCP, Airflow, Hadoop, R, DataBricks, Hadoop, Java, Snowflake, Power BI, Tableau, Airflow, SQL, DataBricks, Hadoop
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
flow, SQL, DataBricks, Hadoop, Java, DataBricks, Hadoop, Java
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
