CareerDev4AI

Data Analyst

Transforms complex raw datasets into actionable commercial insights, executive dashboards, and statistical models that guide key business decisions.

Data & Analytics Entry-Mid level $70,000 - $110,000 / year

What the role involves

  • Author complex SQL queries to extract, transform, and clean raw data
  • Construct interactive visual dashboards in Tableau, Power BI, or Looker
  • Conduct exploratory data analysis and hypothesis testing on user behavior
  • Present analytical findings to senior stakeholders and business leaders
  • Define, track, and maintain business KPIs and metric reporting pipelines

Core skills

  • SQL (level 4/5)
  • Data Visualization (Tableau/Power BI) (level 4/5)
  • Excel / Spreadsheets Modeling (level 4/5)
  • Python for Data Analysis (level 3/5)
  • Statistical Analysis (level 3/5)
  • Business Communication (level 4/5)

Preferred skills

  • Pandas & NumPy
  • A/B Testing Methodology
  • Data Warehousing (BigQuery/Snowflake)
  • Stakeholder Management

Tools

SQLTableauPower BIPythonJupyterBigQueryExcelSnowflakedbt

Experience expected

1-3 years in quantitative analysis, data reporting, or degree in STEM / Economics

Projects that prove the role

  • Customer churn analysis pipeline identifying key drop-off drivers
  • Marketing campaign attribution and ROI automated executive dashboard
  • Inventory forecasting model optimizing supplier reorder cycles

Evidence to collect

  • A published dashboard answering a real business question
  • An analysis write-up stating the decision it informed
  • A reproducible SQL project with documented assumptions

What the interview covers

  • SQL joins, window functions, CTEs, and query optimization
  • Interpreting p-values, confidence intervals, and selection bias in tests
  • Communicating technical data nuances to non-technical stakeholders
  • Dashboard layout principles and choosing optimal chart encodings

How the role progresses

  • Junior Data Analyst
  • Data Analyst
  • Senior Data Analyst
  • Analytics Lead
  • Head of Business Intelligence

Certifications that carry weight

  • Google Data Analytics Professional Certificate
  • Tableau Certified Data Analyst

Related roles

  • data-scientist
  • product-manager
  • business-analyst

Turn this into a plan

Inside CareerDev4AI, choosing this role generates a roadmap of the skills, projects and milestones that move you towards it.

Plan this career