Welcome to CUPPA Careers!

The College of Urban Planning and Public Affairs at UIC is the University of Illinois System's home for the study of public policy and contemporary urban challenges. We are CUPPA.

In the heart of Chicago, we offer degrees in fields of study that can change your life and change the world. CUPPA students and alumni are uniquely skilled to build and transform sustainable urban neighborhoods and communities and to address the challenges presented in the 21st century. Find our more about our Bachelors, Masters, and Doctorate degrees at cuppa.uic.edu.

Follow our job postings below and our national job tweets at @CUPPACareers. For student internships and student opportunities, head to the CUPPA Student Opportunities Blog

Have a job or internship to post? Send an email with the title, location, job description, and contact information to cuppa@uic.edu
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Research Associate - Council on Tall Buildings and Urban Habitat

Job Title: Research Associate
Job Type: Full-Time
Location: Chicago, IL (Hybrid)
Salary: $58,000 - $66,000

JOB SUMMARY
CTBUH is seeking an intermediate researcher and database analyst to work in our Research and Thought Leadership team which manages the world’s pre-eminent repository of tall building information and a growing database of urban infrastructure, demographics, livability metrics, and more. This role involves maintaining and enhancing our tall building database, which contains over 40,000 buildings complete with images and vital statistics. As CTBUH grows, this role will play a critical role in developing a similar database of urban demographics, growth patterns, infrastructure, environmental metrics, and more. The ideal candidate will have hands-on experience with SQL databases and be familiar with backend development and will help - CTBUH upgrade and maintain these growing platforms. The database is a critical component of the research that CTBUH, its members, and industry leaders, conduct. This new colleague will help the organization strengthen its ability to accurately cover the rapidly increasing pace of skyscraper design, construction, and their relations to the spread of high-density cities, and to help develop and maintain the quality and integrity of data already established. 

Please email resume and cover letter to careers@ctbuh.org.

Senior Data Analyst - Chicago Public Schools

Posting Date: Feb 2, 2024, 10:57:52 AM
Primary Location: Central-42 West Madison Street (School Quality Measurement)
CPS Non-Union Job Grade: S08
Estimated Annual Salary Range : 76,000.00 - 100,500.00
Position Type: Non-Union Position
Overtime Status: Exempt
Final salary offers are dependent upon candidate qualifications.

School Quality Measurement and Research (SQMR) builds a foundation of high-quality, research-based evidence to inform district practice, policy, and vision. Through the timely and accurate reporting of school and district performance metrics, SQMR supports stakeholder involvement in district decision-making and school efforts to improve instructional effectiveness. SQMR is also actively engaging stakeholders to co-design an improved system for driving these conversations. 

Full description and application here.

Transit Systems Architect - CTA

Transit Systems Architect - (24000021) Hybrid Role
Application Deadline: 02/09/2024


POSITION SUMMARY

Under general supervision, acts as lead for the routine and long term, data maintenance of the Automated Voice Annunciation System (AVAS), CTA’s AVL System. Monitors schedule, service, routing, and stop changes and incorporate into AVAS system. Maintains audio files, public service announcements, and schedule new recordings. Delivers the AVAS distribution process to entire CTA fleet. Serves as key resource in the evaluation of AVAS, Bus Tracker, and related data.


Full description and application available here.

Chief Data Officer (Office of the Public Defender) - Cook County Offices Under the President

Job Posting: Nov 15, 2023, 8:22:39 AM
Closing Date: Nov 29, 2023, 11:59:00 PM
Job Type: Full-time
Shift Start Time: 8:30 A.M.
Shift End Time: 4:30 P.M.
Posting Salary: $117,422 - $140,330

Job Summary

Under the direction of the Chief of the Trial Technology Division, the Chief Data Officer (CDO) oversees and serves as process owner of the data of the Law Office of the Cook County Public Defender. The CDO provides a mix of strategic advice on office operations, along with engaging in tactical implementation work. The CDO works directly with the Chief Public Defender and the Executive Team to improve the Office’s internal governance and to facilitate robust data-driven decision-making and works with the Office’s Policy and Communications team to better inform external policy and advocacy. The CDO develops methodology enabling consistent application and utilization of data analytics and advances a culture of leveraging data to identify trends and support performance management. Additionally, the CDO works both internally with the Deputy of Central Operations, Chief of the Trial Support Division, and externally with Systems Administrators, County-wide IT leaders, and other leaders in the criminal legal system. Performs other duties as assigned.

This position is Actively Recruited and is At-Will. 

  Full description and application available here.

Supervision Analyst - Federal Reserve Bank - Chicago, IL

Supervision Analyst-246903
Federal Reserve Bank of Chicago
Chicago, IL

Full description:
https://frb.taleo.net/careersection/2/jobdetail.ftl?job=246903&lang=en#.V3wtHAbbv5I

Supervision and Regulation Department: Consumer Compliance Division

The Federal Reserve Bank of Chicago is searching for highly qualified candidates for an immediate opening for a Supervision Analyst to conduct data driven activities in support of supervisory objectives. Ideal candidates will have knowledge of housing, economic, and demographic data and sources, analytic skills including basic programming and query design knowledge and commitment to consumer protection. The position will be based in our landmark office in Chicago’s Financial District.

Job Summary


The Federal Reserve Bank of Chicago plays a key role in supervising compliance with consumer protection laws for banks within the Seventh District and for the largest bank holding companies regulated by the Federal Reserve. Within the Supervision and Regulation Department, the Supervision Analyst team is responsible for collecting, compiling and disseminating data in support of individual and portfolio supervisory activity. Furthermore, the Supervision Analyst team is responsible for developing intelligence on trends, risks, and data to inform supervisory and policy development throughout the Federal Reserve System.

The Supervision Analyst will work with data sources and portfolio managers to assist in the use of data driven supervision efforts for consumer protection laws. The position will work closely with other Consumer Compliance Supervision Analysts, as well as Consumer Compliance Risk Specialists to build data for use in supervisory exams and activity, create workflows, enhance procedures, and identify emerging institutional and/or portfolio level risks. This position will work with the following (although not limited to) data sources: institutional loan level data, HMDA, Small Business (CRA) and census data, and internal supervisory or regulatory databases. This position also requires the ability to produce and analyze maps.

Essential Duties
  • Develop materials to support exam activities that are accurate, quality-based, procedurally compliant and timely
  • Provide consultative activities to portfolio managers and examiners-in-charge with regards to data for exam specific activities
  • Identify and craft automated solutions for data and workflow processes, while continuing to assume ownership for procedural documents and processes
  • Collaborate to identify additional reporting needs and execute on building and delivering materials to portfolio managers, as well as senior level management
  • Develop and maintain strong ongoing relationships with supervisory personnel within the business line, division and across Reserve Banks
  • Performs other duties as assigned
Education & Experience
  • Bachelor's degree or equivalent experience. Coursework in Economics, Finance, Computer Science, Mathematics, Statistics or Business Administration preferred
  • Over three years of direct work-related experience.
Knowledge & Skills
  • Experience with SQL and or SAS preferred
  • Strong Excel Skills, including automation of routine functions, VBA a plus
  • Knowledge of GIS
  • Ability to work with external data, curate division data resources and compile new data sets
  • Knowledge of SharePoint, experience with WorkFlows or NinTex a plus.
  • Demonstrates independent thinking and decision-making abilities
  • Demonstrates strong written and oral communication abilities
  • Possesses and applies both specific and broad knowledge of principles, practices, and procedures of consumer protection
Other Requirements
  • Applicants must be U.S. Citizens or permanent residents with the intent to become U.S. Citizens
  • As a condition of employment, Federal Reserve Bank of Chicago employees must comply with the Bank’s ethics rules which generally prohibit employees, their spouses/domestic partners, and minor children from owning securities, such as stock, of banks or savings associations or their affiliates, such as bank holding companies and savings and loan holding companies. If you or your spouse/domestic partner or minor child own such securities, and would not be willing or able to divest them if you accepted an offer of Bank employment, you should raise this issue with the recruiter for this posting, who can provide you contact information for our ethics official if necessary