Data Analyst

Position Title:

Department:

Reports To:

Work Location:

Position Summary

The Data Analyst with DBA skills will be responsible for supporting both data analytics and database performance needs across the organization. This role includes maintaining data quality, creating actionable reports, administering SQL Server databases, and optimizing query performance. The ideal candidate brings a blend of analytical thinking, database administration expertise, and business intelligence experience.

Essential Duties and Responsibilities

Key responsibilities include, but are not limited to:

• Develop and maintain complex SQL queries for reporting, data analysis, and performance tuning.
• Administer SQL Server databases, ensuring uptime, performance, and security of database systems.
• Perform database performance analysis, capacity planning, and query optimization.
• Monitor and maintain internal database architecture and configuration best practices.
• Create insightful dashboards and reports using standard BI tools such as Apache Superset, Power BI, or similar.
• Analyze large volumes of data to identify trends, anomalies, and insights that support business decisions.
• Collaborate with engineering and business teams to understand reporting needs and deliver accurate and timely insights.
• Perform backup and recovery tasks, patch management, and security auditing as part of DBA responsibilities.
• Document database configurations, data models, and reporting structures for ongoing support and compliance.
• Ensure data accuracy, consistency, and availability through proper monitoring and maintenance practices.

Supervisory Responsibilities

• None

Qualifications

To perform this role successfully, candidates must meet the following requirements:

Education & Experience

• Bachelors degree in Computer Science, Information Systems, Data Analytics, or a related field (preferred).
• Minimum of 4 years of professional experience in data analysis and database administration.
• Strong hands-on experience with

  SQL Server

  , including

  query tuning

  and

  performance optimization

  .
• Deep understanding of

  database administration tasks

  , including architecture, configuration, backup/recovery, and security.
• Experience working with

  BI/reporting tools

  such as Apache Superset, Power BI, Tableau, or similar.
• Strong data analysis, data visualization, and data profiling skills.
• Familiarity with database indexing, partitioning, and high availability strategies.
• Strong communication and collaboration skills to work effectively with technical and non-technical stakeholders.

Language Skills

• Ability to understand and create technical documentation.
• Capable of writing professional correspondence and conveying technical information clearly.
• Strong verbal communication skills for explaining complex data issues to diverse audiences.

Mathematical Skills

• Proficient in statistics, percentages, and data-driven calculations used in reporting and analysis.

Reasoning Ability

• Strong problem-solving and analytical thinking skills.
• Ability to diagnose and troubleshoot performance issues independently.
• Capable of prioritizing tasks and managing time in a fast-paced, data-driven environment.

Computer Skills

• Proficient in SQL Server database management and performance tuning tools.
• Familiar with BI/reporting platforms like Apache Superset, Power BI, or Tableau.
• Knowledge of scripting or automation using SQL or other tools is a plus.

Certificates and Licenses

• None required (Relevant SQL Server or BI tool certifications are a plus)

Travel Requirements

• Minimal travel (up to 5%) may be required for training, meetings, or conferences.

Work Environment

• Work is performed in a standard office environment with climate control.
• Reasonable accommodations may be made for individuals with disabilities.
• No substantial exposure to adverse environmental conditions.

Information Security & Privacy Compliance

• Follow secure practices for managing data access and system permissions.
• Ensure sensitive data is encrypted and protected according to internal policies.
• Comply with data governance and regulatory standards (e.g., GDPR).
• Support audits and maintain documentation for system changes and configurations.

Position Description Acknowledgment

By signing below, I acknowledge that I have reviewed and understood the duties and expectations associated with the Data Analyst (with DBA Skills) role. I understand that responsibilities may evolve over time and agree to communicate with my supervisor for clarification as needed. I also understand that performance evaluations and compensation may be tied to fulfilling these responsibilities.

Employees Name (Print):

Employee’s Signature:

Manager’s Signature:

Version 1 – Effective June 2025