Data Analyst

How to hire a Data Analyst for your SMB

Before you write the job posting, settle three questions. They decide which profile you are actually looking for and help you avoid the most common mistakes in data hiring at a German SMB.

Question 1: Data Analyst, Data Scientist or BI Analyst? A Data Analyst answers business questions with SQL and a BI tool and supports decisions. A Data Scientist builds predictive models, works often with machine learning in Python and invests in production models. A BI Analyst focuses on building and maintaining dashboards. At an SMB with under 50 people you almost always need an analyst, not a scientist: your most expensive problems are unanswered business questions, not missing ML models. Hiring a scientist in a reporting context leads to a resignation in 6 to 12 months, because they are under-challenged and the model infrastructure is missing. If the need revolves purely around dashboard maintenance with no open analytical business questions, check whether a BI Analyst role (narrower scope, lower compensation, a different skill mix) would not be a better fit.

Question 2: How mature is your data infrastructure? An analyst with 3 years of practice at a data-mature scale-up (Snowflake or BigQuery, dbt models, a Looker stack, documented metric definitions) works differently from someone who started in an early-stage environment (raw product data, no warehouse, Excel and Google Sheets as the main workplace). Both profiles are valuable but fit differently. In an early-stage environment you want a profile who is productive without infrastructure, pragmatically builds what is missing, and answers business questions with what is there. In a mature scale-up you want a profile who works in a structured layer, develops dbt models further and goes deeper in an established BI tool. Crossing the two profiles leads to frustration in 6 to 12 months. Describe your data infrastructure openly in the ad; that filters fitting profiles automatically.

Question 3: Where does the role sit organizationally? A Data Analyst at an SMB works best as a business function with technical depth, not as a tech function with business exposure. A reporting line to management, the CFO or the COO opens direct access to strategic questions and positions the role as a sparring partner to the business functions. Embedding in the engineering team with a reporting line to the CTO works in the first few months but limits the role’s impact in the medium term: the analyst increasingly ends up on technical tickets instead of business questions. Clarify the organizational reporting before hiring, because it co-determines the profile of the right candidate.

If all three answers point to a Data Analyst in the classic sense (business analyses, SQL-centric, with a reporting line to management or finance), see the ready-to-use template on the Job description tab.