The University of Pittsburgh Computer Science Club has compiled a list of tech internships on Github for Summer Internships! Go through the links to explore the various openings. They also have a list of new Grad Applications if that interests you instead. All in all, this is an excellent resource for job and internship search.
Responsibilities of data analysts will vary depending on the type of organization and the extent to which a business has adopted data-driven decision-making practices. Usually, the responsibilities of a data analyst include:
- Designing and maintaining data systems and databases; this involves fixing coding errors and other data-related problems.
- Mining data from primary and secondary sources then reorganizing it in a format that humans or machines can easily read.
- Using statistical tools to interpret data sets, highlighting trends and patterns important for diagnostic and predictive analytics efforts.
- Preparing reports for leadership that effectively communicate trends, patterns, and predictions using relevant data.
- Collaborating with programmers, engineers, and organizational leaders to improve processes, recommend system modifications, and develop policies for data governance.
- Creating documentation that allows stakeholders to understand the data analysis process and duplicate or replicate the process if necessary.
Data Analyst vs. Data Scientist vs. Business Analyst
When reading about data analysts, you might also be wondering about the similarities and differences between other related careers like data scientist and business analyst. The differences between what they do comes down to how the three roles use data:
- The data analyst gatekeeps an organization’s data so stakeholders can understand and use data to make strategic business decisions. It is a technical role that requires an undergraduate degree or a master’s degree in analytics, computer modeling, science, or math.
- A business analyst serves a strategic role focused on using the data analyst’s information to find problems and propose solutions. These analysts typically earn a degree in a major such as business administration, economics, or finance.
- The data scientist takes the data visualizations created by data analysts and sifts through them to find weaknesses, trends, or opportunities to organize the data. This role also requires a background in math or computer science, along with some study or insight into human behavior to help make informed predictions. At startups and other small organizations however, it is not uncommon for a data analyst to take on some of the predictive modeling or decision-making responsibilities that may otherwise be assigned to a data scientist.
Education and Training:
A bachelor’s degree is necessary to get started in the field. While many people begin a data analytics career with a degree in math, statistics or economics, Lawrence’s Statistics and Data Science minor would be a nice supplement to any student with a quantitative skillset who is interested in a post-graduate role as a data analyst.
Within a bachelor’s program, you may wish to explore courses in mathematics while also pursuing classes and research projects focused on data mining, simulation and optimization. You can learn to find and define data challenges across industries, gain hands-on practice collecting and organizing information from many sources and explore how to examine data to find relevant information.
A master’s in data analytics can further your career, exploring how to use data to make predictions and how data relates to risk management. This also helps you dive deeper into data-driven decision-making, explore project management and develop communication and leadership skills. Finding an internship can give hands-on experience that helps you stand out when applying for data analyst jobs.
Pay and Job Outlook:
The average salary ranges from approximately $60,000 to $138,000. Roles at financial and technology firms tend to pay higher than average. The data analyst role can also act as a gateway for more senior data-driven jobs. According to PayScale, data analysts move on to roles such as senior data analyst, data scientist, analytics manager, and business analyst which also come with substantial increases in pay. According to IBM, the annual salary of data scientists will start at nearly $95,000, while analytics managers will make nearly $106,000 per year. Moreover, demand for mathematicians and statisticians is projected to grow by 33% and jobs for database administrators are expected to grow by 8% through 2030 according to the BLS.
Adapted from simplilearn.com and psychologicalscience.org
R is an open-source programming language often used as a data analysis and statistical software tool. It’s particularly useful for machine learning operations and data wrangling. If R is widely used, what are some potential advantages and drawbacks and is it really worth learning?
Here are some advantages:
- It’s open source. No fees or licenses are needed, which is why if you’re developing a new program, it’s a low-risk venture.
- It’s platform-independent, which means that it runs on all operating systems. This allows developers to only create one program that can work on competing systems. This is also why R is cost-effective.
- R is great for statistics – it can do many things from regression equations to frequentist and Bayesian statistics. It can bootstrap, simulate, randomize and resample your data which is why it’s widely used in the data sciences.
- It’s well suited for Machine Learning. R is ideal for machine learning operations such as regression and classification.
- R lets you perform data wrangling which involves turning unstructured, messy data into a structured format. This involves merging data sets, cleaning data and identifying important rows or columns. R also creates formatted tables, complete with significance stars. For this reason, R is often used in financial tech industries and in academia.
- It visualizes data well because there are packages dedicated to making pretty plots.
- It has a steep learning curve. It’s best suited for people who have some previous programming experience.
- It’s not as secure. R doesn’t have basic security measures. Consequently, it’s not a good choice for making web-safe applications and it can’t be embedded in web browsers.
- It’s slow. R is slower than other programming languages like Python or MATLAB.
- It has bad memory management, so it takes up a lot of memory when running code. R’s data must be stored in physical memory however, the increasing use of cloud-based memory may eventually lessen the negative effects of this drawback.
- It doesn’t have consistent documentation/package quality. Docs and packages can be patchy and inconsistent, or incomplete because it doesn’t have official support and instead is maintained and added to by the community.
Some stat classes at Lawrence already teach people how to use R like STAT 255, CMSC 205 and ECON 380. You can also install RStudio yourself since it’s free and use online teaching and coding resources like Datacamp to do so as well.
In Part 1 of our series “What Can I Do With a Computer Science Degree?”, we started looking at the kinds of jobs you can do with a Comp Sci degree and what are the main differences between these options. Because of how broad computer science’s applications are, there are many careers. Here are some more options for you to explore!
5) Data Scientist:
Data scientists create mathematical models to address real-world problems to help companies make decisions on anything ranging from how to reduce workplace accidents to how they should market their products.
Programming languages many data scientists use include Python, R and Java as they’re good for analyzing and visualizing data and SQL which is used for database management. Other important tools they need to know how to use include Hadoop (an open-source software used to work with big data), SAS (suite of software products used to do data management and analysis for business insights), data mining and warehouse where data mining is the process of looking through big datasets and data warehouse is a system created for data analytics. And they need to be familiar with machine learning which examines models and algorithms to analyze large datasets.
Soft skills include analytics and good problem-solving skills because data scientists need to understand and analyze their data well to see how they can use that information to solve problems. Clear writing and public speaking skills are also necessary because data scientists will need to explain their findings and interpretations to clients, employers and other team members. Being business-focused is also useful as many employers seek data scientists to help them improve their business strategies.
6) Web Designer:
Website designers plan and create engaging websites that look aesthetically pleasing and help site users find what they need. Once they finish their creations, designers pass their ideas to web developers who bring the plans to life. However, some designers double as developers and can create websites after designing them.
Other necessary skills include using software like Adobe Illustrator and Adobe InDesign. CSS is a style sheet language that is used alongside HTML to change aspects like fonts, layers and colors. Excellent graphic design skills can help web designers stand out from everyone else so honing these skills in addition to technical ones is important.
7) Security Analyst:
Information security analysts focus on data and network protection to protect their companies’ or organizations’ digital assets. To do so, they need to stay informed about changes in such a fast-evolving field. Information security analysts work with executives, IT teams, and colleagues across their organizations and sometimes train employees about best practices. They establish company security protocols, conduct tests to search for system weaknesses and develop response plans in case security breaches happen. Aside from the challenge of staying up to date with current technology, information security analysts may sometimes deal with stressful situations if a cyberattack occurs.
Top employers include computer systems design and related services, finance and insurance, and information. Information security analysts usually need a computer science-related bachelor’s degree. With some companies looking for an MBA in information systems. Industry-standard certifications can boost employment prospects for professionals in the field. A security analyst’s job revolves around data and network protection.
Important hard skills an analyst would need to have include knowing about industry-standard programs like Blackboard, Apache Ant, Symantec, and Django. They also need to know about various databases and software for development, programming, network monitoring, and virus protection. They must also write code to prevent and respond to cyberattacks and need a strong knowledge of how networks function to solve security problems. Key soft skills include strong problem solving, analysis, being attentive to detail and communication skills since they need to analyze and solve security problems effectively then communicate that information clearly to team members, executives and clients throughout the organization.
8) Software Engineer:
Computer software engineers apply engineering principles and systematic methods to develop programs and operating data for computers. They work with system programmers, analysts, and other engineers to obtain and apply important information for designing systems, projecting capabilities, and determining performance interfaces. They also analyze user needs, offer advice about designing elements, and help with software installation. Designing software systems requires professionals to consider mathematical models and scientific analysis to project outcomes.
Important soft skills include good communication and organization skills. Software engineers will often need to split attention across different parts of the same project or switch between projects when working on a deadline or to meet the team’s needs. Being attentive to detail is necessary too as they must troubleshoot coding issues and bugs as they happen and track details of many ongoing projects.
9) Computer and Information Systems Manager/Systems Manager:
Computer and information systems managers generally oversee the information technology departments within businesses and organizations. A systems manager’s duties depend on organization size and how much technology they use daily. In smaller settings, systems managers may offer support on an as-needed basis, while larger organizations may need larger IT departments with more hands-on systems manager roles.
Important hard skills systems managers would need to know include network and IT management, which involve overseeing wireless networks, cloud storage, and other systems of data storage and communication and managing daily IT operations or providing support when needed. Project management is a necessary skill because you would be overseeing many IT-based projects like implementing a new computer system, teaching employees how to use a new piece of software or creating new data storage or recordkeeping systems. Knowing how to use MS Office well is necessary as Microsoft creates and manufactures most of the software used by businesses and organizations.
Soft skills to develop include strong analytical and organizational skills. Leadership skills are important because computer and information systems managers guide the collective efforts of systems analysts, information security professionals, and software developers. As team leaders, they need to delegate, accept responsibilities and always be trustworthy and reliable. System managers need to write reports, instruction manuals and relay information to people with varying technical backgrounds in clear and understandable ways.
Generally, systems managers hold at least a bachelor’s degree. Graduate education can increase earning potential and may open doors to paths to more advanced careers, but they aren’t necessary.
If you want to have a deeper look at more specific aspects like salaries and other education requirements, you can check the careers page on computerscience.org. To get help on getting started with a job or internship search, resumes, or interviews or anything else feel free to make an appointment at the Career Center!
There are many job searching platforms that exist. Some are bigger, such as LinkedIn and Indeed, and some are smaller. Although using the bigger platforms is important to network, meet people and build relationships, knowing about smaller platforms that are focused on specific niches can be to your advantage when looking for a job. In this article, I tried to find some of these smaller platforms to see what advantages there are about using them, why you should sign up for them, and if they are worth the money they ask.
If you are looking for a job in finance, IHire Finance is very directed towards finance jobs. On this platform, you will find job opportunities from Budget Analysts, Corporate Financial Consultant, Investment Banking Analyst to Equity trader, compliance manager, and even VP of Finance. Although this platform focuses mostly on higher-paying jobs for more experienced people, I was able to find some entry-level jobs as well as even internships related to finance. While this platform offers a lot of very good information about the jobs and gives very useful insights, it does come with a cost. The cost to become a premium user for IHire Finance is $35/month and it comes with resume guidance, your resume will be highlighted to employers, a dedicated support team ready to assist you, and salary insights. If you are looking for a job in Finance, I would recommend signing up for this platform as it could be a good investment to find the best fitting job for you.
If you really want some extra help in finding the best possible career in industries such as software engineering, marketing, data science, or sales, Pathrise offers a service in which you will be able to work 1-1 with a personal mentor that will help you focus on what you need to do in order to land your dream job. Based on their website, their service is free until you’ve already landed a position at a top technology company. Pathrise has both customers that have many years of experience and want to try to get a better job and customers that are right out of college and want to try to find the best fitting job for them. Although I personally didn’t try this service, it might be interesting to work 1-1 with an expert to see what they think you need in order to get to the next level and find the perfect job.
MarketingHire is considered one of the best Job Boards for Marketing and Advertising Professionals. If you are looking for a job in Marketing or Public Relations, this free website is a great tool that you could use. Based on their website, companies like Microsoft, 3M, General Electric, Google, and many more posts their job offers on this platform. Applying to these postings on a smaller platform could differentiate you from other people. This website is useful for both higher-paying jobs and internships.
There are many other job searching platforms that could be useful to find your dream job. Although I tried, finding the perfect one isn’t easy. The best thing to do is to try them out for yourselves, see if there are opportunities one some of these smaller platforms that you think could be good for you, and apply. Platforms like LinkedIn and Indeed are very important and you should always keep using them. However, having another way in through a smaller platform will show employers that you are looking for new ways, you are doing your homework and you are willing to be different than everyone else and go the extra mile to find the job you want.
If you have any questions about these platforms, or you would like to talk to me about more platforms that you found that could be useful for other students, please don’t hesitate to email me or schedule an appointment with me.
It’s time to practice for your interview! While knowing what experiences you have had in the past is very important, knowing how to answer behavioral questions can make the difference between being hired or not. Behavioral questions are designed to learn how you would respond to a specific workplace situation, and how you solve problems to achieve a successful outcome. Here is a list of possible behavioral questions that they could ask you divided into different sections.
With teamwork behavioral questions, interviewers get a sense of whether or not you like working on a team, how well you work in groups, and what role you tend to take on a team project (leader, mediator, follower..). These questions also show whether you are easy to get along with, which is important in almost any work environment.
- Talk about a time when you had to work closely with someone whose personality was very different from yours
- Give me an example of a time you faced a conflict while working on a team. How did you handle that?
- Tell me about a time you wish you’d handled a situation differently with a colleague
Client-facing skills behavioral questions give interviewers a way to see how you react to different kind of clients. What would happen if the client is frustrated, or if there a large number of clients waiting and how you can handle that pressure.
- Tell me about a time when you made sure a customer was pleased with your service
- Describe a time when you had to interact with a difficult client. What was the situation, and how did you handle it?
- When you’re working with a large number of customers, it’s tricky to deliver excellent service to them all. How do you go about prioritizing your customers’ needs?
Ability to adapt
The ability to adapt is a very important soft skill that is required in any job. The way you answer these questions will give a sense of how you are able to adapt in a new working space and how flexible you are to change and adjust to new situations.
- Tell me about a time you were under a lot of pressure. What was going on, and how did you get through it?
- Give me an example of a time when you had to think on your feet in order to delicately extricate yourself from a difficult or awkward situation
- Tell me about a time you failed. How did you deal with the situation?
- Tell me about how you worked effectively under pressure
Time management skills
Time management is another very important skill to have. When one of these questions is asked, make sure you are clear about how you managed your time carefully, what tools did you use and why did those tools help.
- Describe a long term project you managed. How did you keep everything moving along in a timely manner?
- Tell me about a time you set a goal for yourself. How did you go about ensuring that you would meet your objective?
- Tell me about a time you had to be very strategic in order to meet all your top priorities
The ability to communicate is closely evaluated in a job interview. Some recruiters will not ask questions directly related to communication in the interview but just see how the candidate is able to communicate during the interview. However, other recruiters might ask you behavioral questions that show the candidate’s communication skills with a real life example.
- Tell me about a successful presentation you gave and why you think it was a hit
- Tell me about a time you had to explain something fairly complex to a frustrated client. How did you handle the situation?
Motivation and values
Motivation and values behavioral questions are asked to see what values and what kind of personality the candidate has. It is important to always be honest and show how your personality could be an asset for the company.
- Tell me about a time you saw a problem and took the initiative to solve it rather than waiting for someone else to do it
- Tell me about your proudest accomplishment in work or school
- Tell me about a mistake you’ve made. How did you handle it?
- Tell me about a challenging situation you overcame at work
- Tell me five things that you are NOT
How to prepare to answer behavioral questions
Read the job description carefully. Make a list of the top skills or qualifications it calls for. Think of a story that demonstrates your ability in each area. Following the STAR technique, write your stories down, including the situation, task, action and result. Then, practice saying them out loud several times. Your answers should only take about 1 ½ to 3 minutes. In order to make a good impression, telling stories that are related to each one of these questions is crucial. Telling stories is the best way to be remembered by the recruiter.
Practice is the best way to succeed at behavioral interviews. If you would like to practice doing behavioral interviews, please don’t hesitate to reach out to me (firstname.lastname@example.org) or Grace Kutney (email@example.com).
Oliver De Croock ’24, Student-Athlete at Lawrence University majoring in Economics and Career Peer Educator. Connect with me on LinkedIn.