Home Careers Job Descriptions Business Intelligence Developer
|Business Intelligence Developer Job Description|
Job Series: Business Intelligence Developer
GENERAL STATEMENT OF DUTIES
This position performs programming assignments at the strategic operating level for the Colorado Judicial Department. Responsible for system design, implementation, and administration of all components that make up the IBM Cognos Business Intelligence infrastructure to include designing, developing, and training in the areas of Report Studio, Query Studio, Analysis Studio, and Metrics Studio. Strategically design and implement data warehouse concepts such as data marts and data stores using IBM DataStage, while utilizing IBM Cognos to produce Business Intelligence solutions for Judicial and other State agency consumers.
Positions in this classification are distinguished from other positions by leading the Judicial Departments Business Intelligence and Data Warehousing effort. Responsibilities include advanced programming skills in the areas of SQL and stored procedures, data extraction, transformation, and loading, building logical and dimensional models, formulating complex queries, and developing complex reports and cubes using Cognos. This positions primary duty will be to lead the Department’s data warehousing initiatives by designing and building data mart solutions designed to meet the Business Intelligence needs of Judicial and other State agency customers. May directly supervise up to 2.99 staff. This position reports directly to the Senior JBITS Manager.
ESSENTIAL FUNCTIONS OF THE POSITION
Plans, directs and coordinates activities for Business Intelligence and Data Warehouse contributors, interns and/or volunteers. Duties may include scheduling and assigning of work, training in all facets of work, and quality control. May conduct performance reviews and provide input into and participate in discipline, dismissal, and hiring of volunteers and interns.
To perform this job successfully, an individual must be able to perform each of the above essential functions satisfactorily. The requirements listed below are representative of the knowledge, skill, ability, physical and environmental conditions required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION and EXPERIENCE
Candidate will have graduated from an accredited college or university with a Bachelor degree with two years experience in SQL and DB2 relational database design. Knowledge of the court system is highly desired.
Candidate will have a minimum of six years experience in SQL and DB2 relational database design. Knowledge of the court system is highly desired.
PREFERRED KNOWLEDGE and EXPERIENCE
While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to sit; use hands and fingers to perform repetitive motions; and reach with hands and arms. The employee is occasionally required to stand; walk; climb or balance; and stoop, kneel, crouch, or crawl. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus.
While performing the duties of this job, the employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is usually moderate. Occasionally handles emergency or crisis situations; frequently subject to interruptions, and multiple calls and inquiries.