Systems & Data Senior Analyst - Connected Grid Initiative

Department: Connected Grid Initiative

Employment Type: Permanent - Full Time

Location: Remote

Reporting To: Director of Operations

Compensation: $90,000 - $105,000 / year

Description

ABOUT THE ORGANIZATION:The Connected Grid Initiative (CGI) is a multi-funder collaborative and field catalyst working to advance electric transmission solutions for the future. CGI exists to unlock U.S. grid capacity and enable the deployment of clean power at scale for a stronger, more reliable, and more affordable grid for all Americans.  CGI’s theory of change focuses on overcoming critical barriers to transmission development by supporting transmission advocates at the federal level and across all regions of the country to accelerate transmission planning, paying, permitting and development. In less than 3 years since CGI’s inception, CGI has built a substantial grantee network consisting of over 60 partners including both national and local organizations with varying specializations. CGI is supported by more than a dozen key philanthropies and individuals with a shared mission: to unlock U.S. electric transmission solutions and expand grid capacity for the benefit of all Americans. POSITION SUMMARY:The Systems & Data Senior Analyst plays a central role in strengthening CGI’s internal operations, data integrity, and technology infrastructure to support our growing grantmaking and external engagement work. This position is responsible for the implementation, management, and continuous improvement of CGI’s key systems — including Salesforce (Funder and Grantee), databases, the Grants Tracker, an online grantee information sharing portal (the “Hub”), email listservs, and the CGI website — ensuring these systems are accurate, reliable, user friendly, and aligned with the organization’s evolving needs. This role serves as a key partner to CGI’s grant making team, translating programmatic needs into system features, training, and workflows. The Systems & Data Senior Analyst leads data collection, builds tools and dashboards for portfolio-wide analysis, and develops processes that enable more efficient grantmaking, stronger grantee support, and clearer insights into CGI’s impact. The role also supports external engagement systems to ensure seamless communication with CGI’s network and contributes to special projects related to operations, convenings, and donor support. The Systems & Data Senior Analyst will report to the Director of Operations initially and may transition to a new Programmatic Deputy Director once that role is filled.

Key Responsibilities

• Establish and manage systems in support of internal operations (~ 70%)
  • Manage implementation, operations, training, and population of Salesforce grantee data, including: 
    • Recording information and tracking documentation for new and existing grantees, including tracking grantee milestones;
    • Engaging with the grant making team to assess needs, deliver training, and identify feature improvements in partnership with an external vendor.
  • Lead implementation and ongoing operations of Salesforce Grants Management System (GMS), including scoping needs with the PO team and CGI’s fiscal sponsor, testing, troubleshooting with grantees, and identifying opportunities to streamline the grant application process (e.g., automation emails),
  • Lead development of an improved grantee database (potentially in Airtable, Salesforce, or another platform) to enable portfolio-wide analysis and insights,
  • Design and build a database and user interface to replace the existing Excel-based Grants Tracker to improve quarterly grant making process and improve data entry. 
  • Manage the implementation, operations, training, and population of Salesforce funder data, engaging with the Director of Strategic Partnerships to assess, refine, and enhance CRM practices and funder data maintenance.
• Manage systems in support of external engagement, including the CGI Hub website and administration of grantee inquiries via the Hub, email listservs, and CGI website (~ 20%)
• Other duties as needed in support of Director of Operations, Director of Strategic Partnerships, Program Officers, and the Executive Director (~10%)
  • Provide logistical support for retreats and convenings
  • Support vendor and project management
  • Assist with development of proposals and donor reports

The Ideal Candidate

You are someone who brings clarity and structure to complex systems and finds real satisfaction in making data accurate, accessible, and meaningful. You enjoy building tools and workflows that help teammates work smarter,