Data Architect | University of Chicago (UC) - Military Veterans

Location: Chicago, IL Job Description: Develop new data architecture and systems (50%): Lead the process of analyzing, planning, and defining data architecture framework, including security, reference data, metadata, and master data or work closely with a third-party vendor to execute these tasks. Collaborate closely with Consortium management, research staff, and IT team to develop and implement a data strategy, data management processes, and data requirements that meet their needs and data security requirements. Translate business requirements into databases, data warehouses, and data streams. Creating procedures to ensure data accuracy and accessibility. Convene and work closely with Consortium staff to determine data definitions and best practices to structure variables, data, and documentation. Developing application programming interfaces (APIs) to retrieve data. Supervise research analysts in tasks related to building new data architecture.  Maintenance of the data library and documentation (30%): Supervise research analysts in processing data transfers, cleaning data, creating variables, building datasets, maintaining the data library, and data documentation. Perform periodical data checks to ensure data accuracy, integrity, and accessibility. Maintain a repository of all data cleaning and architecture procedures and artifacts. Oversee the development and maintenance of data documentation, including decision rules on variables and new data sources. Keep up-to-date on current technology being used in the field. With the support of the Consortium, attend training to ensure the skill level in various technologies is at the level required to perform in the current position. Support research staff (20%): Meet regularly with Chicago Public Schools (CPS) research and data staff and Consortium researchers to discuss data requests and ensure data received meet the Consortiums analytical needs.  Be the primary point of contact for communication around data for the CPS and other data partners in support of Consortium research staff. Communicate regularly with Consortium research staff on data needs and updates and answer ad hoc data questions and requests. Develop and maintain a system to collaborate with Consortium staff to support data needs such as creating new variables and datasets. Review the Scope of Work of each research project at the Consortium jointly with the Managing Director of Statistics and Analysis to ensure data needed is available. Provide ongoing professional development opportunities to Consortium staff regarding data use. Leads the development of Business Intelligence (BI) and other analytical applications. Works to achieve an integrated reporting and analysis environment, effectively leveraging analytical systems and tools. Leads requirements analysis, translating requirements into a scope document and developing reporting deliverables based on the design. Performs other related work as needed. Preferred Qualifications Education: A masters degree in computer science, information technology, data management, software development, business intelligence, or other related fields. An equivalent combination of related education, training and/or experience which provides the required knowledge, skills and abilities to perform the essential job functions. Experience: Seven years of experience analyzing data, working and understanding data processes or working with large scale student or business systems. Data processing to uncover patterns, anomalies, and correlations in large data sets. Data management to efficiently and cost-effectively collect, store, and use data. Coding languages like Python and Java to develop applications for data analysis. Machine learning to build scalable systems for handling big data. Structured query language (SQL) to manipulate data. Data modeling tools like ERWin or Visio to visualize metadata and database schema. Preferred Competencies Strong communication and collaboration skills; problem-solving and analytical skills; time management and the ability to multitask. Project management skills. Experience translating organizational data needs into functional requirements for database developers to use. Related experience in an educational or research setting. Application Documents Resume (required) Cover letter (required) The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination. Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via the Applicant Inquiry Form. The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: securityreport.uchicago.edu. Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.