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.

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
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
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
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
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.
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
From the blog