BUSINESS INTELLIGENCE SPECIALIST-ADVANCED- 11072026-82650

Job Information

State of Tennessee Job Information

Opening Date/Time 11/07/2026 12:00AM Central Time

Closing Date/Time 11/20/2026 11:59PM Central Time

Salary (Monthly) $5,703.00- $7,399.00

Salary (Annually) $68,436.00- $88,788.00

Job Type Full-Time

City, State Location Nashville, TN

Department Finance and Administration

LOCATION OF (2) POSITION(S) TO BE FILLED: DEPARTMENT OF FINANCE AND ADMINISTRATION, DAVIDSON COUNTY

The Department of Finance and Administration will not sponsor work visas.

This position requires a criminal background check and CJIS Fingerprints. Therefore, you may be required to provide information about your criminal history in order to be considered for this position.

This position is designed as Hybrid (In office and Remote).

Qualifications

Education and Experience: Bachelor's degree and three years of experience in business intelligence or data warehousing. An associate degree in a related field may substitute for the bachelor's. Certifications and additional experience may substitute for education requirements.

Overview

The Business Intelligence Specialist supports the Tennessee Department of Mental Health and Substance Abuse Services within the Strategic Technology Solutions organization. This position develops, tests, maintains, and supports Crystal Reports and related reporting services for MyAvatar EHR used by the Regional Mental Health Institutes and agency stakeholders.

The position works with application owners, BI team members, QA reviewers, subject-matter experts, and end users to translate business needs into accurate, secure, maintainable, performant, and user-friendly reporting solutions.

Responsibilities

• Manage assigned reporting requests from requirements gathering and solution design through development, testing, deployment, and ongoing support.
• Gather, clarify, and document business needs, data requirements, acceptance criteria, assumptions, and expected outcomes.
• Develop and maintain reports using Crystal Reports, SQL, and related reporting technologies.
• Write and troubleshoot queries involving relational databases, tables, views, joins, filters, parameters, calculations, functions, and stored procedures.
• Perform thorough technical QA, user acceptance testing, regression testing, deployment validation, and post-implementation review.
• Validate report results against source-system records, application workflows, stakeholder expectations, and established test cases.
• Investigate data anomalies, missing or duplicate results, unexpected output, performance concerns, and other reporting issues through root-cause analysis.
• Ensure reporting solutions meet standards for accuracy, usability, performance, security, documentation, and maintainability.
• Communicate requirements, status, risks, decisions, dependencies, and recommendations clearly to technical and nontechnical stakeholders.
• Document report designs, data definitions, testing results, decisions, changes, processes, and support information.
• Collaborate with BI team members through peer review, technical assistance, knowledge sharing, and cross-training.
• Manage competing priorities, concurrent requests, projects, incidents, deadlines, and stakeholder follow-up while protecting confidential information.

Competencies (KSA's)

Competencies:

• Customer Focus
• Decision Quality
• Tech Savvy
• Business Insight
• Manages Complexity

Knowledges:

• N/A

Skills:

• Systems Analysis
• Troubleshooting
• Critical Thinking
• Complex Problem Solving
• Reading Comprehension

Abilities:

• Inductive Reasoning
• Mathematical Reasoning
• Information Ordering
• Written Comprehension
• Deductive Reasoning

Tools & Equipment

• BI platforms (e.g., Power BI, Tableau)
• ETL tools
• SQL
• Data modeling software
• OLAP