The Life of a Data Analyst

Data analysts collect, process and perform statistical analyses of data. Their skills may not be as advanced as data scientists (e.g. they may not be able to create new algorithms), but their goals are the same – to discover how data can be used to answer questions and solve problems.

Data Analyst Responsibilities

Depending on their level of expertise, data analysts may:

• Work with IT teams, management and/or data scientists to determine organizational goals
• Mine data from primary and secondary sources
• Clean and prune data to discard irrelevant information
• Analyze and interpret results using standard statistical tools and techniques
• Pinpoint trends, correlations and patterns in complicated data sets
• Identify new opportunities for process improvement
• Provide concise data reports and clear data visualizations for management
• Design, create and maintain relational databases and data systems
• Triage code problems and data-related issues

Data analysts are sometimes called “junior data scientists” or “data scientists in training.” Instead of being free to create their own big data projects, they may be limited to tackling specific business tasks using existing tools, systems and data sets.

However, there are plenty of companies who don’t make a clear distinction between the two roles. In some cases, a data analyst/scientist could be writing queries or addressing standard requests in the morning and building custom solutions or experimenting with relational databases, Hadoop and NoSQL in the afternoon.

2018 Data Analyst Average Salaries

Salary numbers are dependent on job responsibilities. A senior data analyst with the skills of a data scientist can command a high price. An entry-level data analyst with basic technical tools might be looking at anything from $35,000 – $45,000 per year.

According to a report updated on January 27, 2018 on PayScale, the highest paying data analysts jobs were in – you guessed it – San Francisco. There the median pay for analysts was $70,041 (more than 25% above the national average). The silver medal went to Washington, where the median pay is $62,954 (about 13% above the national average).

Data Analyst

Glassdoor
Average Salary: $65,470 per year
Minimum: $46,000
Maximum: $92,000

PayScale
Median Salary: $57,675 per year
Total Pay Range: $40,476 – $81,864

Senior Data Analyst

Glassdoor
Average Salary: $82,629 per year
Minimum: $59,000
Maximum: $114,000

PayScale
Median Salary: $76,605 per year
Total Pay Range: $56,422 – $103,489

Note: Salary information from Glassdoor and PayScale was retrieved as of January 2018.

Data Analyst Qualifications

What Kind of Degree Will I Need?

Most candidates for entry-level jobs will need a bachelor’s degree in math, statistics computer science, information management, finance or economics. All of these subjects place a heavy emphasis on statistical and analytical skills.

To climb the career ladder or transition to the role of a data scientist, you will probably be required to earn a master’s degree or graduate certificate in a similar field.

Note: We discuss the possibilities of self-education in our section on Data Scientist Qualifications.

What Kind of Skills Will I Need?

Technical Skills

• Statistical methods and packages (e.g. SPSS)
• R and/or SAS languages
• Data warehousing and business intelligence platforms
• SQL databases and database querying languages
• Programming (e.g. XML, Javascript or ETL frameworks)
• Database design
• Data mining
• Data cleaning and munging
• Data visualization and reporting techniques
• Working knowledge of Hadoop & MapReduce
• Machine learning techniques

This is a sample list and subject to change.

Business Skills

• Analytic Problem-Solving: Employing best practices to analyze large amounts of data while maintaining intense attention to detail.
• Effective Communication: Using reports and presentations to explain complex technical ideas and methods to an audience of laymen.
• Creative Thinking: Questioning established business practices and brainstorming new approaches to data analysis.
• Industry Knowledge: Understanding what drives your chosen industry and how data can contribute to the success of a company/organization strategy.

What About Certifications?

There are scores of big data certifications available from independent organizations and specific companies (e.g. SAS). When in doubt, ask your mentors for advice, check job listing requirements and consult articles like Tom’s IT Pro “Best Of” certification lists to determine which ones will help advance your career.

Certified Analytics Professional

We take a closer look at this qualification in our section on Data Scientist Certifications.

Certified Data Management Professional (CDMP)

Authorized by the non-profit Data Management Association International (DAMA), the CDMP credential is offered at four levels: associate, practitioner, master and fellow. To become an associate CDMP, candidates must have at least 6 months experience in their data role and a strong knowledge of DMBOK principles. Candidates who have more than 5 years of data management experience can begin their path to fellow CDMP as a practitioner. After 10 years and proven skill expansion and contribution to the data management profession, practitioners can apply to become a master CDMP. CDMP Fellows are extensive experience within the data management field and make consistent contributions to the field as a speaker, publisher of research, workshop presenter and other similar means.

EMC Proven Professional Data Scientist (EMCDS)

We take a closer look at this qualification in our section on Data Scientist Certifications.

SAS Certified Base Programmer for SAS 9

If you’re new to SAS programming or SAS certification, this is one credential to consider. Sponsored by SAS, the certification exam tests candidates on their ability to import and export raw data files, manipulate and transform data, combine SAS data sets and identify and correct data, syntax and programming logic errors.

Jobs Similar to Data Analyst

“Data Analyst” is an umbrella term. In many cases, Market Research Analysts, Quantitative Analysts, Operations Analysts and other similar field-specific positions can be found under its shade. You’ll also see a good deal of job crossover with Business Intelligence Analysts, Data Warehouse Analysts and Business Systems Analysts.

As we’ve noted, senior data analysts are close siblings to Data Scientists and Analytics Managers. At the upper levels of management, there may be no clear distinction between the 3 roles.

Analysts who grow tired of analyzing may wish to investigate data construction jobs such as:

• Data/Big Data Engineer
• Data/Big Data Architect
• Hadoop Developer

Data Analyst Job Outlook

Today’s data analysts should be prepared for a change. Self-service business intelligence software and automation is replacing many of the regular tasks that – in the past – technical experts would have been required to handle.

As Eran Levy points out, executives can now monitor KPIs, build dashboards, generate data reports and identify business strengths and weaknesses by themselves.

On the other hand, statistical gurus clean, filter and convert billions of diverse data points. They employ complex modeling and predictive analytics techniques to generate useful insights and actions. Then they have to explain what they’ve discovered to rooms of confused laymen.

In other words, they have to transform themselves from data analysts into data scientists.

Helpful Professional Organizations

• Data Management Association International (DAMA)
• Data Science Association
• Digital Analytics Association (DAA)
• International Institute for Analytics (IIA)
• International Machine Learning Society (IMLS)
• Institute for Operations Research and the Management Sciences (INFORMS)
• Association for Computing Machinery’s Special Interest Group on Knowledge Discovery and Data Mining (SIGKDD)