Navigating tech interviews isn’t easy. You need to be across your chosen tech stack,<\/a> be up to date with current trends<\/a> and come across as the perfect fit for a team you haven’t met.<\/p>\n\n\n\n
This post hopes to help those\u00a0new to tech interviews<\/a> interpret what the interviewer is asking with ten questions that may be asked in a data analyst interview.<\/p>\n\n\n\n
What unique skills do you think can you add to our team?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
You may hear ‘skills’ and think that you need to start reciting how you know your JOINs<\/a>\u00a0and can\u00a0Index\u00a0<\/a>a table like a pro. This is an ok answer but doesn’t answer why you are unique.<\/p>\n\n\n\n
Better:<\/h4>\n\n\n\n
The interviewer is asking what makes you ‘unique’ and why they should consider you over other candidates. Go back to the job description and look for what problem this new hire will be solving.<\/p>\n\n\n\n
- Are you going to be part of a client-focused team that will mean you need to have strong stakeholder management skills?<\/li>
- Will you be working on\u00a0projects?<\/a><\/li>
- Are they in an industry where you have worked before?<\/li><\/ul>\n\n\n\n
Highlight how you have read the job description and understood the problem they are trying to solve with this new hire. You are a problem solver after all.<\/p>\n\n\n\n
\n\n\n\nWhat do you do to keep your technical skills up to date?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
Let the interviewer know what you’re reading<\/a>\u00a0right now, what your favourite\u00a0Tech Twitter<\/a>\u00a0accounts are and any tutorials or projects you’ve been working on.<\/p>\n\n\n\n
Better:<\/h4>\n\n\n\n
Expand on this by talking about the interesting things that have been happening in the industry right now.<\/p>\n\n\n\n
- Cloud computing and moving services to the\u00a0Cloud<\/a>.<\/li>
- Security,\u00a0Data Governance<\/a>\u00a0and privacy breaches.<\/li>
- How a\u00a0new framework or tool\u00a0compares to the existing options.<\/li><\/ul>\n\n\n\n
Relate these current trends in technology and tools to what the company is working on.<\/p>\n\n\n\n
- Has their move to the Cloud<\/a> been in the news recently?<\/li>
- Will they have to take more precautions with GDPR<\/a> legislation given the business they are in?<\/li>
- Ask if they are considering moving to a new framework or taking on a new tool?<\/a><\/li><\/ul>\n\n\n\n
\n\n\n\nDescribe an example where you played an active role in solving a business problem through an innovative approach<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
Describe the project:<\/p>\n\n\n\n
- What you worked on,<\/li>
- The challenges you faced,<\/li>
- The approach you came up with.<\/li><\/ul>\n\n\n\n
Better:<\/h4>\n\n\n\n
Focus on your specific contribution, rather than that of the team. Show how you were:<\/p>\n\n\n\n
- Diplomatic and attentive with stakeholders and team members<\/li>
- Wrote<\/a> documentation and were able to back up your approach.<\/li><\/ul>\n\n\n\n
Talk about customer or manager<\/a> feedback and how you’re interested in continually improving. Whether that’s through your own innovation or by taking on suggestions from your team<\/a>.<\/p>\n\n\n\n
\n\n\n\nUnderstanding Requirements<\/h2>\n\n\n\n
Provide an example where you had a customer extend the scope of work after the scoping had been completed and signed off?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
Describe an example of how you managed to work under pressure successfully. The interviewer is asking this question to gauge your ability to handle it.<\/p>\n\n\n\n
Better:<\/h4>\n\n\n\n
Be specific and realistic about how you deal with customers. The interviewer wants to see that you show empathy<\/a> and assertiveness.<\/p>\n\n\n\n
- You can anticipate change and push back on timelines<\/li>
- Understand that there is a tradeoff between quality and timeliness.<\/li><\/ul>\n\n\n\n
\n\n\n\nData Cleansing and Analysis<\/h2>\n\n\n\n
Is more data always better? Do you prefer raw or enriched?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
Describing the trade-offs between quality and quantity is a good start to show your understanding in this area:<\/p>\n\n\n\n
- Enriched, cleansed data<\/a> is easy to work with depending on your tools of choice.<\/li>
- More data can produce more complete data models if outliers are accounted for.<\/li>
- Cleansed data\u00a0takes longer to get into a normalised and enriched state – deduping, joining<\/a> to other datasets, adding to a relational model<\/a>.<\/li>
- Raw, granular data is expensive to store and move around.<\/li><\/ul>\n\n\n\n
Better:<\/h4>\n\n\n\n
It really depends on the project you are working as to whether you go with quality or quantity. However, the tradeoffs can always be tackled with tools:<\/p>\n\n\n\n
- AWS Kinesis,<\/a> and similar tools can send data in streams to avoid batch loading and the maintenance that comes with that.<\/li>
- Data Lakes\u00a0can be built with S3<\/a>, Glue and Athena to keep costs down.<\/li>
- Machine Learning<\/a> models can be deployed to do initial data cleansing and perform data quality monitoring when building new data sets.<\/li><\/ul>\n\n\n\n
\n\n\n\nWhat steps do you go through when processing and cleansing data in a typical project?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
Describe the different steps of a typical data analyst process:<\/p>\n\n\n\n
- Exploration,<\/li>
- Preparation,<\/li>
- Modelling,<\/li>
- Validation,<\/li>
- Visualisation<\/li><\/ul>\n\n\n\n
Focus on why data cleansing is important:<\/p>\n\n\n\n
- To find any anomalies and outliers.<\/li>
- Remove duplication and incorrect data.<\/li>
- Makes the data set easier to work with.<\/li><\/ul>\n\n\n\n
Better:<\/h4>\n\n\n\n
Take this one step further by talking about the best practices for data cleansing:<\/p>\n\n\n\n
- Taking an iterative approach and cleansing in logical chunks.<\/li>
- Developing a plan to identify where errors are occurring and to identify the root cause.<\/li>
- Verifying data is correct before it is signed off and allowed to flow into a model.<\/li>
- Script out as much as possible so the process can be repeated or rolled back when required.<\/li><\/ul>\n\n\n\n
\n\n\n\nWhich tools are you familiar with? What\u2019s your preference?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
This question isn’t just about which tools you use, it’s also an opportunity to talk about your experience with each tool. Analysts should be familiar with Excel<\/a>,\u00a0SQL<\/a>, a\u00a0visualisation tool<\/a>\u00a0and if required a statistical analysis tool or scripting language.<\/p>\n\n\n\n
- Excel<\/a><\/strong> – projects to aggregate data<\/a> using\u00a0Pivot Tables, and visualise the results using conditional formatting and graphs.<\/li>
- SQL<\/a><\/strong> – projects to\u00a0JOIN<\/a>\u00a0multiple datasets together and schedule them to run with a stored procedure.<\/li>
- Visualisation tool<\/a><\/strong> – projects to track the progress of sales<\/a> over time using multiple graphs. Thought needs to be put into the\u00a0colour, graph type and what the end-user is trying to get out of it.<\/li><\/ul>\n\n\n\n
Better:<\/h4>\n\n\n\n
Take this one step further by talking about any up and coming tools you have read about or tried using. Big data tools<\/a> like Hadoop and Spark, scripting languages like Python, libraries like D3<\/a> that make visualisations more interactive.<\/p>\n\n\n\n
\n\n\n\nDescribe an example of a complex analysis that you ran that you are particularly proud of, your approach and the insights gained<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
The interviewer<\/a> is looking for examples where you are not only proud of the work but can enthusiastically describe what you did and what the result was. This is hopefully the kind of work that you enjoy and may enjoy in the new role<\/a>.<\/p>\n\n\n\n
Make sure your example is:<\/p>\n\n\n\n
- Relevant to the role<\/li>
- Something you are genuinely proud to have worked on<\/li>
- Not sheer luck or where you only contributed a small part of a team project<\/li>
- True! Don’t embellish a story.<\/li><\/ul>\n\n\n\n
Better:<\/h4>\n\n\n\n
Talk about how this project helped push you forward:<\/p>\n\n\n\n
- Could you make changes to a process that then saved time or money?<\/li>
- Did your analysis feed into future work?<\/li>
- Did this success help you discover what you enjoy and what you are good at?<\/li><\/ul>\n\n\n\n
\n\n\n\nData Visualisation<\/h2>\n\n\n\n
What tools have you used to publish data to end users?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
This is an opportunity to show your understanding of the range of options for data visualisation and when they are appropriate.<\/p>\n\n\n\n
- Excel<\/strong> – if you have worked in a startup, small organisation or prefer Excel as a one-stop-shop. There is nothing wrong with using Excel for smaller datasets that don’t contain sensitive information.<\/li>
- Enterprise Tools<\/strong> – if you have worked in a bigger organisation you may have used Tableau, PowerBI or MicroStrategy. These are more expensive with associated licensing and training costs but provide a secure way to connect from database to visualisation layer.<\/li>
- Statistical Tools<\/strong> – if you have worked in academia or scientific fields you may have used SAS, R, Jupyter notebooks or SPSS to present data. These are much more specialised tools but are relevant for roles in these fields.<\/li>
- Web-based Tools<\/strong> – frameworks and libraries like D3<\/a> and HighCharts are increasingly common for infographics and web-based data visualisations.<\/li><\/ul>\n\n\n\n
Better:<\/h4>\n\n\n\n
Show that you know when to use one over the other and the drawbacks given each scenario:<\/p>\n\n\n\n
Excel<\/strong><\/p>\n\n\n\n
- Great for quick analysis<\/a> that is accessible and user-friendly.<\/li>
- Isn’t a secure way to share sensitive data and multiple copies may end up on individuals machines.<\/li><\/ul>\n\n\n\n
Enterprise Tools<\/strong><\/p>\n\n\n\n
- Provide a secure, scalable way to connect the database to the visualisation tool.<\/li>
- Expensive licensing arrangements and can be time-consuming to set up and train users.<\/li><\/ul>\n\n\n\n
Statistical Tools<\/strong><\/p>\n\n\n\n
- Specialised tools that allow the code for aggregation and visualisation to be run in the same place.<\/li>
- Conflicting libraries and package versions make it hard to share, less technical users might find it difficult to get started.<\/li><\/ul>\n\n\n\n
Web-based Tools<\/strong><\/p>\n\n\n\n
- Generally beautiful to look at and interactive.<\/li>
- Requires a different set of skills to set up and maintain, not always an appropriate way to publish sensitive data.<\/li><\/ul>\n\n\n\n
\n\n\n\nWhat form of supporting user help would you include?<\/em><\/p><\/blockquote>\n\n\n\n
Good:<\/h4>\n\n\n\n
The interviewer is looking for your preference in delivering support once you have completed a project. Do you prefer:<\/p>\n\n\n\n
- One-on-one support.<\/li>
- Presenting\u00a0<\/a>to a big group.<\/li>
- Writing or\u00a0blogging<\/a>\u00a0findings and ongoing insights.<\/li><\/ul>\n\n\n\n
Better:<\/h4>\n\n\n\n
Show you can evaluate what is more appropriate for the user and what ongoing help they might need.<\/p>\n\n\n\n
- Would you present your findings<\/a> in a different way when dealing with senior managers?<\/li>
- Would you consider the role of your end-user? A fellow analyst may have different questions than a colleague<\/a> in sales or marketing?<\/li>
- What would you do if your audience looked bored in your presentation?<\/a><\/li><\/ul>\n\n\n\n
\n\n\n\nAs hard as it is to believe but interviewers are not expecting perfectly scripted answers. The interviewer knows you are human and is looking for not only technical knowledge but cultural fit and how you communicate and think on your feet.<\/p>\n\n\n\n
Good luck with your interview preparation!<\/p>\n\n\n\n
\n\n\n\nPhoto by Miguel \u00c1. Padri\u00f1\u00e1n<\/a><\/strong> from Pexels<\/a><\/strong> <\/p>\n","protected":false},"excerpt":{"rendered":"