Applications Developer 2

Case Western Reserve University is committed to providing a transparent estimate of the salary range available for this position at the time of its posting. The salary range is between $56,395 and $71,340, depending on qualifications, experience, department budgets, and industry data.

Employees receive more than just a paycheck. University employees enjoy a comprehensive benefits package that includes excellent healthcare, retirement plans, tuition assistance, paid time off, and a winter recess.

POSITION OBJECTIVE

Under general supervision, analyze customer and technical requirements and design and deliver high quality and robust applications and reports supporting the division of University Relations and Development. Research and develop technical requirements for enhancements to existing or new application software and design and develop data configurations and reporting. Responsible for developing and retaining core knowledge of the business application and becoming a key resource in troubleshooting performance issues.

Essential Functions

• Write programs to extract, translate, load, and verify data. Participates in creating test plans, data, procedures, and scripts. Create test data for multiple or complex projects. Create queries to extract, transform, and load data into database. Collaborates with technical and non-technical internal resources to produce and support analytics and transaction level reports, dashboards, and data cubes. Performs unit testing for solutions developed and ensures integrity and security of data. Use honesty and integrity to keep university data confidential. (70%)
• Contribute to the strategic planning of applications and technology for University Relations and Development. Analyze, design, write and test university-related application software. Analyze current and continuing information systems requirements including data, processes and system integrations and translate them into programs. Responsible for design and development of interface programs. Design and develop programs to address requirements for data conversions and other data processing. Test and debug applications in conjunction with business analysts and customers. Diagnose and correct problems with software programs. (15%)
• Work with staff to ensure software documentation, customizations and modifications meet quality standards. Translate technical or procedural information into specifications or action plans. Documents programs written or modified according to departmental standards. Serve as a resource for consultants and customers. Participates in system upgrades and other support activities as needed. Assist with technical requirements. Assures program meets quality standards. (10%)

Nonessential Funcitons

Perform other duties as assigned. (5%)

CONTACTS

Department: Daily contact with staff within the division to maintain workflow/ exchange information.

University: Daily contact with University Relations and Development personnel to provide technical assistance with applications.

External: Contact with vendors as needed to perform essential functions.

Students: None.

Supervisory Responsibilities

No direct supervisory responsibility. May supervise work of project team members (when assigned as project lead). Provide mentoring for junior level application developers and project analysts. May ensure others comply with established standards.

Qualifications

Education and Experience: Bachelor's degree in computer science, information technology, business, or related field and at least 3 to 5 years of progressive experience; OR Associate's degree in computer science, information technology, business, or related field and 5 years of progressive experience; OR High school education and at least 9 years of relevant experience.

Required Skills

• Experience in SQL for data querying and reporting within CRM systems; experienced with CRM automation tools to streamline workflows and enhance engagement; skilled in building reports and dashboards using Power BI, Tableau, Microsoft Dynamics CRM, or similar; familiar with HTML, CSS, and JavaScript for CRM customization and web-based reporting; and knowledgeable in Microsoft Dynamics CRM, particularly as it relates to Ellucian CRM Advance.
• Experience with fundraising and donor relations data and reporting is preferred.
• Working knowledge of basic database theory, design rules and development practices, including data modeling, data flow and entity relationship analysis.
• Working knowledge of principles and methods of Software Development Life Cycle and systems design principles, methodologies, and tools, including those applicable to web-based environments.
• Strong English oral and written communication skills using sound business practices, with the ability to convey technical or complex information to others in non-technical terms.
• Working knowledge of basic project management methods, tools and techniques.
• Have sound business communications with the ability to communicate complex material in ways the customers can understand.
• Ability to identify various types of problems along with the creation of workable solutions. Requires the identification and analysis of problems, evaluation of alternatives, and provision of solutions.
• Ability to be flexible to meet the constantly changing scope and needs of the department, division and customers being served. Ability to work in a fast-paced environment while managing multiple projects. Ability to optimize the use of time and resources to achieve the desired results; effectively plans and organizes work to minimize crises; prioritized appropriately.
• Ability to work with technologies for which little or no documentation or precedence exists. Commitment to self-motivated lifelong learning. Computer proficiency (including Microsoft Office) and the ability to learn new programs.
• Ability to demonstrate 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 meet consistent attendance.
• Willingness to learn and work with artificial intelligence (AI) tools and technologies.

WORKING CONDITIONS

Professional office setting. This position will have access to secure information such as alumni and donor personal information. There will be frequent pressure from demanding customers. Due to time constraints, many functions must be completed on set deadlines. Travel between various locations on campus will be required. 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. The employee will be required to carry a cell phone, during and after their normal work hours, including weekends, to attend to after-hours emergencies.

This position is eligible for hybrid work arrangement up to two remote days per week at the discretion of the department. New employees may begin a hybrid schedule upon approval from the supervisor, successful completion of an orientation period and signing the remote work checklist certification form.

Case Western Reserve University is an equal opportunity employer. All applicants are protected under federal and state laws and university policy from discrimination based on race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, protected veteran status, disability, age and genetic information.

Case Western Reserve University complies with the Americans with Disabilities Act regarding reasonable accommodations for applicants with disabilities. Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the CWRU Office of Equity at 216-368-3066 to request a reasonable accommodation. Determinations as to granting reasonable accommodations for any applicants will be made on a case-by-case basis.