Applications Developer 2

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

Benefits offered by this job

Healthcare

Retirement plans

Tuition assistance

Paid time off

Winter recess

Job summary

Case Western Reserve University is seeking a software analytics professional to analyze requirements and deliver robust applications and reports. You will develop data configurations and reporting, troubleshooting performance issues, and support University Relations and Development.

The role emphasizes data extraction, ETL, dashboards, and CRM-driven analytics using Power BI/Tableau, with hybrid work options and comprehensive benefits.

Qualifications

• BA/AS with relevant IT/CS or business degree and progressive experience.
• Experience in SQL data querying and CRM data reporting.
• Experience building reports and dashboards with Power BI/Tableau.
• Familiar with web tech for CRM customization (HTML/CSS/JS).

Responsibilities

• Write programs to extract, transform, load data and create test data.
• Develop dashboards, analytics, and data cubes; ensure data security.
• Design software interfaces and assist with system upgrades.

Skills

SQL

CRM tools

Power BI

Tableau

Microsoft Dynamics CRM

Ellucian CRM Advance

HTML

CSS/JavaScript

Data reporting

Data modeling

Education

Bachelor's degree in computer science/IT/business

Associate's degree with 5+ years experience

High school + 9 years experience

Tools

Power BI

Tableau

Microsoft Dynamics CRM

Ellucian CRM Advance

CRM automation tools

Job description

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 Functions

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.