POSITION OBJECTIVE
Under limited supervision, analyze and/or create customer and technical requirements. Design, develop, implement, and test high quality and robust applications, with a focus on databases and data-driven applications. This can include packaged application customizations, custom application development as well as multi-systems integration. May serve as a technical lead on projects, provide guidance to other developers, and contribute to the establishment and maintenance of database and application development standards.
ESSENTIAL FUNCTIONS
-
Design, develop, and support multi-user applications used by the assigned school/business units and/or university. Analyze functional and technical requirements and translate them into reliable, maintainable solutions. Ensure applications address usability, accessibility, security, scalability, and performance requirements. Create test plans, data, procedures, and scripts. Test and debug databases and applications in conjunction with business analyst and customers. Troubleshoot and resolve complex application issues. Maintain and enhance existing systems through refactoring, performance tuning, and defect remediation. May lead system integration projects or coordinate and integrate assigned work with other team members. Ensure databases and applications comply with IT security standards and division policies. Document application designs, configurations, and code changes according to established standards. (40%)
-
Design and develop programs to extract, translate, and load data. Frequent use of SQL SSIS packages and APIs to transfer data between systems. Create plans to test and verify data exchange. Analyze data requirements, identify data sources, data flow, and data relationships; Design and develop programs to address requirements for data conversions. Test and debug applications in conjunction with business analysts and customers and develop programs for automatic correction of erroneous data. Use honesty and integrity to keep university data confidential. (25%)
-
Analyze data, processes, and system interactions; identifies alternatives for establishing systems and data interfaces and converting legacy systems to new technologies. Write system requirements and/or specification documents. Assist with training, documentation, and knowledge transfer as needed. (10%)
-
Promote adherence to established programming standards, SDLC practices, and software quality guidelines. Contribute to the evaluation and improvement of development tools, frameworks, and deployment practices. Assist in coordinating development activities and resolving cross-system or cross-team dependencies. (10%)
-
Provide technical support for software applications including analyzing, troubleshooting, and resolving complex problems. Provide on-call and remote support as needed. (10%)
NONESSENTIAL FUNCTIONS
Perform other duties as assigned. (5%)
CONTACTS
Department: Frequent contact with UTech staff for communication with application developers and business analysts for the purpose of information exchange and to share strategies for problem resolution.
University: Regular contact with school and university stakeholders to collaboratively meet their information requirements and computing needs including general communication, gathering, and analyzing requirements, providing support and training.
External: Occasional (as needed) contact vendors for the purpose of evaluating and selecting solutions, implementation, integration, and troubleshooting.
Students: Occasional contact with students for the purpose of troubleshooting, technical support, and question resolution.
SUPERVISORY RESPONSIBILITIES
May supervise work of project team members. Provide mentoring for application developers. May ensure others comply with established standards.
QUALIFICATIONS
Associate's degree in computer science, information technology, or related field and at least 7 years of experience -OR- Bachelor's degree in computer science, information technology, or related field and at least 5 to 7 years of progressive experience.
REQUIRED SKILLS
-
In depth knowledge of database and application design and development principles, including the design, development, testing, deployment, and maintenance of web-based, service-oriented, and data-driven applications.
-
Proficiency with server-side and back-end application development, including object-oriented programming, application frameworks, and service-based architecture.
-
Working knowledge of modern client-side technologies, including JavaScript, HTML, and CSS, sufficient to develop, integrate, and support user-facing components.
-
Experience designing and developing web-based applications using C#, the .NET platform (ASP.NET, ASP.NET Core), and integrating application logic with database and service layers.
-
Proficiency with common programming tools and frameworks, including RESTful APIs, version control systems (e.g., Git), IDEs, application state management solutions, testing frameworks, logging and diagnostics utilities, and CI/CD practices.
-
Strong working knowledge of the Software Development Life Cycle (SDLC), including requirements analysis, design, development, testing, deployment, maintenance, and operational support.
-
Strong knowledge of relational database theory and design, including normalization, indexing strategies, constraints, data integrity, and performance considerations.
-
Experience with Microsoft SQL Server, including database development and administration tasks such as schema design, query development and optimization, security configuration, backup and recovery, monitoring, and routine maintenance, using standard SQL Server tools.
-
Experience integrating applications with database systems, including transaction management, error handling, and data validation across application and database layers.
-
Strong knowledge of systems analysis principles and methods, including business process modeling and entity relationship analysis.
-
Demonstrated ability to analyze information system needs from non-technical descriptions and translate them into effective application and database solutions. Ability to evaluate existing systems and integrate new technologies in a cost-effective, efficient, and transparent manner. Require creativity and adaptability.
-
Strong knowledge of systems design principles, methodologies, and tools, including those applicable to web-based, multi-tier, and data-driven application environments.
-
Experience with object-oriented development, entity framework technologies, and client/server architectures, including understanding of how application frameworks interact with database platforms.
-
Experience with data reporting and analytics, including report generation and data extraction. Experience with Telerik or similar reporting tools is preferred.
-
Working knowledge of project management methods, tools, and techniques, including task estimation, scheduling, risk identification, and coordination of development and database activities.
-
Ability to independently manage and resolve complex technical issues, including application defects, data issues, and database performance problems. Ability to work effectively under pressure and manage competing priorities.
-
Strong business communication skills, including active listening, responsiveness to verbal and non-verbal cues, and the ability to clearly communicate technical and data-related concepts to non-technical audiences.
-
Demonstrated problem-solving and analytical skills, including the ability to break complex application and data problems into component parts, identify root causes, evaluate alternatives, and implement effective solutions.
-
Ability to work effectively as part of a team, serving as both a contributor and a technical lead, and collaborating across application development, database, and infrastructure functions.
-
Ability to coordinate and influence the work of others where there may be no direct supervisory authority, including developers, analysts, and technical partners.
-
Ability to build and maintain effective working relationships across departments and organizational levels to support institutional goals. Ability to interact professionally with colleagues, supervisors, and customers in person and remotely.
-
Ability to manage difficult, stressful, or sensitive interpersonal situations professionally, minimizing conflict while maintaining positive working relationships and clear communication.
-
Consistently demonstrates high standards of integrity, discretion, respect, and professionalism, including sound judgment in sensitive matters and a commitment to diversity, equity, and inclusion.
-
Strong organizational and prioritization skills, including the ability to manage changing requirements, multiple projects, and competing deadlines in a fast-paced environment.
-
Ability to work with new or poorly documented technologies and systems, including legacy databases and applications, with a demonstrated commitment to continuous learning and professional development.
-
Ability to meet consistent attendance requirements.
-
Willingness to learn and work with artificial intelligence (AI) tools and technologies.
-
Demonstrated history of successful support, education, and advocacy for all students, aligned with the values, mission, and messaging of the university, while adhering to the staff policy on conflict of commitment and interest.
-
Ability to interact with colleagues, supervisors, and customers face to face.
WORKING CONDITIONS
Professional office setting. The position requires typing on a computer keyboard and using a computer mouse and a printer. The employee may be required to attend meetings/functions outside normal working hours (weekend or late hours may be required during peak activity periods.) The employee may be required to carry a cellphone during and after their normal work hours, including weekends, to address after-hours emergencies. This position is eligible for the staff hybrid work program.