196 open roles
Business Intelligence Specialist-Advanced- 11072026-82650
$68k to $89k
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
Welcome Center Regional Manager - 82458
State of Tennessee· Multiple· $55k – $65kDcs Case Manager 4 - 11092026-82495
State of Tennessee· Montgomery County· $62k – $93kHR Generalist 2 - 11092026-82652
State of Tennessee· Davidson County· $62kTalent Management Program Specialist - 11092026-82702
State of Tennessee· Davidson County· $55kAuditor 3 - 11062026-82576
State of Tennessee· Davidson County· $55k