] Office of Human Resources - Montgomery County Public Schools

OFFICE OF HUMAN RESOURCES AND DEVELOPMENT → CLASSIFICATION → SENIOR BUSINESS INTELLIGENCE DEVELOPER

Sorted by job title: A - C | D - H | I - Q | R - Z

Senior Business Intelligence Developer

MONTGOMERY COUNTY PUBLIC SCHOOLS CLASS DESCRIPTION
OFFICIAL TITLE: Database Administrator III CODE: 5205 SQ/OQ: Optimal Qualified
WORKING TITLE: Senior Business Intelligence Developer GRADE: 27 MONTHS: 12
SUMMARY DESCRIPTION OF CLASSIFICATION: Under general supervision, develops, implements, maintains relational and multi-dimensional databases and supports Business Intelligence solutions. Participates in developing data models to define enterprise data architecture, administer change controls, and monitor production data loads. Works closely with project management, applications development, System and database administration team, and data warehouse development team. Develops policies and procedures to ensure the security and integrity of the school district's enterprise databases. Develops data transfer programs and processes between disparate systems. Responsible for developing business intelligence dashboards and reports. Troubleshoots and resolves database performance, database capacity, tuning, and other distributed data issues. Works with system administrators for the configuration and selection of database server equipment.
MINIMUM QUALIFICATION STANDARDS
KNOWLEDGE, SKILLS, AND ABILITIES: Highly skilled in relational data modeling, database design, structured programming, object design, and data integrity and validation procedures. Knowledge of relational database theory and techniques, dimensional modeling, and data warehouse solution/design concepts. 5 or more years of experience in Extraction, Transformation and Loading (ETL) development using Microsoft SSIS or similar software. Hands-on experience in reports development using Microsoft SSRS or similar software. Knowledge of SQL development tools, JavaScript, Python, and Erwin data modeling tool. Strong quantitative, analytical, communication and interpersonal skills, and the ability to work in a team-oriented environment. Solid problem solving, negotiations, and organizational skills required. Ability to acquire knowledge of and meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS).
EDUCATION, TRAINING, AND EXPERIENCE: Bachelor's degree required. Master's degree preferred. College course work in data processing, and specialized training in relational database management systems, including data warehouse development, database administration, performance tuning, troubleshooting, and programming in a networking environment. Requires five years of experience with SQL and PL/SQL in SQL Server 2012 or above. Experience in Oracle 10g or above is a plus. Proficient in all stages of Business Intelligence work which includes, but not limited to, developing dimensional data models, writing SQL queries, and building data transfer programs, reports and dashboards using Microsoft technology Experience with Analytics and OLAP cube development specifically with Microsoft SSAS and MDX development desirable. Other combinations of applicable education, training and experience that provide the knowledge, abilities, and skills necessary to perform effectively in the position will be considered.
CERTIFICATE AND LICENSE REQUIREMENTS: DBA/Business Intelligence certification preferred..
PHYSICAL DEMANDS: (Special requirements such as lifting heavy objects and frequent climbing.) Must operate PC's computer workstation for extended periods, and occasionally lift and move servers and other equipment.
SPECIAL REQUIREMENTS: (Frequent overtime or night work required, etc.) Some overtime, weekend, and evening work required on demand.
OVERTIME ELIGIBLE: No

EXAMPLES OF DUTIES AND RESPONSIBILITIES:

Note: (Incumbents may perform any combination of the essential functions shown below. This position description is not intended to be an exhaustive list of all duties, knowledge, or ability associated with this classification, but is intended to accurately reflect the core job elements.)

Reviews and analyzes database designs, entity relationships and proposed SQL statements.

Assists with database consolidation.

Designs and modifies database architecture and schemas as needed.

Monitors database systems; optimizes database design, performance tuning, table spaces, files, etc.

Participates in backup/recovery strategy for the enterprise databases, and in disaster recovery planning.

Creates technical documents for Oracle or SQL database contents, concepts, and mapping between databases.

Prepares test strategies, scripts, and documentation.

Evaluates and maintains DBMS software and related software products; setting up and maintaining data structures to support product performance and querying activities; and performing problem resolution and support activities.



Determines preferred options and priorities of acceptable criteria, set-up and maintain data structures, and convert logical designs to appropriate physical database structures.

Maintains system security and controls and ensures appropriate processes for user access are followed.

Works with system administrators to develop specifications for new and existing database server hardware.

Provides second-level support for developers and users on questions and problems related to database issues and software development tools.

Proactively resolves problems to ensure the uninterrupted access to enterprise database systems to maximize performance and reliability.

Provides technical leadership and mentoring to junior positions.

Performs related duties consistent with the scope and intent of the position.

Class Established: 2/2001
Date(s) Revised: 7/2001, 2/2008, 7/2017, 4/2022
Last Reviewed:

This description may be changed at any time.