Analyst Programmer 3

Case Western Reserve University; Cleveland (OH); Híbrido; USD 56.000 - 71.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Healthcare

Retirement plans

Tuition assistance

Paid time off

Winter recess

Descripción de la vacante

Case Western Reserve University is seeking an Analyst Programmer 3 to modernize data interfaces, support server and data security, and manage NEOCANDO databases. The role involves SAS programming, geographic information system capabilities, and collaboration with research teams to advance social policy through data-driven indicators.

The position emphasizes development of web-based data access, data preparation, and maintaining data quality across large datasets, with opportunities for hybrid

Formación

• 5 years of progressive experience and associate's degree in related field OR 3 to 5 years of progressive experience and bachelor's degree in related field required.
• Experience in programming across multiple languages and data systems is essential.
• Ability to design, maintain and document web-based data interfaces and databases.
• Knowledge of SAS data analysis workflows and GIS mapping considerations would be advantageous.
• Ability to work in a collaborative team and communicate with stakeholders.

Responsabilidades

• Design, implement, and maintain web-based access to the NEOCANDO database and improve data access.
• Design, develop, and implement SAS programs on Windows servers for data preparation and analysis.
• Manage the center's databases, including organization, documentation, and data quality checks.
• Lead server design and policy development for secure data access and backups.
• Provide technical support for spatial analysis and GIS mapping tasks.

Conocimientos

Python

C/C++

Java

JavaScript

HTML

CSS

SQL

SAS

R

GIS software

Educación

Associate's degree in related field

Bachelor's degree in related field

Herramientas

Windows servers

SAS

GIS software

R

Descripción del empleo

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

Working under minimal supervision, the Analyst Programmer 3 will be responsible for modernizing integrated data web interfaces and legacy systems, supporting server and data security management, and managing the computer network system for the Center on Urban Poverty and Community Development. Additionally, the incumbent will collaborate with research teams using SAS and other programs to execute statistical and spatial analyses and create social indicators to advance social policy and community research.

Essential Functions

• Design, implement, and maintain the web-based access to the center's NEOCANDO database. The analyst will design and upgrade web-based access to the NEOCANDO database of social indicators. This will involve reviewing the current system and developing plans for improving access to the data, identifying methods to improve the query capacity of the web-interface, improving the methods for delivering data to users of the system, and making the system more user friendly. Identify alternatives and solutions for establishing systems and data interfaces and converting legacy systems to new technologies. Write system requirements and/or specification documents. Participate in system upgrades and other support activities as needed. Assist with technical requirements. Assure program meets quality standards. (40%)
• SAS programming and data analysis. Design, develop, and implement SAS computer programs on Windows servers. This involves a variety of tasks, such as reading data, designing and setting up SAS data sets, performing basic data quality checks, providing written documentation, and making appropriate inquiries with data providers when necessary. Write SAS programs to prepare data and analysis for applied research projects conducted by center faculty and research staff and for the NEOCANDO database. Provide written documentation on data content and completed data processing and analysis. Ensure that project deadlines are met. Work with other team members to conceptualize a plan to implement the data analysis and write SAS programs to achieve data analysis. (20%)
• Manage the center's databases. Develop and implement plans to obtain, clean, analyze, and organize the center's core and community access (NEOCANDO) databases. This includes developing programs to streamline and automate the data analysis process, to develop documentation about the database, and to organize the storage of the online database. Currently, most of the center's computer files are annual. Under the direction of the center's directors, serve as a technical assistant for the organization of the center's electronic databases. This includes, but is not limited to, developing and implementing an organizational plan for the center's electronic databases. Additional tasks include contacting outside data providers, requesting new data files, creating SAS files, and performing routine data analysis to ensure data quality. (10%)
• Manage the center's servers. The analyst programmer will lead the effort to design and manage the center's servers. This will involve working with other analysts and personnel in the Mandel School and [U]Tech to design a system that meets the current needs of the center and computer-users, which can be expanded to meet the center's projected needs. The analyst will also develop policies and procedures for the use of the servers; this will include ensuring that data are stored confidentially, that the system is backed up, and that access to confidential data is limited to users that have permission. (10%)
• Statistical and spatial analysis. Provide technical support as needed for center research projects in the area of spatial analysis and mapping. This includes reviewing GIS software and making recommendations about which packages to use in analysis, geocoding, and mapping. It also includes developing boundary map files and other foundational information for analysis of geographic data. (10%)

Nonessential Functions

• Develop new social indicators. Work with the center's directors and other staff to develop new social indicators in support of the center's community outreach, evaluation and research efforts. This includes reviewing the academic literature on social indicators and the existing use and implementation of social indicators, developing a strategy to acquire new data, and writing computer programs to create the indicators. (5%)
• Technical standards for databases. Work with other staff at the center to develop and implement technical standards for the center's databases and computer programming analyses. This includes writing and checking SAS programs and other computer programs for accuracy and documentation. (4%)
• Perform other duties as assigned (1%).

CONTACTS

Department: Daily contact with department staff for collaboration in the course of daily operations.

University: Occasional contact with administrators from other university research centers or departments to exchange information.

External: Occasional contact with outside consultants and representatives to exchange information and solve problems.

Students: Little or no contact expected with students.

Supervisory Responsibilities

This position has no direct supervision of staff employees. May supervise students as needed.

Qualifications

Experience and Education: 5 years of progressive experience and associate's degree in related field OR 3 to 5 years of progressive experience and bachelor's degree in related field required.

Required Skills

• Extensive experience in computer programming in several languages, including Python, C/C++ Java, Javascript, HTML, CSS and SQL.
• Extensive experience in managing and/or designing computer networks, web-based applications and databases. Extensive experience in managing and using extremely large (millions of data records) databases.
• Knowledge of relational databases for the purpose of maintaining complex longitudinal data. Ability to interact with colleagues, supervisors, and customers face to face.
• Extensive experience in using statistical software such as Python, SAS, and R.
• Experience with GIS software including geocoding and mapping functions.
• Proven ability and experience in working with social indicators is highly desirable. Demonstrated capabilities in designing new software applications for the purpose of building social science indicators.
• Ability and willingness to learn and self-teach new software.
• In-depth understanding of the Census data and other administrative databases that are used in creating social indicators.
• Significant coursework in statistics and social science research methods.
• Accountability/integrity, customer/quality focus, diversity/maturity, flexibility/receptivity, interpersonal relations, leadership/supervision, planning/organizing, problem solving, project management, self-development, and teamwork.
• Analytical skills and social policy and planning knowledge.
• Ability to work collaboratively in a small team environment with team members and clients.
• Excellent interpersonal and written communication skills.
• Ability to effectively communicate with colleagues, supervisor and customers face to face.
• Ability to meet consistent attendance.
• Demonstrated SHELL script experience.
• Willingness to learn and work with artificial intelligence (AI) tools and technologies.
• 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.

WORKING CONDITIONS

General office environment. The employee will perform repetitive motion using computer mouse and keyboard to type. Limited manual dexterity required. Work requires negligible physical exertion. Little or no exposure to hazards.

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.