Job description template

Database Analyst Job Description

Database analyst job description: SQL, data quality and reporting duties, technical skills, qualifications and interview FAQs, ready to copy and adapt.

Database Analyst Job Description

The role in brief

A database analyst makes sure an organisation's data is stored well, stays accurate and can be used. The role sits between database administration and data analysis: analysts gather requirements from the business, design or change tables and data models, write SQL to extract and transform data, check data quality, and build the queries and reports that teams depend on. Employers typically ask for a bachelor's degree in computer science, information systems or a related field, and SQL is essential. Some employers also want certification in the specific database products they run. State in the posting which database platforms you use and whether the role leans towards data modelling, reporting or data quality, because each attracts a different candidate.

  • Gather data requirements from business users and translate them into tables, fields, views and queries
  • Write, test and optimise SQL queries, views and stored procedures for reporting and applications
  • Design and maintain data models and documentation such as entity relationship diagrams and data dictionaries
  • Profile data, find and fix quality problems such as duplicates, gaps and inconsistent formats, and set validation rules
For hiring teams

Paste the description into Cohesyve to find, contact and test Database Analyst candidates on the real work. 14-day free trial for 10 candidates, not charged until it ends.

Applying for a role like this? Practise the assessment free →

Responsibilities

  • Gather data requirements from business users and translate them into tables, fields, views and queries
  • Write, test and optimise SQL queries, views and stored procedures for reporting and applications
  • Design and maintain data models and documentation such as entity relationship diagrams and data dictionaries
  • Profile data, find and fix quality problems such as duplicates, gaps and inconsistent formats, and set validation rules
  • Build and maintain extract, transform and load (ETL) processes that move data between systems
  • Produce recurring and ad hoc reports and datasets for finance, operations and other teams
  • Work with database administrators on performance, indexing, backups and access permissions
  • Support data migrations and system changes by mapping fields and reconciling records before and after
  • Apply data security, privacy and retention rules to the data the role touches

Required skills

Advanced SQL, including joins, window functions, subqueries and query tuningRelational database design and normalisationExperience with at least one major platform such as SQL Server, PostgreSQL, MySQL or OracleData quality checking and reconciliationSpreadsheet skills for quick analysis and checking resultsClear documentation of tables, logic and definitionsTurning a vague business question into a precise data request
For hiring teams

Hiring a Database Analyst? Start from this description

Paste the description above into Cohesyve. It finds Database Analyst candidates, reaches out to them and tests each one on an AI job simulation of the real work, then returns a ranked shortlist. 14-day free trial for 10 candidates, not charged until it ends.

Nice to have

ETL or data pipeline toolsBI tools such as Power BI or TableauPython or another scripting language for automationCloud data warehousesVendor or vendor-neutral database certification

Qualifications

  • 1Bachelor's degree in computer science, information systems, IT, maths or a related field, or equivalent experience
  • 2Hands-on SQL experience in a production environment
  • 3Experience supporting business users with data and reports
  • 4Certification in your database products where you genuinely need it (list as preferred otherwise)

Work environment

Work environment

Database analysts work in offices or remotely, mostly full time, in almost every industry, with large concentrations in technology services, finance and insurance. Most of the day is at a computer writing queries, checking data and talking to the people who use it. Month-end reporting, migrations and system go-lives bring busier periods.

Career growth

Database analysts often move into database administration, data engineering or data architecture, or towards analytics as data analysts or BI developers. With experience, some move into data management or IT management roles.

Common questions

What does a database analyst do?

A database analyst designs, maintains and queries an organisation's databases so data is accurate and usable. Typical work includes writing SQL, modelling tables, fixing data quality problems, building ETL processes and producing reports for business teams.

What is the difference between a database analyst and a database administrator?

A database administrator keeps the database platform running: installation, performance, backups, security and availability. A database analyst focuses on the data inside it: structure, quality, queries and reports. In small teams one person often does both.

What qualifications do you need to be a database analyst?

Most employers ask for a bachelor's degree in computer science, information systems or a related field, plus strong SQL. Certification in a specific vendor's database is required by some employers and optional at most.

What skills should be on a database analyst resume?

The database platforms you have worked on, the level of SQL you write (with an example of a hard query you tuned), ETL and reporting tools, and concrete data quality or migration work you led. Name the business problems your data work solved.

How do you test a database analyst in an interview?

Give them a small schema with messy sample data and ask for two or three queries, one of which needs a window function, plus a note on the data quality issues they found. It shows SQL skill and attention to detail in one exercise.

For hiring teams

Put this Database Analyst job description to work

Cohesyve takes the description, finds Database Analyst candidates, reaches out to them and runs an AI job simulation of the work, then returns a ranked shortlist.

1,500+

assessments completed

50%

faster time-to-hire

5 min

from JD to assessment

14-day free trial · 10 candidates · Not charged until the trial ends

See Cohesyve in action

Free 30-min walkthrough

See it on your role