Data analyst job description template

Position Identification

1. Position Summary

The Data Analyst collects, organizes, and analyzes operational, financial, and workforce data to support evidence-based decision-making across [ORGANIZATION_NAME]. Reporting directly to [REPORTS_TO_TITLE], the role is responsible for transforming raw business records into reliable reports, dashboards, and data models. The position serves as an internal analytics resource, ensuring operational leaders have accurate, timely visibility into core business metrics. The primary outcome of this role is the delivery of high-integrity data insights that improve operational efficiency, minimize reporting errors, and identify business trends.

2. Key Responsibilities

2.1 Data Extraction, Transformation, and Integration (20%)

• Extract structured and semi-structured datasets from core operational databases, flat files, [HRIS_NAME], and [PAYROLL_SYSTEM] using structured query language (SQL) and automated data connections.
• Validate incoming raw datasets against source system records to identify missing values, corrupted rows, and schema inconsistencies.
• Consolidate transactional and operational data streams into standardized data tables to enable recurring analysis and business reporting.

2.2 Reporting and Dashboard Development (20%)

• Design, build, and maintain operational dashboards and automated management reports using business intelligence tools and spreadsheets.
• Translate operational metrics into clear visual charts, trend summaries, and exception reports for consumption by [OWNER_OR_MANAGER].
• Document calculation logic, metric definitions, and source table references in a centralized data dictionary to maintain institutional knowledge.

2.3 Data Quality Assurance and Governance (15%)

• Execute routine data quality audits across transactional and operational records to identify duplicates, formatting discrepancies, and calculation errors.
• Perform data cleansing and normalization routines prior to running scheduled analytical models or management distributions.
• Safeguard personal information and confidential business data during storage, processing, and distribution in compliance with organizational security controls.

2.4 Operational and Trend Analysis (15%)

• Conduct descriptive and diagnostic analyses to evaluate operational performance, labor allocation, service delivery patterns, and cost drivers.
• Identify variance patterns between budgeted and actual operational performance, providing initial variance commentary to [REPORTS_TO_TITLE].
• Summarize analytical findings into clear, written briefing notes and structured tables that outline key findings and operational risks.

2.5 Ad-Hoc Analytics and Decision Support (10%)

• Execute custom data queries and ad-hoc analytical requests submitted by [OWNER_OR_MANAGER] within agreed service timelines.
• Assist operational supervisors with interpreting dashboard outputs, identifying underlying data limitations, and clarifying metric calculations.
• Prepare standardized data extracts for external reporting, compliance submissions, and year-end accounting reconciliations as directed.

2.6 Process Automation and Continuous Improvement (10%)

• Automate manual, spreadsheet-based data consolidation processes to reduce human error and eliminate administrative processing delays.
• Recommend improvements to source-system data entry workflows to prevent data quality defects at the point of initial capture.
• Test new system updates, data schema modifications, and software enhancements within [HRIS_NAME] or operational tools prior to deployment.

2.7 Documentation and Asset Management (10%)

• Maintain comprehensive standard operating procedures (SOPs) for all recurring weekly, monthly, and quarterly reporting cycles.
• Version-control analytical scripts, query files, and dashboard workbooks within approved company storage repositories.
• Archive historical reporting records in accordance with [ORGANIZATION_NAME] data retention schedules and privacy guidelines.

3. Qualifications & Experience

Role Qualifications Matrix

4. Competencies

Core Competency Framework

5. Working Conditions & Performance Measures

5.1 Working Conditions and Physical Demands

Physical and Environmental Demands Matrix

5.2 Performance Measures

Key Performance Indicators (KPIs)

5.3 Career Path

• Typical Prior Roles: Junior Data Analyst, Reporting Specialist, Business Operations Coordinator, Data Entry Lead, Junior Financial Analyst, Systems Support Clerk.
• Typical Next Roles: Senior Data Analyst, Business Intelligence Lead, Operations Analytics Manager, Systems & Reporting Administrator, Commercial Operations Analyst.

5.4 Acknowledgement and Sign-off

This job description outlines the primary duties, responsibilities, and operational requirements of the Data Analyst role at [ORGANIZATION_NAME]. It is not designed to cover or contain a comprehensive listing of all activities, duties, or responsibilities required of the incumbent. Operational duties may be adjusted, added, or amended with reasonable notice based on organizational priorities and business requirements.

Incumbent Acknowledgement:

I acknowledge that I have received, read, and understood the contents of this job description.

Incumbent Name (Printed)

Incumbent Signature

Date (DD-MMM-YYYY)

Manager Approval:

Manager Name (Printed)

Manager Signature

Date (DD-MMM-YYYY)

What to fill in