Data Analyst Boot Camp


Statisticians are sometimes surprised at the difficulty of finding entry level data analyst jobs despite having a college or graduate statistical degree.

In this issue, we will be answering a question posted by a statistician with Marketing, SAS and Clinical background who is finding it hard to get an entry level data analyst job!

How To Find a Marketing Data Analyst job

You need to broaden your skills by adding a number of more marketable Data Analysis skills and you also need to show more of your working marketing experience at the job interview.

Let\'s start by taking a look at what a data analyst does on a day to day basis:

What Does A Data Analyst Do?

  1. Data Validation - collects, validates and cleans data.

  2. Data Management - imports, transforms and loads data into a Microsoft Access, SQL Server or Oracle database using tools like SQL Server and Oracle Data Bulk Import Routines or Data Extraction, Transformation and Loading scripts.

  3. Statistical Data Analysis - analyzes data stored in a database using statistical principles, SQL Queries and tools like SAS, Microsoft Access, Microsoft Excel.

    Your post graduate background in statistics already equips and prepares you for this task.

  4. Reporting - prepares and distributes scheduled reports on data collected with tools like Crystal Reports, SQL Server Reporting Services, Business Objects, Microsoft Access Reporting.

    Some of these reports may have to be designed in tables using CSS/ HTML and some others will be presented as written documents or with graphs and charts.

    As a data analyst, you must be conversant with the process of producing reports distribution in multiple formats (HTML/CSS, PDF, Excel, CSV, Word)

How to Find a New Data Analyst Job

  1. Broaden your Data Analysis Skills: SAS and CDM (clinical data management) foundation courses alone may not be enough for an entry level data analyst job because data analysts work with other tools like Microsoft Excel, Microsoft Access, SQL Server and Oracle.

    So, an employer reviewing your resume may decide that the only data analysis tool (SAS) which you know, is not used or needed for the job in question.

  2. Database Skills Required for Data Analysis Jobs - with your post-graduate degree in Statistics, you are superbly positioned for entry level data analyst jobs.

    However you also need strong database skills because that is where the data you are working with will be stored in.

    Some Data Analyst tools provide you with an interface for analyzing data without looking at the underling tables or having to write SQL statements.

    However, many data analyst positions still require that you to have those skills even when you don't use them on the job. 

  3. Personal Branding for Data Analysts - your ability to market your career decides how you are perceived at the data analyst job interview.

    Based on your post-graduate statistics degree and your background in marketing, you should reposition yourself online as a skilled statistician or data analyst with a background in marketing because employers prefer skilled and experienced professionals.

    So, you need to review your resume, your presentation at job interviews and your online profile and determine if you are doing a good job at positioning your career.

    If you are not, then you need to start a personal branding campaign and use it to re-position your career.

My recommendations are that you broaden your skills by learning an enterprise database development platform and that you also start a personal branding campaign that positions you as an experienced statistical marketer.

I hope that I answered your questions about finding a data analyst job.

Please feel free to recommend our website to your friends and contacts, OK?


Subscribe to Data Analyst Boot Camp Newsletter

Get our latest posts delivered to your inbox ...

We respect your email privacy

If I graduated with a Mathematics degree in 1992 and have not used my maths skills for years what would be the best course for me to take, where, how long and how much ... and what would my realistic salary range be going into a data analyst role?
Cathie:\n\nIn 1992, a data analyst was essentially a mathematician or a statistician. \n\nThen the computer would be used primarily to perform complex peronalized calculations on smaller datasets because companies werent storing that much data.\n\nToday, the average data stored by a company is mind boggling especially when compared to what companies were storing in 1992 and databases managing gigabytes of data is now where the action is.\n\nWith this shift to data bases and data warehouses, the Data Analysts job has become synonymous with that of the Database Analysts job. This job requires someone to be highly skilled at writing SQL Queries and Database Design / Development.\n\nSo, what you have to do is to master the world of SQL and Relational Databases. The good news here is that SQL: is actually built on SET Theory and I imagine that you will be able to make a short work of that.\n\nBecause you already have a mathematical background, I suggest that the SQL Training Courses will be more appropriate for your needs.\n\nYou may also Click here to read more about SQL Query Writing / Database Design & Development which is more relevant to your situation like I said.\n\nA good salary for you as a first-time Data Anayst will be about $50,000 USD benchmarking with US Salary Scales and it may take anywhere from three to six months to get that first job because you don\'t have any a lot of experience to start with.
If you like this post, signup for more posts like this ...
I have just been asked by my ex-supervisor to apply for a data analyst position.
Essentially, the job requires using existing databases to run exisitng reports. Analyzing the data, data validation, etc.
I recently lead a project a data development project, and detailed work processes of our training department to create data requirements.
I also worked on developing a form within an exisitng database, to oversaw the transfer of data into this form, and then the generation of excel export.
I have some basic skills that have been developed as needed in my work environment.
Beyond that I have no formal training.
I pick up on software quickly and am able to manipulate it, etc.
What skillsets are these? Would the SQL Boot Camp be worth my while?