Applications accepted January 7, 2019 through January 28, 2019.
To apply for this position, complete the application: here
MINIMUM QUALIFICATIONS: 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, plus two years of data analysis or data management work experience, or an equivalent combination of education, training and experience.
ADVANCED KNOWLEDGE OF:
- In data management, with a strong background in relational database design with knowledge of Microsoft SQL and MySQL Databases;
- Developing Extract, Transform and Load (ETL) processes using Pentaho Data Integration tools and MS SQL Server Integration Services (SSIS);
- Understanding of relational data structures, theories, principles, and practices;
- Working with Oracle and MySQL;
- Data warehousing, dimensional design/modeling and ETL architectures;
- Writing complex SQL queries, stored procedures, triggers and views and program in at least one other programming language (such as Pentaho, Python or Java);
- Matching data sets and manipulating large amounts of data from multiple sources;
- Documenting with superior details and accuracy;
- Translating technical issues for non-technical audiences;
- Being proactive, flexible, and customer focused with strong organizational and follow-through skills to create and execute work plans, prioritize work, manage multiple projects and meet deadlines;
- Understanding Oracle, Microsoft, etc. data technology environments.
- Data modeling tools such as Erwin Data Modeler
Under the supervision of the Chief Data and Information Systems, the Forensic Data Analyst-Database Administrator (FDA-DBA) will work with other CITA team members to provide critical support for timely and accurate data collection and analysis. The FDA-DBA will be responsible for implementing data models, database designs, database maintenance, and storing data. Responsibilities will include building and organizing data from a variety of sources and setting up new databases. The FDA-DBA will also maintain policies and procedures for ensuring the security and integrity of Office databases. In addition to the above, the FDA-DBA will regularly perform routine tests and modifications to ensure that the data systems are performing and running correctly. If a problem occurs, the FDA-DBA will troubleshoot the systems.
Key duties include but will not be limited to the following:
- Develop and administer ETL processes.
- Map out the conceptual design for new database features; design data flow diagrams and data models.
- Develop and design new functionality for Office database applications
- Create and administer database objects (tables, forms, queries/views, reports, and functions, etc.) from design to deployment and utilize subject matter expertise to design or re-use, configure, and implement database solutions/processes that maximize system availability efficiently and effectively, and to preserve data integrity, recoverability, and supportability.
- Perform all tasks related to the database and implementation of technology tools.
- Provide guidance and feedback to data users on the design and execution of new features.
- Work closely with CITA staff to support all stages of data collection, cleaning, coding, and file conversion into formats that are useful for analysis.
- Periodically perform checks for accuracy in databases.
- Manage day-to-day maintenance of OIG relational databases and data marts
- Maintain selected data sources and implement regular updates to ensure data quality.
- Document procedures and calculations used to describe program outcomes.
- Provide technical and operational assistance to users, troubleshoot and resolve application and database related problems.
- Perform related duties as assigned.
Range: $73,212 – $100,692 (annual increases)
Starting $73,212 (non-negotiable); Post successful six-month review
TRAVEL AND SCHEDULE: Travel outside Chicago is not required. Standard work hours are 8:30am-4:30pm, flexibility permitted.
RESIDENCY REQUIREMENT: Employees must be a resident of the City of Chicago and proof of residency is required at the commencement of employment, per Section 2-152-340 of the Municipal Code of Chicago.
OWING OF CITY DEBT: Municipal Code of Chicago 2-152-150 prohibits the hiring of anyone who owes any debt to the City of Chicago.
INSTRUCTIONS: To apply for this job title do NOT use the City of Chicago online application.
Complete, the “Inspector General Employment Application,” by clicking here;
NOTE: APPLICATIONS MUST BE SUBMITTED BY THE INDIVIDUAL APPLYING. NO SECOND PARTY APPLICATIONS WILL BE ACCEPTED. THE INSPECTOR GENERAL’S OFFICE REQUIRES THAT ITS EMPLOYEES BE NONPARTISAN AND FREE FROM CONFLICTS OF INTEREST.
THE CITY OF CHICAGO IS AN EQUAL OPPORTUNITY AND MILITARY FRIENDLY EMPLOYER
In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. The City of Chicago does not participate in E-Verify (Employment Eligibility Verification System). In addition, employment at the Office of Inspector General is contingent upon a satisfactory criminal background check.