Sr CTE Programmer Analyst

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

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.

• 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 Dev Ops, 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.

• Plan, design, develop, configure, test, deploy and support structure and content of the CTE web application (C #, React, JavaScript, Type Script), 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…