Jobs

BUSINESS INTELLIGENCE SPEC-ADV

Class Title: BUSINESS INTELLIGENCE SPEC-ADV
Bargaining Unit: Use for all Job Titles
Class Code: 075605
Education and Experience: Graduation from an accredited college or university with a bachelor’s degree and three 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 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 three additional years of professional level experience in: (1) business intelligence; or (2) data warehousing may substitute for the associate’s degree.

Other Requirements:

Necessary Special Qualifications: None.
 
Examination Method: Education and Experience,100%, for Preferred Service positions. For Executive Service positions, Minimum Qualifications, Necessary Special Qualifications, and Examination Method are determined by the appointing authority.

Job Overview:

Summary: Under general supervision, is responsible for professional business intelligence work of considerable difficulty involving design, development, and maintenance of business intelligence technology solutions; and performs related work as required.
Distinguishing Features: An employee in this class independently designs, develops and modifies components of a business intelligence technology solution following defined standards and procedures. This class differs from Business Intelligence Specialist-Intermediate in that an incumbent of the latter performs the administrative and technical duties related to the design, development and maintenance of business intelligence technology solutions under immediate supervision.  This class differs from that of Business Intelligence Specialist-Lead in that an incumbent of the latter leads or supervises staff or independently works on the design and implementation of business intelligence technology best practices, coordinates multiple projects while optimizing resource utilization and ensures proper controls are implemented to promote system stability.

Work Activities:

Developing Objectives and Strategies:
  1. Understands and assists in defining the Business Intelligence and Reporting Architecture and its integration into the overall Technology Service.

Coordinating the Work and Activities of Others:

  1. Facilitates requirements gathering sessions using expert listening skills and develops unique simple solutions to meet the immediate and long-term needs of business customers.

Processing Information:

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

Analyzing Data or Information:

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

Making Decisions and Solving Problems:

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

Interacting With Computers:

  1. Tunes Extract Transform Load (ETL) processes and reporting queries to maximize performance.
  2. Develops a physical data model and identifies facts, dimensions and key values.
  3. Deploys solutions utilizing Business Intelligence concepts such as: data mining, predictive analytics and trend analysis to provide management with insight into their business.
  4. Implements Extract Transform Load (ETL) solutions using business intelligence data ETL tools.
  5. Generate standard or custom reports summarizing business data for review by executives, managers, clients, and other stakeholders.
  6. Develops queries for validation of work outputs, and source system confirmation.
  7. Codes solutions using appropriate computer programming language.
  8. Develops and Extract Transform Load (ETL) schedule that recognizes dependencies, pre-processing tasks, post-processing tasks and notifications for data administration.
  9. Develops reports based on customer requirements.
  10. Develops and maintains complex data storage structures needed to support data warehouse functions to ensure data is maintained in consistent formats.
  11. Designs reports based on customer requirements.
  12. Integrates Business Intelligence solutions with existing office productivity suites.
  13. Develops Business Intelligence reporting components within existing business intelligence and reporting platforms in support of strategic initiatives.
  14. Implements reporting solutions using business intelligence data presentation tools.

Identifying Objects, Actions, and Events:

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

Estimating the Quantifiable Characteristics of Products, Events, or Information:

  1. Estimates work plan tasks.

Getting Information:

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

Updating and Using Relevant Knowledge:

  1. Understands business intelligence concepts and methodologies.

Establishing and Maintaining Interpersonal Relationships:

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

Provide Consultation and Advice to Others:

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

Communicating with Persons Outside Organization:

  1. Acts as liaison between technical and non-technical teams.

Evaluating Information to Determine Compliance with Standards:

  1. Follows proper configuration management and change controls to promote system stability and to provide an audit trail of modifications.

Documenting/Recording Information:

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

Coaching and Developing Others:

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

Monitor Processes, Materials, or Surroundings:

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

Competencies (KSA’s):

Competencies: 
  1. Intellectual Horsepower
  2. Functional/Technical Competency
  3. Problem Solving
  4. Customer Focus
  5. Business Acumen
  6. Decision Quality
  7. Learning on the Fly
  8. Technical Learning
  9. Process Management
  10. Written Communication
  11. Perseverance

Knowledge:

  1. Knowledge of Business Intelligence Reporting Tools
  2. Knowledge of Data Analysis
  3. Knowledge of Business Intelligence Concepts
  4. Knowledge of Query Languages
  5. Knowledge of Data Modeling Concepts
  6. Knowledge of Dashboard Development
  7. Knowledge of Scorecard Development
  8. Knowledge of Extract Transform and Load (ETL) Development
  9. Knowledge of Office Automation Software
  10. Knowledge of Schedule Maintenance
  11. Knowledge of Programming Languages

Skills:

  1. Critical Thinking
  2. Complex Problem Solving
  3. Troubleshooting
  4. Reading Comprehension
  5. Systems Analysis
  6. Writing
  7. Programming
  8. Active Listening
  9. Judgment and Decision Making
  10. Speaking
  11. Negotiation
  12. Time management

Abilities:

  1. Mathematical Reasoning
  2. Written Comprehension
  3. Information Ordering
  4. Oral Comprehension
  5. Deductive Reasoning
  6. Inductive Reasoning
  7. Oral Expression
  8. Written Expression
  9. Perceptual Speed
  10. Visualization
  11. Problem Sensitivity
  12. Speed of Closure

Tools and Equipment Used:

  1. Personal Computer
  2. Telephone
  3. Fax Machine
  4. Printer
  5. Copy Machine
  6. Scanner
  7. Mobile Devices
  8. Projector/Audio-Video Equipment

 

Back to top button