Catalyst Cooperative is a small group of data analysts and policy wonks, organized into an employee owned consulting company. We work with data to understand and influence climate, energy, and electric utility policy in the public's interest.Whether we're supplementing the skillsets of your in-house data team, providing foundational data inputs for your analyses, or building complete data products from start to finish, our team is excited to support reproducible and data-informed energy analysis.Our Services:Data Engineering* Building custom data pipelines and architecture for data products.* Integrating new data in bulk and preparing it for analytical use by your in-house team. Public data is our priority and preference, but we work with proprietary data as well.* Combining multiple related (and likely conflicting) datasets into a coherent whole (single source of truth)* Extracting data from difficult formats such as scanned PDFs, XBRL, or obsolete databases* Upgrading existing code with software best practices like automated testing, CI/CD, version control, and shareable cloud storage.* Web scraping, including data protected by logins or buried in web apps.* Sharing data with access and privacy controls to the desired recipients, ranging from a handful of staff to a whole organization, select external partners, or the public.Data Analysis* Connecting datasets that do not share a common ID (record linkage)* Preparing custom analyses, maps and visualizations, optionally including interactivity and web hosting for broader access* Researching and summarizing the details of state and federal policy making and regulatory proceedings.* Quality controlling data for outliers, missing values, typographical errors, etc.* Image processing such as de-rotation, text detection/extraction (OCR), table detection/extraction