Sr. CTE Programmer Analyst

State of Colorado; Denver (CO); Hybrid; USD 85,000 - 115,000; Full time

Job summary

The Colorado Community College System is seeking a Senior Programmer Analyst to join the Career & Technical Education (CTE) department in the CCCS System Office. You will work on the CTE Gateway application, using C#, React, JavaScript/TypeScript, and SQL to design, develop, test, and optimize data reports and web functionality.

This highly collaborative position requires translating complex technical details for end users and coordinating with the Customer Support Team and IT colleagues.

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, including Microsoft Azure (Webjobs, Cloud Architecture, Functions, Data Factory pipelines, storage, and B2C authentication).
• Experience with programming languages including C# and React, JavaScript, and/or TypeScript.

Responsibilities

• Plan, design, develop, configure, test, deploy and support the CTE web application (C#, React, JavaScript, TypeScript), database, and reports (SQL).
• Construct complex SQL queries to access and manipulate data, and develop/maintain stored procedures, web jobs and functions.
• Troubleshoot issues, conduct code reviews, and participate in testing and ticket work.
• Develop unit tests and collaborate on test plans.
• Contribute to CI/CD processes and infrastructure updates.
• Ensure accessibility and compliance with Section 508 and WCAG standards.

Skills

C#

React

JavaScript/TypeScript

SQL queries

Azure cloud services

CI/CD

Problem solving

Communication

Education

Bachelor's degree in technology or computer science

Tools

Azure DevOps

Jira

Team Foundation Server

Visual Studio

WebJobs

Data Factory

Job description

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.

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.

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

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.

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.

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.