Application Developer 2

Case Western Reserve University; Cleveland (OH); Hybrid; USD 75,000 - 110,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Case Western Reserve University is seeking a software developer/analyst to analyze requirements and design high quality applications and reports supporting University Relations and Development. You will research and develop technical requirements and create data configurations and reporting.

You will also troubleshoot performance issues and retain core business knowledge. The role emphasizes ETL, data modeling, SQL, and creating dashboards and data cubes, with hybrid work up to two remote days

Qualifications

• 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.
• Experience with fundraising and donor relations data and reporting is preferred.
• Working knowledge of basic database theory, design and development practices, including data modeling, data flow and ER analysis.
• Knowledge of SDLC and systems design principles, including web-based environments.
• Strong English communication skills to convey technical concepts to non-technical stakeholders.

Responsibilities

• Write programs to extract, translate, load, and verify data; create test data and queries for ETL processes.
• Collaborate to produce analytics, dashboards, and data cubes; perform unit testing and ensure data integrity and security.
• Analyze requirements, design and test application software; support system upgrades and documentation.

Skills

ETL

Data modeling

SQL

Analytics reporting

Communication

Education

Bachelor's degree in Computer Science / IT / Business

Tools

Database design

Job description

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