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.

Job Description

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…