Sr CTE Programmer Analyst

Colorado Community College System (CCCS); Denver (CO); Ibrido; USD 87.000 - 91.000; Tempo pieno

Vantaggi offerti da questo lavoro

Hybrid-remote option

Travel opportunities (rare)

Descrizione del lavoro

The Colorado Community College System (CCCS) is seeking a Sr CTE Programmer Analyst at the Lowry Campus in Denver to provide technical support and development for the CTE Gateway platform. You will work closely with the CCCS-IT team to analyze, design, develop, document, and test complex functions, modules, and reports supporting state and federal CTE funding.

The role emphasizes collaboration, translating technical information for end users, and implementing Azure-based solutions with a React

Competenze

• Bachelor's degree in technology, computer science, or related field.
• Minimum of two years of software or database development experience, including Microsoft Azure experience.
• Experience with programming languages, including C# and React, JavaScript, and/or TypeScript.

Mansioni

• Plan, design, develop, configure, test, deploy and support structure and content of the CTE web application (C#, React, JavaScript, TypeScript), database, and reports (SQL).
• Construct complex SQL queries and maintain stored procedures, web jobs and functions.
• Troubleshoot issues and apply project management skills on development projects.
• Conduct code reviews and walkthroughs for technical and non-technical audiences.
• Develop unit tests and contribute to test plans with teammates.
• Complete work tickets related to review, troubleshooting, development, and testing of fixes.
• Conduct web accessibility mediation to support compliance with Section 508 and WCAG standards.

Conoscenze

SQL queries

React

C#

Azure

Team collaboration

Agile / Scrum

Problem solving

Documentation

Excel

Communication

Formazione

Bachelor's degree in technology/computer science

Strumenti

Azure DevOps

Jira

Visual Studio

MS SQL Server

Azure SQL

Descrizione del lavoro

Title: Sr CTE Programmer Analyst

Position Type: Professional Tech Full time

College: System Office

Division: Workforce Solutions & Innovation

Department: CCCS CTE

Campus: Lowry Campus

Location: Denver

Salary Range: $86,500 - $90,825

Job Summary

In this position you’ll provide technical support and problem solving for a variety of Career & Technical Education (CTE) Gateway application and technical issues, working closely with the Customer Support Team, other CCCS-IT teams, and other developers. This is a highly collaborative role, and you will need to be able to translate complex technical information for end users. You’ll be responsible for analyzing, designing, developing, documenting, reviewing, and testing complex functions, modules, and programs in order to support the CTE in Colorado database, web application, and data reports.

The Colorado CTE Gateway is the single site in which all Career and Technical Education (CTE) program and contact management and reporting, including for state and federal CTE funding, is housed. This custom-built, cloud-based web application software is owned, developed, and maintained by the CTE Accountability team. It is built on Azure services such as Azure SQL, and Web Services. The API is written in C# and front end is in ReactJS.

Note: All interviews for this position will be hosted in person at our office in Denver, Colorado. Travel reimbursement to the interviews is not available. All work for this role must be completed in the state of Colorado; relocation expenses are not available for this position.

Competencies/KSAs

• Knowledgeable about CTE programs, especially in Colorado and with the Colorado CTE Gateway application preferred but not required.
• Working knowledge of relational database applications such as MS SQL Server, Azure SQL, MySQL, Oracle, etc.
• Practiced in running SQL queries.
• Familiar with React-Redux library.
• Familiar with project management and application/software life cycle; methodologies like Agile scrum and Kanban; and tools like Team Foundation Server, Azure DevOps, Jira, etc.
• Ability to identify user needs, conduct problem analysis, and provide technical solutions.
• Awareness of Model View Controller pattern, Microsoft Entity framework, and design patterns usage.
• Familiar with frontend and backend development of websites and applications.
• Able to understand the importance of following established state and federal statutes and internal policies and business processes.
• Ability to: work independently when given direction, work well in a team environment, and work well in a deadline driven environment, including adjusting to frequent changing work priorities.
• Attention to detail while working timely under mandatory deadlines.
• Strong Excel skills.
• Excellent written and interpersonal communication skills with audiences of varying technical skills.
• Familiar with, or ability to learn, Selenium.
• Awareness of cloud-based infrastructure design and implementation, specifically Azure and/or Dev Ops.
• Moderate skills using IDE tools (i.e. Visual Studio).
• Familiarity with continuous integration/delivery/deployment (CI/CD).
• Practiced in multi-tasking and with task prioritization when given various assignments.

Duties & Responsibilities

• Plan, design, develop, configure, test, deploy and support structure and content of the CTE web application (C #, React, JavaScript, TypeScript), database, and reports (SQL), including both ad hoc and packaged reports.
• Construct complex SQL queries to access and manipulate data, as well as develop and maintain stored procedures, web jobs and functions within the site infrastructure.
• Troubleshoot related issues as they arise and apply project management skills on development projects.
• Conduct code reviews and other walkthroughs for both technical and non-technical audiences.
• Develop and perform unit testing on programs/functions and work with others to contribute to test plans.
• Participate in and complete work tickets related to review, troubleshooting, development, and testing of fixes to bugs or enhancements in the application or infrastructure.
• Construct complex SQL queries to access and manipulate data, as well as develop and maintain stored procedures, Common Table Expressions, web jobs and functions within the site infrastructure.
• Conduct web accessibility mediation of CTE web applications and related duties, such as coaching/training staff, to support compliance with Section 508 and current WCAG standards.

Minimum Qualifications

• Bachelor's degree in technology, computer science, or related field.A combination of relevant education, training, and/or experience may substitute for the degree.
• Minimum of two years of software or database development experience, at least some of which must be experience with Microsoft Azure, such as Webjobs, Cloud Architecture, Functions, Data Factory pipelines, storage, and B2C authentication.
• Experience with programming languages, including C# and React, JavaScript, and/or TypeScript.

College Advertising Details

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 130,000 postsecondary students annually. In addition, we train more than 4,000 Coloradans each year through customized employer training programs and coordinate delivery of career and technical education (CTE) programs to over 165,000 K-12 learners annually. 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.

Additional Information/Benefits

Work Location/Travel Expectations:

• CCCS offices at 9101 E Lowry Blvd., Denver, CO 80230.
• Travel is rare for this position; on occasion there may be opportunities for in-state or out-of-state meetings/conferences.
• Alternative work arrangements, including flexible schedules and hybrid-remote work may be available. All work must be completed in the state of Colorado.

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.

Department contact: Nikki Cimino: [e-mail]

Hiring Pay Rate

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to internal equity and directly applicable experience, education, and training.