Sr. Bi Data Warehouse Developer

Salary: $85,100.00 - $93,500.00 Annually
Location : Denver, CO
Job Type: Professional/Tech Full-time
Remote Employment: Flexible/Hybrid
Job Number: GJA-298750-03272024-NMC
Department: CCCS Information Technology
Division: CCCS Institutional Research/Business Information
Opening Date: 04/01/2024
Closing Date: 4/14/2024 11:59 PM Mountain
Department Contact Information: Nikki CIminojobs@cccs.edu
Description
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, , and flexible work schedules, including hybrid-remote work within the state of Colorado.
Examples of Duties
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.

Required Qualifications

• 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).

Supplemental Information
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.
A career at the Colorado Community College System's administrative office comes with great perks. Whether you are responsible for strategic System leadership or provide high quality administrative and technical support, you will reap a rewarding experience being a part of an enterprise which assists thousands of students to elevate their lives each year. Our System Office culture emphasizes and celebrates professionalism in performance of jobs and diversity in our workforce. Our focus on outcomes rather than tasks is supported with flexible work arrangements, and the expectation that our employees perform best when they are engaged and enjoy a degree of autonomy in how they approach the delivery of quality work product. You will admire the friendly culture of our system office and be inspired by our team environment and dedicated employees.
We offer the following benefits:

• Our employees stay because of the work/life balance they are able to obtain at the System Office. This includes generous leave benefits:
  • Administrator/Professional-Technical (APT) positions earn 15 hours of annual leave and 10 hours of sick leave each month - based on fulltime status.
  • Classified employees earn generous levels of annual and sick leave based on their years of service.
  • CCCS employees receive 11 paid holidays per year, many of which are observed between December 25th through January 1st.
  • CCCS employees have leave available for a variety of additional personal needs such as academic/volunteer activities, bereavement, public health emergencies, and more.

Many positions are eligible for alternate work arrangements that may include flexible schedules and/or working remotely within Colorado.

CCCS offers comprehensive health, dental, and vision plans with considerable employer contributions. We also offer employer-paid life insurance. For a complete overview of our benefits, visit our

CCCS employees are eligible for Federal Public Service Student Loan Forgiveness. For more information, go to the website.

As a CCCS employee, you have an opportunity to become a lifelong-learner and enjoy considerable savings for the college education of you and your dependents through our tuition reimbursement program.

We offer retirement savings through via our defined benefit or defined contribution plans. CCCS employees are also eligible to participate in a robust set of supplemental retirement options such as a 401K, 457, and/or 403b.

All state employees are eligible to participate in , which offers discounts for retailers and services and other benefits resources.

CCCS offers employee assistance services to you and your household members at no cost through the Colorado State Employee Assistance Program (). Available services include counseling, professional coaching, webinars, mediation, financial assistance, and more.