City of Chicago Office of Inspector General · 1 day ago
Forensic data analyst – database administrator
Chicago, IL
Full-time
Onsite
Entry, Mid Level
$89K/yr - $123K/yr
2+ years expThe City of Chicago Office of Inspector General is seeking a Forensic Data Analyst – Database Administrator to provide critical support for data collection and analysis. This role involves implementing ETLs, performing database maintenance, and ensuring the security and integrity of databases while troubleshooting related issues.
Government Administration
Responsibilities
Develop Extract, Transform and Load (ETL) processes using Pentaho Data Integration and Tableau Prep Conductor
Troubleshoot and resolve database and ETL related problems
Work closely with CITA staff to support all stages of data collection, cleaning, and coding for data analysis
Manage OIG staging and production environment database instances including installation, configuration, and maintenance
Develop, administer, and maintain ETLs and other related processes used to update Tableau dashboards
Plan and document designs for new database elements, data flow diagrams, and data models
Review third-party databases to develop data dictionaries and related SQL queries
Assist OIG staff in the development and review of SQL queries
Performs related duties as required
Qualification
Required
Graduation from an accredited college or university with a bachelor's degree in computer sciences, information technology/systems, business administration or a directly related field
Two years of data analysis or data management work experience, or an equivalent combination of education, training and experience
Develop Extract, Transform and Load (ETL) processes using Pentaho Data Integration and Tableau Prep Conductor
Troubleshoot and resolve database and ETL related problems
Work closely with CITA staff to support all stages of data collection, cleaning, and coding for data analysis
Manage OIG staging and production environment database instances including installation, configuration, and maintenance
Develop, administer, and maintain ETLs and other related processes used to update Tableau dashboards
Plan and document designs for new database elements, data flow diagrams, and data models
Review third-party databases to develop data dictionaries and related SQL queries
Assist OIG staff in the development and review of SQL queries
Perform related duties as required
Strong work ethic and professionalism
Excellent written and oral communication
Excellent interpersonal, communication, and problem-solving skills
Collaborates with co-workers and thrives in a team-based environment
Ability to effectively work cross functionally in a fast-paced work environment
Preferred
Data management, with a strong background in relational database design with knowledge of Microsoft SQL and MySQL databases
Creating, scheduling, and debugging extracts on Tableau Server
Relational data structures, theories, principles, and practices
Experience querying Oracle, MySQL, Postgres, and T-SQL
Data warehousing, dimensional design/modeling and ETL architectures (such as Pentaho or Snowflake)
Writing and reading complex SQL queries, stored procedures, triggers and views and program in at least one other programming language (such as Python, R, or Java)
Data sets matching and manipulating large amounts of data from multiple sources
Documenting with superior details and accuracy
Translating technical issues for non-technical audiences
Data modeling tools such as SQL Developer Data Modeler
Company
City of Chicago Office of Inspector General
The City of Chicago Office of Inspector General (OIG) is an independent, nonpartisan oversight agency whose mission is to promote economy, effectiveness, efficiency, and integrity in the administration of programs and operations of City government.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase