The jobs and salaries of non-U.S. citizens working in the U.S.

It’s 11:35 p.m. and I’ve spent the past several hours trying to fumble my way through Tableau for the first time, so I’m not here to make some witty opening paragraph. The fumbling was so worth it, though, because Tableau seems like an incredible data visualization software tool and I can’t wait to get deeper into it.

As part of a course I’m taking on Coursera called Data Visualization and Communication with Tableau, I was provided with a database of government records for all visa sponsorship applications by U.S. companies for foreigners into the U.S. Any company wishing to hire a non-U.S. citizen must get the approval from the government for a green card or work visa (I did not know that).

Some patient soul working with Coursera meticulously went through every job title on the applications and placed them into  one of eight general job titles: assistant professor, attorney, business analyst, data analyst, data scientist, management consultant, software engineer, teacher.

bubblea

So it looks like attorneys are the highest paid foreign workers. Another interesting fact: companies have to state how much they are planning on paying the employee every time they submit a visa or green card application. They also have to state the average amount an employee with similar skills and background typically gets paid for the same position, a figure called “the prevailing wage.” So chances are that foreign workers are making close to what U.S. workers are (maybe I should have gone to law school after all…). Each of these job title above has around 1,000 persons working in that position, which doesn’t seem like a whole bunch. Let’s add the 4th highest paying position:

bubbleb

WHA-BAM, as Aziz Ansari would say. The amount of foreign Software Engineers dwarfs the top 3 highest paid positions. It reminds me of looking at a visualization of our solar system and you’re thinking to yourself, “Oh cool….Mercury…Venus…oh there’s Earth…Mars is really red…WHAT IS THAT THING”. It’s Jupiter. Software Engineer is the Jupiter of the foreign workers’ solar system.

Now let’s put them all together for some more perspective:bubblec

Software Engineers rule supreme, but you see that there are other titles that aren’t as exclusive as the top 3. That one little guy next to the top 3 is “Data Analyst,” which is a title I’d love to have in the very very near future.

Finally, here’s a nice bar chart that makes everything a lot more accurate to compare, but are not as fun to look at or make:

bar1

What makes a Dan Connolly?

I just want to start by saying that what happened in France on November 13, 2015 is a tragedy. My heart goes out to all of the victims and their loved ones. 

During one of my rare Facebook-browsing sessions, I noticed that a bunch of my friends had a flag of France overlay on their profile pictures. I know this is a feature that Facebook will show in your news feed that allows you to simply click a button to apply the overlay (I’ve done it before for the Mets…didn’t turn out too well). I looked all over and couldn’t find a way to do it for my own profile picture. Frustrated, I resorted to creating my own…

I loaded up MS Paint – the best computer graphics program in the whole world – to make some shitty version of my own France Facebook profile picture. After all, French is the highest proportion of heritage in me (contrary to popular belief, Irish is not first, but it is a close second). Then this got me all thinking about my own personal background and where my relatives are from. To the best of my knowledge, I believe I’m 3/8 French, 2/8 Irish, 1/8 German, 1/8 Dutch, and 1/8 Belgian.

So then I thought, “What’s cooler than putting numbers into a chart?” Answer: Nothing! Charts are awesome. So I opened up Excel, entered in my data, and made this cool chart to showcase my heritage:

treemap

This chart is called a treemap and I love it! I inserted flags as fills for the cells to give it more of a visual representation. It’s amazing how much you can do in Excel when you have simple data.

Anyway, where was I going with this? Oh yea! My Facebook profile picture…well I made one of those too as a sunburst chart:

profile

This one’s quite impossible to give accurate estimations of the relative proportions. To be honest, both charts are. If I was trying to present the data for numerical accuracy, I would have used a bar chart since the human brain is much better at determining relative proportions of lines than areas. But, these charts are more fun…and colorful!