State of Tennessee logo
State of Tennessee

196 open roles

Business Intelligence Specialist-Advanced- 11072026-82650

$68k to $89k

Davidson CountyFull-timePosted Nov 7, 2026

Job description

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).

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.

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.

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: 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

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

Description copied from State of Tennessee's careers page. Read the full posting before you apply.

More jobs at State of Tennessee

See all openings at State of Tennessee