BUSINESS INTELLIGENCE SPECIALIST-INTERMEDIATE - 12232025-73800

The State of Tennessee is seeking a Business Intelligence Specialist - Intermediate to support the design, development, and maintenance of BI solutions. This role involves analyzing source data, building reports and dashboards, and troubleshooting BI-related issues to facilitate data-driven decision-making.

Responsibilities

• Develop and maintain BI reports, queries, and dashboards based on customer requirements
• Translate user requirements into queries, visualizations, and reusable dashboard templates (Power BI, Tableau, or similar)
• Assist in analyzing source systems and building logical data models
• Implement and tune Extract, Transform, Load (ETL) processes and validate data accuracy, troubleshoot data-load errors and performance bottlenecks
• Perform data validation and testing to ensure business needs are met
• Troubleshoot reporting and data anomalies, escalating issues when necessary
• Document business processes, use cases, and technical solutions for long-term maintainability. Maintain data dictionaries, lineage diagrams, and ¿how-to¿ guides to support knowledge transfer and audit readiness
• Support data integrity, system performance monitoring, and adherence to configuration standards
• Collaborate with stakeholders to clarify reporting needs and enhance BI functionality

Skills

• Bachelor's degree and one year of experience in business intelligence, data warehousing, programming, or business systems analysis
• An associate degree in a related field may substitute for the bachelor's
• Relevant experience may substitute for education up to two years
• Develop and maintain BI reports, queries, and dashboards based on customer requirements
• Translate user requirements into queries, visualizations, and reusable dashboard templates (Power BI, Tableau, or similar)
• Assist in analyzing source systems and building logical data models
• Implement and tune Extract, Transform, Load (ETL) processes and validate data accuracy, troubleshoot data-load errors and performance bottlenecks
• Perform data validation and testing to ensure business needs are met
• Troubleshoot reporting and data anomalies, escalating issues when necessary
• Document business processes, use cases, and technical solutions for long-term maintainability
• Maintain data dictionaries, lineage diagrams, and 'how-to' guides to support knowledge transfer and audit readiness
• Support data integrity, system performance monitoring, and adherence to configuration standards
• Collaborate with stakeholders to clarify reporting needs and enhance BI functionality
• Customer Focus
• Nimble Learning
• Tech Savvy
• Business Insight
• Manages Complexity
• Active Learning and Listening
• Troubleshooting
• Critical Thinking
• Complex Problem Solving
• Writing
• Inductive Reasoning
• Mathematical Reasoning
• Visualization
• Written Comprehension
• Deductive Reasoning
• BI platforms (e.g., Power BI, Tableau)
• ETL tools
• SQL
• AutoCAD
• OLAP

Company Overview