This position reports to the Assistant Director, Business Intelligence. The position will rapidly design, deploy, populate and manage enterprise data warehouses and data marts -- skills critical to the growing use of data warehousing. The position designs reports and dashboards working with end-users. The position works independently and also functions as an effective team member in a variety of projects related to the Data Warehouse creation and maintenance. The position may take on the role of support lead or analyst and focus on responding to customer issues.
This position works at the CCCS Lowry Campus located at 1059 Alton Way, Denver, CO 80230
How to apply: cccs.hiretouch.com
Note: This position will remain open until a suitable candidate pool has been obtained. Full consideration will be given to qualified candidates who apply by March 10, 2019
Minimum Educational Requirements and Substitution (if appropriate)
Bachelor’s degree in an appropriate field from an accredited college or University.
Relevant education and experience in the appropriate technical areas may substitute year for year for the required degree.
Minimum Experience Requirements
2 - 3 years of experience with development of reports using Oracle PL/SQL; i.e. writing PL/SQL stored procedures and queries for data analysis.
2 - 3 years of experience with a Report Writing tool (Cognos, Crystal, Business Objects, etc.), including Dashboarding.
2 - 3 years of experience using an ETL tool (Informatica, Oracle Warehouse Builder).
2 - 3 years of experience as a reporting system architect and developer.
2 - 3 years of experience in Business Intelligence/Data Warehouse, which must include demonstrated proficiency in using appropriate tools:
Strong knowledge of relational database concepts, triggers and stored procedures.
Significant demonstrable experience working with dimensional modeling skills (normalized and multidimensional) including understanding facts and dimensions, star schemas, and OLAP tools and techniques.
Hands-on experience developing test cases and test plans.
Internal Number: 299700
About Colorado Community College System
A career at the Colorado Community College System’s administrative office comes with great perks. As you help the operations of our 13 colleges continuously improve, you will reap a rewarding experience with being a part of an enterprise which assists thousands of students to elevate their lives each year. We are confident – when you consider all the tangibles and intangibles – you will want to make the next, and final, stop of your career the Colorado Community College System.
You will admire the friendly culture of our system office and be inspired by our team environment and dedicated employees. Additionally, we offer:
Generous annual and sick leave benefits (15 hours of annual leave and 10 hours of sick leave accrued each month – based on full time status); our employees stay because of the work/life balance they are able to obtain here.
Attractive health, dental, vision, life, and flexible savings options; we will also help you build your retirement savings via our defined benefit or defined contribution plans.
An opportunity to become a lifelong-learner and enjoy considerable savings for the college education of your dependents through our tuition reimbursement ...program.
For a complete overview of our benefits, visit the benefits section of our website (https://resources.cccs.edu/employee-resources/employee-benefits/).