Data and Product Analyst- Nonprofit

The Connective is a Houston-based civic technology, design, and collective action nonprofit that transforms social services into a more connected, empathetic, and accessible system. The Data and Product Analyst will clean and analyze program data, create dashboards and geospatial visualizations, deliver actionable insights, and support Salesforce CRM administration and product development. The role also provides data services for reporting, fundraising, stakeholder collaboration, and service delivery improvement.

Responsibilities:

• Clean, join, and consolidate Connective's substantial program data from multiple sources. Perform complex quantitative data analysis to inform program strategy and support partner entities (nonprofit, government, etc.) Leverage CRM data and external sources to shed light on community trends, client needs, and internal metrics
• Build geospatial maps for public consumption and program evaluation purposes. Create tabular and visualization reports using tools like Tableau or Power BI
• Perform extensive data validation and quality assurance analysis within large datasets. Build proactive data validation automation to catch data integrity issues
• Provide analytic services related to grant reporting and fundraising proposals. Analyze problems and determine root causes through data-driven approaches. Aggregate data from multiple sources to create analyses, dashboards and supporting reports. Lead data sharing strategy with external partners. Operationalize data processes to provide automated dashboards and reports within Salesforce
• Support strategy, communications and development, and project teams with comprehensive data analysis
• Identify data issues within Salesforce and develop solutions to maintain database performance. Support Salesforce configuration to meet organizational goals and product backlog requirements. Manage product backlog priorities for CRM improvements
• Optimize Connective's Salesforce instance to improve internal workflows and user experience. Assist with custom fields, validation rules, workflow rules, and process flows in Salesforce. Coordinate with internal and external users on programmatic objectives and CRM needs. Support building new Salesforce functionality to enhance service delivery
• Work with program teams to understand and address data pain points and needs. Coordinate with internal and external stakeholders on programmatic objectives. Communicate insights effectively to executive-level partners and senior management

Requirements:

• • Strong interest in improving how vulnerable communities access social services
• • Experience leveraging Salesforce data mining and analysis techniques to create automated dashboards, reports, and data-driven insights
• • Power user in a data visualization tool such as Tableau or Microsoft Power BI
• • Advanced proficiency with Microsoft Excel for complex data analysis (data cleansing, consolidation, nested logic)
• • Ability to build tabular and graphic reports as needed
• • Demonstrated history of quickly learning and adopting new data tools
• • Excellent communication skills with proven track record in collaborative environments
• • Exceptional organizational skills and ability to prioritize multiple projects
• • Demonstrated ability to think big picture while managing detailed work
• • Knowledge of custom fields, validation rules, workflow rules, and process flows in Salesforce
• • Background in human-centered design and agile methodologies
• • Client can only consider candidates who do not require current or future sponsorship to work within the USA
• • Experience in nonprofit or social services sector strongly preferred
• • Hands-on Salesforce administration experience, ideally with Non-Profit Success Pack (NPSP)
• • Experience with SQL, Apex, and Salesforce Lightning Component framework
• • Experience building programs and processes within Salesforce