Sr. BI Data Warehouse Developer

The Colorado Community College System (CCCS) is hiring a Senior BI Data Warehouse Developer to join our System Office's Business Intelligence department. We're looking for a developer who is also a skilled communicator. If you're looking for an opportunity that asks you to assess business intelligence training needs systemwide and allows you to develop and lead trainings to meet those needs, this role may be for you! CCCS provides generous leave, excellent benefits, and flexible work schedules, including hybrid-remote work within the state of Colorado.The Senior BI Data Warehouse Developer will deploy, populate and manage enterprise data warehouses and data marts. You will design reports and dashboards while working with end-users. You will provide Cognos and Data Warehouse training on an individual and a group level to end-users. The person in this position works independently and functions as an effective team member in a variety of projects related to the Data Warehouse creation, maintenance, and reporting.

• Design, implement, and maintain dashboards to support system-wide strategic initiatives.

• Perform complex data analysis.

• Assist in defining application development project plans, including scoping, scheduling, and implementation.

• Consistently write, translate, and code software programs and applications according to business requirements.

• Conceptualize and develop new reports.

• Create curriculum and lead training sessions on Business Intelligence solutions.

• Train end users to operate new or modified programs.

• Create and maintain video library of training topics in D2L.

• Present and communicate complex data and system information to various groups and individuals in writing and verbally.

• Bachelor's degree in a technology-related field from an accredited college or university. An equivalent combination of education and experience, in addition to the experience required below, may be substituted for the degree.

• Three years of experience in a Business Intelligence/Data Warehouse environment as a reporting system architect and developer, including experience with:

• Cognos Report Studio and Framework Manager.

• Developing reports using Oracle PL/SQL; i.e. writing PL/SQL stored procedures and queries for data analysis.

• Using an ETL tool (Oracle Data Integrator, Informatica).

Attributes that will contribute to success in this position:

• Practiced in using Ellucian products, especially ODS/EDW.

• Higher Education experience preferred but not required.

• Strong analytical and problem solving skills

• Experience analyzing Financial, HR, Student or Higher Education data is preferred but not required.

• Strong knowledge of relational database concepts, triggers and stored procedures.

• Excellent customer service skills, for both internal and external customers.

• Demonstrated ability to diagnose/resolve technical problems independently.

• Ability to:

• Work effectively on concurrent, multiple tasks and projects.

• Coordinate, organize and track tasks effectively and meet project deadlines.

• Keep current on technology by identifying, reading and using technical manuals and other resources.

• Communicate and collaborate effectively with staff of varying technical expertise.

Work Location/Travel Expectations:

• This position is located at CCCS/IT 1059 Alton Way, Denver, CO 80230.

• May require occasional in-state travel to system community colleges or out-of-state travel to conferences.

• Alternative work arrangements, including flexible schedules and remote work may be available. All work must be completed in the state of Colorado.

The Colorado Community College System is the state's largest provider of higher education and workforce training, consisting of 13 colleges and over 35 locations across the state, educating approximately 113,000 students annually. In addition, we train more than 4,000 Coloradans each year through customized employer training programs. Our mission is to provide accessible, responsive learning environments where students can achieve their educational, professional and personal goals in an atmosphere that embraces academic excellence, diversity and innovation. We are an organization that encourages individuals to bring their whole selves to work.

CCCS believes when all human qualities are regarded with dignity and respect and when everyone has access to the individualized support they need, all will have the opportunity to thrive. In all aspects of the employment process, decisions are made based on merit, competence, performance and business need without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, creed, ancestry, national origin, marital status, genetic information, military status, or any other protected status in accordance with applicable law.

Note: per the Colorado Job Application Fairness Act, an applicant may redact information from their resume, cover letter, and/or transcripts that identifies their age, date of birth, or dates of attendance at or graduation from an educational institution. If your position requires us to review an official transcript, without redacting, we will request one as part of our conditional offer process. In order to evaluate work experience against established requirements for positions, we are still requesting dates of service (month and year) for positions in the applicant's work history.