The Programmer/Analyst for the Office of Analysis, Assessment, & Accreditation (AAA) is an important role that requires expertise in SQL and knowledge of other programming languages to provide critical support to the business intelligence and analysis unit. This includes organizing and leading in the development, design, and maintenance of information technologies. The successful candidate should possess strong communication skills to work collaboratively with stakeholders on programming-related discussions and be responsible for analyzing, evaluating, specifying, and maintaining information systems to meet unit objectives. 

This position will be hired at either a Programmer/Analyst I, II or III depending on the qualifications of the candidate and the duties assigned - see Qualifications Section.  Excellent Benefit package includes 14.2% of gross pay into a retirement account without any employee contribution; annual paid days off including 22 paid vacation days, 12 paid sick days, and 13 paid holidays; and excellent medical, dental, short-term disability, and long-term disability plans.  

• Analyze, design, develop, test, and maintain technical solutions within a SQL environment to solve various data problems.
• Manage and integrate cloud-based software including Digital Measures, Campus Labs, IDEA, and Canvas (LMS) using APIs and other import/export tools.
• Provide hands-on development and support for critical databases and business applications with high quality standards.
• Work with internal business partners (unit partner leads in IT, Registrar’s Office, etc.) to design programming solutions to meet USU mission goals and unit targets.
• Work with external partners and design custom integrations, ETLs, etc. as needed.
• Provide input to the assistant director and schedule and lead programming discussions, as needed.
• Manage the technical delivery of projects, including design, build, test, implementation, and integration stages.
• Maintain a data management plan and ensure data security and integrity.
• Contribute strategically and envision how existing and new applications, legacy systems, databases, and web services work best together, improving the underlying infrastructure for critical business intelligence.
• Collaborate in multi-discipline teams to research, analyze, and develop solutions that address specific needs and administrator requests.
• Propose and implement unit-specific data solutions as appropriate and assist management in organizational planning.
• Organize, set priorities, schedule and review work as needed to complete team goals.
• Solicit and document system requirements.
• Maintain all server hardware and software and develop, test, maintain and document third-party, web-based software tools that interface with critical USU business systems.
• Develop and maintain the AAA website and all related data resources.
• Perform miscellaneous job-related duties as assigned by department.
• Other duties as assigned.

Minimum Qualifications:

• The position will be hired at Programmer/Analyst I, II, or III, depending on the education/experience of the candidate and the duties assigned. Requirements for each level are listed below (one year of experience equals one year of education):
  
  • Level I: Bachelor’s Degree in Computer Science, Information Technology, or related field OR an equivalent combination of education and experience.
  • Level II: Bachelor’s Degree in Computer Science, Information Technology, or related field plus 2 Years of experience in programming, business information and/or data analysis OR an equivalent combination of education and experience.
  • Level III: Bachelor’s Degree in Computer Science, Information Technology, or related field plus 4 Years of experience in programming, business information and/or data analysis OR an equivalent combination of education and experience.
• Strong MS SQL Server background (administration and development) required
• Experience creating and managing database tables, views, stored procedures, and common table expressions
• Demonstrated experience with data ETL processes in SQL environment
• Experience doing query optimization on SQL servers
• Ability to quickly create complex ad-hoc queries based on business needs
• Cloud-based data management skills (Rest API and ELT experience)
• Desire to learn and deploy new skills and knowledge
• Ability to multitask and prioritize independently
• Ability to work with various stakeholders across an organization

Preferred Qualifications:

• Experience with databases used by Utah State University (e.g. Oracle, Banner SIS)
• Experience with Tableau or other BI analysis and reporting concepts
• Experience conducting data quality analysis
• Experience with PowerShell scripting language or similar scripting tools
• Experience with data pipeline optimization
• Experience in data vault/data warehouse development
• Experience with database server administration/optimization
• Knowledge of disaster recovery policies and procedures
• Understanding of statistical analysis
• Experience in survey analysis and administration
• Experience working with sensitive data in a regulated environment
• Demonstrated project management and leadership skills.
• Experience working with external data partners, problem solving experience and relationship management skills.

Along with the online application, please attach:

1. Resume/CV to be uploaded at the beginning of your application in the Candidate Profile under “Resume/CV”
2. Name and contact information (including email) of three professional references to be entered at the beginning of your application in the Candidate Profile
3. Cover Letter to be typed/pasted at the end of your application

**Document size may not exceed 10 MB.**

Employees work indoors and are protected from weather and/or contaminants, but not, necessarily, occasional temperature changes.  The employee is regularly required to sit and often uses repetitive hand motions.

The Office of Analysis, Assessment, & Accreditation is a reporting unit to the Office of the Executive Vice President.  For more information, please visit our website at https://www.usu.edu/aaa/

Utah State University (USU) was founded in 1888 and is Utah’s land-grant and space-grant university. USU is one of only 146 research institutions in the U.S. classified as R1 “very high research activity” by the Carnegie Classification of Institutions of Higher Education. As one of the two premier research institutions in Utah, USU provides a high-quality education at an affordable price. With its main campus in Logan, the university serves approximately 27,500 students, including 24,255 undergraduates and 3,171 graduate students. USU Online has served students from all 50 states and 55 countries for 25 years.

USU’s statewide system features three residential campuses, 30 total campus locations, and 23 Extension education centers. The university employs 903 full-time faculty members, 124 executive administrators, and 1,649 full-time support staff. USU offers 115 undergraduate majors, as well as 91 master’s and 42 doctoral degrees. Learn more about USU.

A core characteristic of USU is engagement with communities and people in economic development, improvements to quality of life, and human capital. Through the practical application of knowledge, the University and its faculty engage and share expertise with the state, nation, and world, preserving the historical land-grant tradition of partnering with communities to address critical societal issues in the interest of the public good.

The USU main campus is located in beautiful Logan, Utah, a city of about 50,000 situated in a picturesque mountain valley about 80 miles north of Salt Lake City. Outstanding recreational opportunities abound in the nearby mountains and proximate region.

USU is sensitive to the needs of dual career couples and provides a Dual Career Assistance program to support careers for partners who are also seeking employment.

USU endeavors to provide reasonable accommodations to ensure equal access in all aspects of employment to qualified persons with disabilities. To request a reasonable accommodation for a disability, please contact the university’s ADA Coordinator in the Human Resource office at 435-797-0122 or submit a request at hr@usu.edu.

USU Land Acknowledgment

Please visit our website to learn about Utah State’s land acknowledgment of the eight tribes of Utah.

Notice of Non-discrimination

In its programs and activities, including in admissions and employment, Utah State University does not discriminate or tolerate discrimination, including harassment, based on race, color, religion, sex, national origin, age, genetic information, sexual orientation, gender identity or expression, disability, status as a protected veteran, or any other status protected by University policy, Title IX, or any other federal, state, or local law.

The following individuals have been designated to handle inquiries regarding the application of Title IX and its implementing regulations and/or USU’s non-discrimination policies:

Executive Director of the Office of Equity Matthew Pinner, discrimination@usu.edu, Distance Education Rm. 401, 435-797-1266

Title IX Coordinator Matthew Pinner, titleix@usu.edu, Distance Education Rm. 404, 435-797-1266

Mailing address: 5100 Old Main Hill, Logan, Ut 84322

For further information regarding non-discrimination, please visit https://equity.usu.edu/, or contact:

U.S. Department of Education, Office of Assistant Secretary for Civil Rights, 800-421-3481, OCR@ed.gov

U.S. Department of Education, Denver Regional Office, 303-844-5695, OCR.Denver@ed.gov

*updated 11/2022