i-team Data Analytics Manager, Columbus

The Bloomberg Center for Public Innovation at Johns Hopkins University (the Center) seeks an i-team Data Analytics Manager, Columbus to support a new Columbus Innovation Team (“i-team”).

Innovation Teams unlock creativity from within city governments and the communities they serve. These teams take partners and stakeholders through an evidence-based process to tackle the big problems in their cities no one has yet been able to solve, generate more ambitious responses, and test and adapt interventions until they produce impact. They also work closely with the Mayor, the City's leadership team, and City departments to change the culture of city government.

Columbus is one of 25 U.S. cities joining Bloomberg American Sustainable Cities. Bloomberg American Sustainable Cities is a three-year initiative designed to leverage historic levels of federal funding to incubate and implement transformative local solutions to build low-carbon, resilient, and economically thriving communities. Building on the longtime leadership of U.S. cities to confront the overlapping crises of climate change and racial wealth inequity, the new initiative will provide deep support to selected cities to pursue transformative solutions.

The Data Analytics Manager will create and execute the i-team’s approaches for using quantitative data and methods to understand complex issues at the intersection of climate and racial equity as part of the Bloomberg American Sustainable Cities initiative.

The ideal candidate will have a strong background in data analytics, be proficient in a general programming language (like Python) or a statistical package (R), and an appetite for engaging in non-quantitative aspects of the innovation process. The Senior Data Analyst is an employee of Johns Hopkins University and based in City Hall of Columbus. They report to the i-team Director.

The first of its kind in the world, the Center is advancing the field of public sector innovation by marrying cutting-edge practice with world-class research to transform the culture of government, deliver exceptional results for residents, and inspire trust in public service. The Center is committed to working with communities focused on ending legacies of structural, entrenched racism and oppression. The Data Analytics Manager must be willing to think about reimagined government, knowledge, and engagement models through the lens of dismantling these legacies.

Specific Duties & Responsibilities

• Lead the development and implementation of the i-team’s strategies for using quantitative data and methods to understand complex issues at the intersection of climate and racial equity.
• Shape and conduct approaches for collecting, organizing, and analyzing data, including methods for creating new data (e.g. through surveys) when there is limited or no data.
• Employ diverse quantitative methodologies and software packages, including data validation, joining of diverse datasets, historical/trend analysis, comparative/cross-sectional analysis, GIS mapping, regression analysis, etc.
• Invent and quickly iterate novel solutions to challenging data-related problems.
• Create and manage project plans for the quantitative data components of all i-team work.
• Develop and manage partnerships and collaborations with data providers and stakeholders inside and outside of city government.
• Champion the use of quantitative data to drive decisions throughout the i-team’s work.
• Produce compelling and intuitive data visualizations to drive comprehension of complex topics and concepts across a broad range of stakeholders;
• Communicate data analysis so that information and findings are accessible to a non-technical audience, including through dashboard tools like Tableau or Microsoft Power BI.
• Develop metrics and measurement systems to measure the impact of the innovation team’s projects and initiatives.
• Connect data insights to civic design research and collaborate with the civic designer to conduct research sessions including focus groups, interviews, and user testing.
• Support analogous research and literature reviews.
• Serve as a key participant in each step of the Innovation Team methodology, providing a quantitative perspective to all projects.

Special Knowledge, Skills, & Abilities

• 5+ years relevant experience managing data and conducting quantitative analysis.
• In-depth knowledge of quantitative and statistical analysis techniques.
• Experience tracking key performance indicators.
• Highly proficient with big-data software such as STATA, R, SAS, GIS software, Tableau, etc.
• Advanced-level MS Excel skills, including the use of macros, pivot tables, and other advanced functions.
• Strong ability to communicate complex concepts to diverse audiences and stakeholders.
• Attentiveness to details, deadline-oriented, acute vision, and the ability to give and receive constructive criticism.
• Excellent written and oral communication.
• Experience working for or in collaboration with local government.
• Strong sense of service to residents of Columbus.

• Bachelor's Degree.
• Seven years of experience.
• Additional education may substitute for required experience, to the extent permitted by the JHU equivalency formula.

• Experience or familiarity with government innovation efforts, including a strong conceptual and practical understanding of innovation tools and the role of human centered design, data, and policy in the public sector.
• Experience working on issues related to sustainability, climate equity, racial equity, and economic inclusion, a plus.

Classified Title: Data Analytics Manager 
Job Posting Title (Working Title): i-team Data Analytics Manager, Columbus   
Role/Level/Range: ATP/04/PE  
Starting Salary Range: $73,300 - $128,300 Annually ($128,000 targeted; Commensurate with experience) 
Employee group: Full Time 
Schedule: Monday-Friday 8:30am-5pm 
Exempt Status: Exempt 
Location: Ohio 
Department name: ​​​​​​​Ctrs for Govt Excellence & Public Innova  
Personnel area: Academic and Business Centers