Project Manager, Data Analytics And Reporting

Brooklyn Public Library (BPL) uses data visualization to streamline and democratize the distribution of data at all levels of the organization to drive data-influenced decision making.  By creating dashboards that communicate accurate data insights we enable confident, effective decision making and ensure that reporting (internal and external) is done consistently and efficiently. 

Reporting to the Director, Data Analytics & Strategic Research in the Strategy Department, this position brings together internal data from multiple sources as well as external data to provide dashboards that support branch level and system wide initiatives. In addition, this position will use data from the dashboards, supplemented with additional data as needed, to fulfill external reporting requirements to state and local governments and other entities as required. External reporting requirements include: the Mayor’s Management Report; New York State Annual Report; New York State Five-year Plan of Service; the Public Library Data Service, and more.  

• Report & data maintenance and development – Deliver data and reports monthly and on an ad-hoc basis for internal and external stakeholders using tools including Tableau (Desktop, Server, and Prep), Arc/QGIS, Python, R, SQL, Excel, Google Sheets, etc. 
• Expert guidance – Understand underlying library goals, initiatives, and challenges to leverage Analytics and visualization tools that present information in a way that both tells a story and drives fact-based decision making. 
• Analysis – Generate ideas for exploratory analyses to shape projects and provide recommendations for actions. 
• Proactive request management – Think beyond individual requests and plan for future usage through data/dashboard organization, accuracy, and structure. 
• Data curation – Organize and integrate data from a variety of sources for incorporation into data extracts for use in reports, drawing on multiple data sets. 
• Deepening the data culture – Work with staff from all levels of the organization to train them on using tools developed.  Coordinate a Data Steering Committee to provide guidance on where additional dashboards, training and other supports are needed.  Support/train staff in other departments who are creating dashboards using Tableau and other tools.  Ensure organizational standards are followed and data consistency is maintained.   
• External reporting – Manage the process for submitting reports (annually and quarterly) to the State of New York, City of New York, Library trustees, Library leadership, and the Public Library Association, among others.  Track deadlines for each, coordinate with other departments to gather data needed, get approvals needed from management or the board, submit data in the format required and create dashboards that allow the comparison of reports year over year.  Work to streamline the process by incorporating new datasets needed into existing workflows.  
• Work with BPL leadership to set new organizational performance targets 

• Bachelor's degree required, relevant masters degree or equivalent experience a plus
• Intensely curious with a strong willingness to learn; not afraid to make mistakes; willing to find creative solutions to difficult problems 
• Ability to comprehend and dissect complex issues, and explain them in non-technical terms 
• Ability to manage multiple projects at one time; juggle priorities and deal with last-minute requests; stays aware of organizational initiatives yet knows how to stay prioritized 
• Highly analytical and detail-oriented; relishes data accuracy and clarity 
• Ability to effectively communicate data and Reporting needs and deadlines to other departments and work collaboratively to create an effective process for gathering this data  
• Skilled with data visualizations and the importance of data visualization choices to convey insights and tell interesting business stories 
• Expertise in Tableau (Desktop, Prep, and Cloud) report creation and data source management 
• Knows how to use R, Python and/or SQL in particular as part of ETL processes and using APIs to effectively pull data from various sources 
• Use of tools to streamline and automate data collection (e.g. AirTable, PowerAutomate, JotForms, AppSheet, Salesforce) 
• Knowledge of NYC Open Data and open source databases, including U.S. Census Data 
• Advanced capabilities with spreadsheet software such as MS Excel and Google Sheets 
• Familiar with use of Arc/QGIS to analyze spatial information and integrating shapefiles into Tableau  
• Self-sufficient, resourceful, able to work both independently and in teams 
• Open-minded, hypothesis led, data-driven and innovative 

This is a non-union position with a salary range of $72,000 - $78,000.