DATA BASE ANALYST

BID/JOB ANNOUNCEMENT

DATABASE ANALYST

DEPARTMENT OF FAMILY AND SUPPORT SERVICES

CONTRACTS, IT AND PROGRAMMATIC MONITORING

Number of Positions: 1

(Additional vacancies possible pending budget approval)

Starting Annual Salary: $79,260

This position is open to the public and all current City employees covered under the City's collective bargaining agreement with AMERICAN FEDERATION OF STATE, COUNTY, AND MUNICIPAL EMPLOYEES (AFSCME) - BARGAINING UNIT 1, 3, 4 & 5. Only employees in City job titles in this bargaining unit are eligible to bid.

BID INSTRUCTIONS: Apply on the bid site: https://chicago.taleo.net/careersection/103/jobsearch.ftl?lang=en AND

1. Check the box on your profile titled "Currently employed by the City of Chicago"

2. Enter your employee ID (located on your pay stub labeled 'payee/employee number')

3. Select your correct bargaining unit

FAILURE TO FOLLOW THESE INSTRUCTIONS WILL RESULT IN A REJECTED BID APPLICATION

Applications for this position will be accepted until 11:59pm CDT on 07/08/2025

Under supervision, assists in maintaining integrated database systems and implementing new database technologies, and performs related duties as required

ESSENTIAL DUTIES

* Reviews designs of new database systems of limited complexity in order to ensure efficient performance and data integrity

* Supports and enhances the applications developed in the departments low code no code platform called Caspio.

* Monitors and evaluates the use and performance of existing database systems to ensure maximum utilization of disk space and modifies access paths and reconfigures, as required

* Maintains security and update procedures for the Data Dictionary

* Assists in resolving operational problems between databases and operating systems

* Reviews backup and recovery techniques and security architectures to protect systems and data against disk-level failures and unauthorized access

* Documents database techniques, procedures, and standards

* Assists in performing database administration functions

* Designs, codes, tests, debugs, and documents computer programs

* Collaborate with internal stakeholders to understand data requirements and translate them into scalable data models and reporting structures

* Develop and maintain data pipelines, queries, and views to support business intelligence and analytics needs

* Participate in system integration and automation efforts across platforms (Caspio, Salesforce)

* Assist in data quality assurance, validation, and reconciliation processes to ensure data accuracy and completeness

* Provide user support and training on data systems, dashboards, and reporting tools

* Stay current with database technologies and best practices to recommend system improvements and optimizations

Additional duties may be required for this position.

Location: DFSS Central Office

1615 W. Chicago Ave

Days: Monday - Friday

Hours: 8:30AM - 4:30PM

THIS POSITION IS IN THE CAREER SERVICE

* Graduation from an accredited college or university with a Bachelor's degree in Computer Sciences, Information Technology/Systems or a directly related field, or an equivalent combination of education, training and experience

SELECTION REQUIREMENTS:

This position requires applicants to complete an interview. The interviewed candidate(s) possessing the qualifications best suited to fulfill the responsibilities of the position, based on the oral part of the interview will be selected.

NOTE: You must provide your transcripts or diploma at the time of processing

Preference will be given to candidates possessing the following:

* Proficiency with the Salesforce, Service Now, MuleSoft, or any other CRM, Data warehousing ETL Process, power BI dashboards

* Previous experience with database administration

* Previous project management experience

* Previous experience developing software

* Previous experience with data analytics

• Familiarity with low-code/no-code development environments such as Caspio, Microsoft Power Apps, or Appian
• Experience building custom reports and dashboards in Power BI, Tableau, or similar BI platforms
• Understanding of relational and non-relational database systems (e.g., SQL Server, MySQL, PostgreSQL, MongoDB)
• Knowledge of scripting languages (e.g., Python, R) for automation and data processing
• Experience working with REST APIs or data integration tools for system to system communication
• Strong analytical, troubleshooting, and problem-solving skills with a focus on data driven decision-making
• Ability to document technical workflows and collaborate with both technical and non-technical stakeholders

For Information on our employees benefits please visit our benefits website at: https://www.chicago.gov/city/en/depts/fin/benefits-office.html

For Information on our salary and title structure visit our classifications website at:

https://www.chicago.gov/content/dam/city/depts/dhr/supp_info/JobClassification/2025_Classification_and_Pay_Plan.pdf

APPLICATION EVALUATION: Initial evaluation will be based on information provided on the application and the documents submitted. Department of Human Resource staff will review applications after the final posting date. Staff will follow any and all required Employment/Hiring Plan provisions, federal, state and local laws, and Collective Bargaining Agreements when applicable. Staff will apply hiring preferences as required by the municipal code. Placement on an eligibility list is not an offer or guarantee of an interview nor employment with the City of Chicago.

COMMITMENT TO DIVERSITY: To further our commitment to hiring applicants with diverse experience the City of Chicago has adopted the following ordinances 2-74-020 and 2-74-075. The ordinances provide a preference to applicants who meet minimum qualifications and who are veterans of the Armed Forces, and/or residents of Socio-Economically Disadvantaged Areas (SEDA) and/or Chicago Public School (CPS) high school graduates to be referred to departments for consideration. These hiring preferences do not apply to bidders, as Collective Bargaining Agreements define the hiring process for bidders. For positions covered by a collective bargaining agreement, bidders will be considered before external candidates. To learn more about our hiring practices click here.

ALL REFERENCES TO POLITICAL SPONSORSHIP OR RECOMMENDATION MUST BE OMITTED FROM ALL APPLICATION MATERIALS SUBMITTED FOR CITY EMPLOYMENT.

The City of Chicago is an Equal Employment Opportunity, Military Friendly, and Fair Chance Employer.

City of Chicago

Brandon Johnson, Mayor