BUSINESS INTELLIGENCE SPEC-10282020-12226

Job InformationState of Tennessee Job InformationOpening Date/Time Wed 10/28/2020 12:00AM Central Time
Closing Date/Time Tue 11/10/2020 11:59PM Central Time
Salary (Monthly) $6,346.00
Salary (Annually) $76,152.00
Job Type Full-Time
City, State Location Nashville, TN
Department Finance and Administration

LOCATION OF (1) POSITION TO BE FILLED: DEPARTMENT OF FINANCE AND ADMINISTRATION, BUSINESS SOLUTIONS DELIVERY DIVISION, DAVIDSON COUNTY

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

Minimum QualificationsEducation and Experience: Graduation from an accredited college or university with a bachelor's degree and five years of professional level experience in business intelligence or data warehousing. Substitution of Specific Associates Degree for the Required Bachelor's Degree: Graduation from an accredited college or university with an associate's degree in computer accounting, computer information systems, computer networking technology, computer technology, web technology or other related field may substitute for the required bachelor's degree. Substitution of Experience for the Specific Associate's Degree: Professional level experience in any one of the following areas may substitute for the required specific associate's degree on a year-for-year basis to a maximum of two years: (1) business intelligence; or (2) data warehousing; (one year of experience is equivalent to 45 undergraduate quarter hours). Substitution of Specific Technical Diploma or Certification and Experience for the Specific Associate's Degree: Successful completion of a technical program resulting in the attainment of a technical diploma or professional certification in the Business Intelligence field plus five additional years of professional level experience in (1) business intelligence; or (2) data warehousing may substitute for the associate's degree. Other RequirementsNecessary Special Qualifications: None.Examination Method: Education and Experience,100%, for Preferred Service positions. Job OverviewSummary: Under general supervision, is responsible for professional business intelligence work of considerable difficulty and lead work of average difficulty involving leading a small group of subordinate business intelligence specialists during the design, development, and implementation of business intelligence technology solutions; and performs related work as required.
Distinguishing Features: An employee in this class leads or supervises a team or independently works on the design, development and maintenance of components of a business intelligence technology solution, leads a team or independently designs and implements business intelligence technology best practices and guidelines, coordinates multiple projects amongst other team members while optimizing resource utilization and ensures proper controls are implemented to promote system stability. This class differs from that of Advanced Business Intelligence Specialist in that an incumbent of the latter independently designs, develops and modifies components of a business intelligence technology solution following defined standards and procedures under general supervision.
Work ActivitiesAnalyzing Data or Information:

• Analyzes source systems and develops a logical/business data model to determine the reporting capability of available data.
• Understands pertinent data models and business processes in order to fulfill customer requests for maintenance, support, and enhancements.
• Integrates multiple disparate processes to address short and long-term business needs.
• Understands, implements, and maintains the security model for business intelligence solutions to prevent unauthorized access.

Processing Information:

• Validates and tests solutions to ensure the business requirements are met.
• Researches, analyzes, and reports on information from a variety of sources.
• Validates report results to ensure customer requirements are met.

Developing Objectives and Strategies:

• Understands and assists in defining the Business Intelligence and Reporting Architecture and its integration into the overall Technology Service.
• Helps establish technical vision.
• Designs and implements technology best practices, guidelines, and repeatable processes.
• Develops and maintains best practices approaches to development, testing and documentation of business intelligence and reporting processes.

Getting Information:

• Conducts requirements gathering sessions with business stakeholders to define, formulate and prioritize Business Intelligence requirements.
• Gathers and identifies the information available from various source systems.

Identifying Objects, Actions, and Events:

• Participates in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning.

Scheduling Work and Activities:

• Coordinates multiple projects and tasks amongst team members to optimize resource utilization.

Making Decisions and Solving Problems:

• Analyzes and troubleshoots processes to resolve issues.
• Troubleshoots, diagnoses, and resolves problems/issues within the Business Intelligence solution environment.
• Conducts investigations into data anomalies both proactively and as identified by users.
• Analyzes tradeoffs between usability and performance needs.

Judging the Qualities of Things, Services, or People:

• Evaluates and recommends tools for Business Intelligence to keep the State strategically positioned to meet management objectives.

Establishing and Maintaining Interpersonal Relationships:

• Collaborates with clients to understand technical requirements stemming from the business requirements of a particular request.

Interacting With Computers:

• Develops a physical data model and identifies the facts, dimensions and key values.
• Implements Extract Transform Load (ETL) solutions using business intelligence data ETL tools.
• Deploys solutions utilizing Business Intelligence concepts; such as, data mining, predictive analytics and trend analysis to provide management with insight into their business.
• Tunes Extract Transform Load (ETL) processes and reporting queries to maximize performance.
• Develops queries for validation of work outputs and source system confirmation.
• Codes solutions using appropriate computer programming language.
• Develops and maintains complex data storage structures needed to support data warehouse functions to ensure data is maintained in consistent formats.
• Generates standard and custom reports summarizing business data for review by executives, managers, clients, and other stakeholders.
• Develops an Extract Transform Load (ETL) schedule that recognizes dependencies, pre-processing tasks, post-processing tasks, and notifications for data administration.
• Develops Business Intelligence reporting components within existing business intelligence and reporting platforms in support of strategic initiatives.
• Develops reports based on customer requirements.
• Designs reports based on customer requirements.
• Implements reporting solutions using business intelligence data presentation tools.
• Integrates Business Intelligence solutions with existing office productivity suites.
• Ensures proper configuration management and change controls are implemented to promote system stability and to provide an audit trail of modifications.

Coordinating the Work and Activities of Others:

• Facilitates requirements gathering sessions using expert listening skills and develops unique simple solutions to meet the immediate and long-term needs of business customers.
• Leads people and teams toward accomplishment of project goals.

Organizing, Planning, and Prioritizing Work:

• Develops project work plans and estimates work plan tasks.

Updating and Using Relevant Knowledge:

• Understands business intelligence concepts and methodologies.

Documenting/Recording Information:

• Documents use cases to ensure the Business Intelligence solution meets the business requirements.
• Documents business flows for new and existing systems ensuring long-term maintainability.

Resolving Conflicts and Negotiating with Others:

• Resolves competing priorities between business areas.

Provide Consultation and Advice to Others:

• Provides guidance and consultation to users to increase their understanding of the Business Intelligence tool's capabilities in order to better meet their business needs.

Coaching and Developing Others:

• Acts as a mentor/teacher to other development resources in the area of business intelligence and reporting development, including usage techniques and best practices.
• Provides technical assistance and cross-training to other team members.
• Provides training and assistance to business users in the generation of ad hoc reports.

Evaluating Information to Determine Compliance with Standards:

• Follows proper configuration management and change controls to promote system stability and to provide an audit trail of modifications.
• Evaluates requests from problem management tracking system.

Monitor Processes, Materials, or Surroundings:

• Monitors the data warehouse and business systems performance and integrity.
• Monitors the reporting component of business intelligence systems to identify performance issues and process failures.
• Monitors and tracks usage of business intelligence systems.

Communicating with Persons Outside Organization:

• Acts as a liaison between technical and non-technical teams.

Communicating with Supervisors, Peers, or Subordinates:

• Provides timely status reporting to keep management informed of project progress.

Competencies (KSA'S)Competencies:

• Intellectual Horsepower
• Customer Focus
• Decision Quality
• Problem Solving
• Process Management
• Business Acumen
• Functional Technical Competency
• Comfort around Higher Management
• Developing Direct Reports and Others
• Written Communication

Knowledge:

• Knowledge of Business Intelligence Reporting Tools
• Knowledge of Data Analysis
• Knowledge of Business Intelligence Concepts
• Knowledge of Extract Transform and Load (ETL) Solution Implementation
• Knowledge of Dashboard Design
• Knowledge of Performance Tuning
• Knowledge of Query Languages
• Knowledge of Online Analytical Processing (OLAP) Data Modeling
• Knowledge of Scorecard Design
• Knowledge of Project Management Methodologies
• Knowledge of Relational Database Concepts
• Knowledge of Schedule Management
• Knowledge of Key Performance Indicators (KPI)
• Knowledge of Programming Languages
• Knowledge of Office Automation Software
• Knowledge of User Interface and Experience Design
• Knowledge of Predictive Analytics
• Knowledge of Report Delivery Methods
• Knowledge of Data Mining
• Knowledge of Cubes

Skills:

• Critical Thinking
• Complex Problem Solving
• Reading Comprehension
• Systems Analysis
• Judgment and Decision Making
• Troubleshooting
• Writing
• Active Listening
• Speaking
• Programming
• Negotiation
• Time management

Abilities:

• Written Comprehension
• Written Expression
• Oral Comprehension
• Oral Expression
• Mathematical Reasoning
• Perceptual Speed
• Visualization
• Information Ordering
• Speed of Closure
• Problem Sensitivity
• Deductive Reasoning
• Inductive Reasoning

Tools and Equipment Used

• Personal Computer
• Telephone
• Fax Machine
• Printer
• Copy Machine
• Scanner
• Mobile Devices
• Projector/Audio-Video Equipment