Sr. CTE Programmer Analyst

The Colorado Community College System is hiring a Senior Programmer Analyst to join our Career & Technical Education (CTE) department at the CCCS System Office. We are looking for a skilled problem solver who can research, propose, and implement solutions. If you're looking for a full stack developer opportunity on a small, tightknit team where your work will impact students throughout Colorado, this position may be for you!

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.

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

• 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 Type Script.

• 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…