JC John Collier Back

Resume

Data analyst with nearly a decade of experience building the infrastructure, tools, and analyses that support public-sector decision-making. Currently supports data systems and reporting for the MTA’s congestion pricing program, with prior experience helping nonprofit leaders make better use of data. Combines strong technical skills with business and policy judgment to cut through complexity and deliver clear, actionable insights.

Experience
  1. Senior Data Systems Analyst

    MTA Bridges & Tunnels · New York, NY

    May 2024 — present
    • Coordinated data inputs and conducted key analyses for the program's inaugural evaluation report, navigating an environment of significant public and political scrutiny.
    • Monitor program data to surface anomalies, validate performance trends, and flag emerging operational risks across CBDTP reporting systems.
    • Translate complex operational, financial, and policy data into executive briefings and decision-support materials for senior leadership.
    • Lead development of public dashboards, open datasets, and reporting tools for congestion pricing on metrics.mta.info, improving data transparency and accessibility for policymakers, researchers, and the press.
    • Build and maintain Apache Airflow pipelines in the MTA Data Lake, modernizing B&T data workflows and aligning CBDTP reporting with MTA-wide infrastructure standards.
    • Support and coordinate cross-agency analytical work across B&T, MTA, NYC DOT, NYSDOT, and NYC Health Department, helping deliver research products tied to statutory reporting requirements.
  2. Data Solutions Analyst

    Community Solutions · New York, NY

    Jan 2022 — May 2024
    • Partnered with local homeless response system leaders across the country to scope analytical projects and deliver tailored data tools, directly supporting strategic decision-making and program improvement.
    • Developed KPIs and reporting frameworks to evaluate program effectiveness and track progress against organizational goals.
    • Managed a portfolio of web applications and data products serving internal teams and community partners, owning development, maintenance, and documentation end-to-end.
  3. Analyst

    What Works Cities · New York, NY

    Nov 2019 — Jan 2022
    • Led cities through the What Works Cities Certification process, facilitating calls with mayors and other leaders of prominent US cities to evaluate their use of data and evidence in decision making.
    • Coordinated the development and launch of the City Budgeting for Equity and Recovery program, providing critical support to mayors and city financial leaders in the wake of COVID-19.
    • Developed and maintained Salesforce objects, flows, and reports to track city progress through certification pipelines and organizational workflows.
    • Performed statistical analysis, data cleaning, and database management for the organization to provide crucial insights and data-driven recommendations for programmatic decision-making.
  4. Manager of Research

    Greater Ohio Policy Center · Columbus, OH

    Jun 2018 — Aug 2019
    • Scoped, managed, and conducted high-quality research projects focused on issues and best practices related to urban revitalization and smart growth that led to concrete policy changes.
    • Provided technical assistance to leaders in Ohio cities on topics such as blight removal, affordable housing, downtown revitalization, and public-sector capacity building.
    • Estimated the $180 million economic impact of landbanking in Central Ohio through geospatial analysis of administrative datasets.
    • Served as an evaluator of a $3 million grant, tracking changes in neighborhood conditions through demographic/economic data as well as on-the-ground interviews.
  5. Research Associate

    Greater Ohio Policy Center · Columbus, OH

    May 2017 — Jun 2018
    • Supported research projects and policy analysis on Ohio urban development issues, contributing to reports and publications on smart growth and economic revitalization.
Education Skills
Technical
Python, SQL, Apache Airflow, Tableau, D3.js, ArcGIS, QGIS, Salesforce, n8n
Analytics & Methods
Data pipeline development, geospatial analysis, statistical forecasting, program evaluation, policy analysis, economic impact analysis
AI & Automation
LLM prompt design & optimization, AI agents & workflow automation
Professional
Stakeholder engagement, project management, legislative research, executive reporting