PRINCIPAL DATA ANALYST

Description BID/JOB ANNOUNCEMENT PRINCIPAL DATA ANALYST Department of Technology and Innovation IT Delivery Number of Positions: 1 (Additional vacancies are possible pending budget approval) Annual Starting Salary: $99,480 These positions are open to the general public and to all current city employees covered under the terms of the City's collective bargaining agreement with the AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES (AFSCME) - (BARGAINING UNIT #01, 03, 04, 05). Only employees in City job titles in this bargaining unit are eligible to bid. Under general supervision, identifies captures, analyzes, and manages data contributing to better decision-making and planning; bridges complex datasets with executive decision-making and performs related duties as required. Essential Duties: Works independently with varying teams to determine how data analysis can support organizational goals. Gathers data to support recommendations to address problems, with appropriate contingency plans. Develop recommendations for resolution of problems and reviews recommendations with the team. Understands and apply information and data analysis requirements. Turns information into insights to support and enable key decisions and business processes. Supports information governance in conjunction with Architects and Data Stewards. Designs, creates, and maintains relational databases and data systems of moderate to high complexity. Works with open datasets, including populating and extracting data from internal and public open datasets. Performs data analysis, including conceptualization, modeling, and presentation of data. Performs a variety of technical tasks related to capturing, managing, and analyzing data. Cleans and prunes data to discard irrelevant information. Designs reporting dashboards to translate data into an understandable illustrative format and fulfills ad hoc reporting requests. Develop procedures for data validation, analysis, and presentation. Performs initial data exploration (e.g., binning, pivoting, summarizing, and finding correlations). Implement statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision-making processes. Actively suggests analytics opportunities and best practices. Catalogs and enables access to resident and external data sources. Helps to streamline analytics to go from experimentation into production. Supports innovative efforts by driving creativity, acting with agility, and thinking outside current boundaries. May create data visualizations and reports to present to audiences using presentation layer tools. Additional duties may be required for this position. Location: 2 N. Lasalle, Suite#1010 Chicago, IL 60602 Shift: Monday-Friday Hours: 8:00a.m. to 4:00p.m. (Flexible) (Shift may vary due to the needs of the operation) THIS POSITION IS IN THE CAREER SERVICE Qualifications Graduation from an accredited college with an Associate's degree in Computer Science, Information Systems, Business, or a directly related field, plus two (2) years of data analysis work experience . OR Graduation from an accredited college with a Bachelor's degree or higher in Computer Science, Information Systems, Business, or a directly related field, plus one (1) year of data analysis work experience . OR Four (4) years of work experience in data analysis. NOTE: To be considered for this position you must provide information about your educational background and/or work experience. You must include job titles, dates of employment and specific job duties. (If you are a current City employee, Acting Up cannot be considered ). If you fail to provide this information at the time you submit your application, it will be incomplete, and you will not be considered for this position. There are three ways to provide the information: 1) you may attach a resume; 2) you may paste a resume; or 3) you can complete the online resume fields. Educational & Employment Verification Please be advised that if you are selected to be hired you must provide, upon request, with adequate information regarding your educational and employment history as it relates to the qualifications of the position for which you are applying. If you received your degree internationally, all international transcripts/diploma must be accompanied by a Foreign Credential Evaluation. If the City of Chicago cannot verify this information, any offer extended to you will be withdrawn and you will not be hired. NOTE: A copy of your official transcripts and/or professional license, or training certificates will be required at the time of interview, if applicable. Selection Requirements : This position requires applicants to complete an interview. The interviewed bidders possessing the qualifications best suited to fulfill the responsibilities of the position will be selected in seniority order according to the collective bargaining agreement . The interviewed external candidate(s) possessing the qualifications best suited to fulfill the responsibilities of the position will be selected. Desired Skills 5 or more years of experience in data analytics. Experience with BI tools (Tableau, Power BI or AWS Quick sight). Experience developing and managing ETL pipelines. Strong understanding of Data Governance Advanced proficiency in SQL, Python, R, or Spark). For Information on our employees benefits please visit our benefits website at: For Information on our salary and title structure visit our classifications website at: APPLICATION EVALUATION: Initial Evaluation will be based on information provided on the application and the documents submitted. The Department of Human Resources 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 #J-18808-Ljbffr