Requisition ID:  116564

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.


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


Preferred Qualifications
  • 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 

 

 


Total Rewards
The referenced base salary range represents the low and high end of Johns Hopkins University’s salary range for this position. Not all candidates will be eligible for the upper end of the salary range. Exact salary will ultimately depend on multiple factors, which may include the successful candidate's geographic location, skills, work experience, market conditions, education/training and other qualifications. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/.

Education and Experience Equivalency
Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines: JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.

Applicants Completing Studies
Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

Background Checks
The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

Diversity and Inclusion
The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.

Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

EEO is the Law
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

Accommodation Information
If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit https://accessibility.jhu.edu/.

Vaccine Requirements
Johns Hopkins University strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine. The COVID-19 vaccine does not apply to positions located in the State of Florida. We still require all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. This change does not apply to the School of Medicine (SOM). SOM hires must be fully vaccinated with an FDA COVID-19 vaccination and provide proof of vaccination status. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.

The following additional provisions may apply, depending upon campus. Your recruiter will advise accordingly.
The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.

MD - Other Location