Analyst Programmer

Oregon State University, United States

Updated: 3 months ago
Location: Corvallis, OREGON
Deadline: 02 Feb 2024

Position Details
Position Information


Department Admin Technologies (JIS)
Classification Title Analyst Programmer
Job Title Analyst Programmer
Appointment Type Classified Staff
Job Location Corvallis
Benefits Eligible Full-Time, benefits eligible
Remote or Hybrid option?
Employment Category Regular
Job Summary
This recruitment will be used to fill one full-time Analyst Programmer, competency level 2, position for UIT-TSA: Administrative Technologies at Oregon State University (OSU).
This position reports to the Director of UIT-TSA: Administrative Technologies.
This position provides analysis and programming support for ERP (Workday and Ellucian Banner) sourced data integrations and application programming interfaces (APIs). This position is a member of a focused team of application developers and analysts in the creation of new products and services using existing or new technologies and applications, utilizing formalized application development methodologies and structured project management methodologies and tools. These outcomes are to enable to data migration/conversion, ERP data integrations, and/or working with vendor connectors between major systems. The incumbent will work with administrators and users through the processes of analysis, design, coding and testing to provide appropriate enhancements and maintenance for bulk and transactional data integrations (API’s). The incumbent will work with administrators and users through the processes of design, analysis, coding and testing to provide appropriate data integrations and API’s, both incoming and outgoing, for essentially any type of University data necessary to the business of higher education.
Data Statement: UIT has a commitment to deliver data as a strategic working asset and to enable data informed decision making across OSU. UIT leaders and staff will lead by example and use data to inform decision making at all levels in the organization. Persons in technology roles are also expected to design systems with data portability in mind and work within enterprise architecture and privacy guidelines.
DEI Statement: UIT has a deep commitment to and belief in the strength and value of diversity, equity, and inclusion (DEI) both throughout our team and as an intentional and active practice to advance the vision, mission, and strategic efforts of the entire university. As a member of the UIT community, the person in this position is expected to foster and promote the values of DEI and demonstrate a commitment to inclusive excellence in their work.
Security Statement: Proactively securing and protecting OSU’s digital assets and information systems is crucial to our missions of teaching and learning, research, and outreach and engagement. All OSU IT professionals have a direct responsibility to provision high quality and secure IT systems and services. Persons in technology roles are expected to be responsive to security related actions and requirements, and to collaborate to find secure ways to support the OSU community.
Why OSU?
Working for Oregon State University is so much more than a job!
Oregon State University is a dynamic community of dreamers, doers, problem-solvers and change-makers. We don’t wait for challenges to present themselves — we seek them out and take them on. We welcome students, faculty and staff from every background and perspective into a community where everyone feels seen and heard. We have deep-rooted mindfulness for the natural world and all who depend on it, and together, we apply knowledge, tools and skills to build a better future for all.
FACTS:
• Top 1.4% university in the world
• More research funding than all public universities in Oregon combined
• 1 of 3 land, sea, space and sun grant universities in the U.S.
• 2 campuses, 11 colleges, 12 experiment stations, and Extension programs in all 36 counties
• 7 cultural resource centers that offer education, celebration and belonging for everyone
• 100+ undergraduate degree programs, 80+ graduate degrees plus hundreds of minor options and certificates
• 35k+ students including more than 2.3k international students and 10k students of color
• 217k+ alumni worldwide
• For more interesting facts about OSU visit: https://oregonstate.edu/about
Locations:
Oregon State has a statewide presence with campuses in Corvallis and Bend, the OSU Portland Center and the Hatfield Marine Science Center on the Pacific Coast in Newport.
Oregon State’s beautiful, historic and state-of-the-art main campus is located in one of America’s best college towns. Corvallis is located close to the Pacific Ocean, the Cascade mountains and Oregon wine country. Nestled in the heart of the Willamette Valley, this beautiful city offers miles of mountain biking and hiking trails, a river perfect for boating or kayaking and an eclectic downtown featuring local cuisine, popular events and performances.
Total Rewards Package:

Oregon State University offers a comprehensive benefits package with benefits eligible positions that is designed to meet the needs of employees and their families including:
• Medical, Dental, Vision and Basic Life. OSU pays 95% of premiums for you and your eligible dependents.
• Free confidential mental health and emotional support services, and counseling resources.
• Retirement savings paid by the university.
• A generous paid leave package, including holidays, vacation and sick leave.
• Tuition reduction benefits for you or your qualifying dependents at OSU or the additional six Oregon Public Universities.
• Robust Work Life programs including Dual Career assistance resources, flexible work arrangements, a Family Resource Center, Affinity Groups and an Employee Assistance Program.
Future and current OSU employees can use the Benefits Calculator to learn more about the full value of the benefits provided at OSU.
Key Responsibilities
45% – Architectural design for enhancements and modifications of vendor supplied software and custom applications:
Working with the Director, and other programmer analysts across both TSA and UIT, the incumbent will contribute to the architectural design for enhancements and modifications of vendor supplied software and custom applications. This includes but is not limited to:
  • Workday tools (i.e., Workday Studio, Workday web services, and/or Workday Extend) and products.
  • Oracle RDBMS and SQL database schema design.
  • Develop processes via a data integration tool and/or API tools (i.e., Talend, Boomi, PL/SQL, SQL, Google’s Apigee, Web Services and others) to integrate data from system to system. Primary focus will be on building API’s for integrating systems data.
  • Develop and maintain schedules for delivery of data (i.e., using tools inherent in Workday, a data integration tool, and/or Automic Workload Automation job scheduling solution).
  • Develop and maintain robust error handling functions to improve data quality.
  • Maintain and develop clear and concise documentation for each integration.
  • Provide the analysis, design, and code for enhancements necessary for business processes.
  • Developing and enhancing applications using SQL, MySQL, Javascript/JQuery, C, HTML PHP 5, Python, PERL, and other languages and products.
  • Troubleshoot application and data problems demonstrating problem analysis and problem solving skills.
  • Developing tools in a UNIX shell environment such as SSH, Vim, and Bash.


25% – Architectural design for the implementation of vendor supplied software and development and implementation of custom applications:
Working with the Director, contribute to the architectural design for the implementation of vendor supplied software and development and implementation of custom applications. This includes but is not limited to:
  • Developing applications using an iterative application development methodology to better align user requirements with application solutions.
  • Analyzing, designing, coding and documenting data migrations/conversions and integrations between existing and new administrative and academic systems.
  • Helping devise an implementation strategy that is consistent with the overall project plan.

10% Work collaboratively with users and provide guidance to peer analyst/programmers devising application solutions, while following best practices in application development methodologies. This could involve team approaches to application design, peer code reviews, code quality assurance testing, version management, code migration, building sophisticated test cases, and standardized documentation of application functions and designs.
5% Demonstrate excellent interpersonal and communication skills to provide a superb customer service experience. Incumbent is expected to be able to respond collaboratively to questions from users as well as peers in the organization. User questions may include requests regarding logic changes in existing programming or inquiries about major system functions. Peer questions would include requests for assistance in debugging new code as well as troubleshooting for system malfunctions.
10% Participate as a member of the administrative development team. Time spent attending meetings, participating in team decision making, implementing solutions to team problems as well as assisting with other team functions. Incumbent is expected to participate in team discussions on best practices for new systems designs as well as modifications to existing software packages. These discussions could include reviews of logic diagrams, flow charts, coding practices and debugging techniques.
5% Professional Development – Adapt to changes in Software Development and continue to develop programming skills.
What We Require

This classification requires a basic foundation of knowledge and skills in systems analysis and related programming support functions generally obtained by a bachelor’s degree in computer science, or an equivalent amount of training and applied experience.
What You Will Need
  • Work experience using online computing systems, training in structured techniques, and basic desktop computer software.
  • Examples of work experience with programming tools include tools like SQL, PL*SQL, Web Services, XLST, MySQL, HTML, PERL, Javascript/JQuery Python, PERL or C.
  • Excellent interpersonal, team work, verbal and written communication skills and the ability to effectively use these skills in the analysis, design, and testing of applications for business solutions.


This position is designated as a critical or security-sensitive position; therefore, the incumbent must successfully complete a Criminal History Check and be determined to be position qualified as per OSU Standard 576-055-0000 et seq. Incumbents are required to self-report convictions and those in Youth Programs may have additional Criminal History Checks every 24 months. Offers of employment are contingent upon meeting all minimum qualifications including the Criminal History Check Requirement.
What We Would Like You to Have
  • Knowledge and history of data integration tools (i.e., Talend, Boomi, Informatica, etc.) or other data integration tool is preferred.
  • Experience with Workday Studio, Workday Extend, Jira, and/or Apigee.
  • Ellucian Banner, Oracle SQL experience is desirable.
  • Specialized skills in new systems and programming technologies.
  • Knowledge of formal data structure design, relational database design, and file structure.
  • Ability to design data structures to maximize efficiency and flexibility.
  • A demonstrable commitment to promoting and enhancing diversity
Working Conditions / Work Schedule
The initial work setting is within a team in cubical or hybrid cubical and remote work accommodations. It is also possible this will be a fully remote position. The employee will accomplish the majority of the required work using a virtual desktop accessed via a laptop. Hours beyond a 40-hour work week or outside the standard dayshift are rare but may be required on occasion to maintain the University operating schedule.
Pay Method Salary
Pay Period 1st through the last day of the month
Pay Date Last working day of the month
Min Salary $4759
Max Salary $8832
Link to Position Description
https://jobs.oregonstate.edu/position_descriptions/148810

Posting Detail Information


Posting Number P04609CT
Number of Vacancies 1
Anticipated Appointment Begin Date 03/01/2024
Anticipated Appointment End Date
Posting Date 01/22/2024
Full Consideration Date 01/31/2024
Closing Date 02/02/2024
Indicate how you intend to recruit for this search Competitive / External - open to ALL qualified applicants
Special Instructions to Applicants
To ensure full consideration, applications must be received by January 31, 2024. Applications will continue to be accepted after the full consideration date, until a sufficient applicant pool has been achieved or the position is filled. The closing date is subject to change without notice to applicants.
Applications will be reviewed based on the information submitted on the employment profile with education and work history along with any other requested documentation i.e. posting specific question responses, transcripts, etc. Your profile MUST clearly show how you meet the minimum/required qualifications for the position. Resumes are NOT accepted at the application stage for this position. Cover letters are optional for this position and will not be used for evaluating your qualifications.
Equivalent required experience is based on full-time equivalent (40 hours per week).
PLEASE NOTE: If you have volunteer experience relevant to this position, please include in the Employment History section and note length of time, average number of hours per week and major duties.
Typically, the starting salary is at the lower end of the salary range.
For additional information please contact: Chris Young at [email protected].
OSU commits to inclusive excellence by advancing equity and diversity in all that we do. We are an Affirmative Action/Equal Opportunity employer, and particularly encourage applications from members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, LGBTQ community members, and others who demonstrate the ability to help us achieve our vision of a diverse and inclusive community.
OSU will conduct a review of the National Sex Offender Public website prior to hire.
OSU is a fair chance employer committed to inclusive hiring. We encourage applications from candidates who bring a wide range of lived experience including involvement with the justice system. This job has “critical or security-sensitive” responsibilities. If you are selected as a finalist, your initial job offer will be contingent upon the results of a job-related pre-employment check (such as a background check, motor vehicle history check, sexual misconduct reference check, etc.). Background check results do not automatically disqualify a candidate. Take a look at our Background Checks website including the for candidates section for more details. If you have questions or concerns about the pre-employment check, please contact OSU’s Employee and Labor Relations team at [email protected] .

Similar Positions