Data and Product Analyst- Nonprofit

The Connective is a Houston-based civic technology, design, and collective action nonprofit transforming social services into a more connected, empathetic, and accessible system. The Data and Product Analyst will clean and analyze program data, create visualizations and actionable insights, and support Salesforce CRM administration and product development. The role also provides data services for program strategy, grant reporting, fundraising, partner collaboration, and internal workflow 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:

• Client can only consider candidates who do not require current or future sponsorship to work within the USA
• You are highly organized and focus on data cleanliness and are most comfortable when performing in depth data analysis
• Your data visualizations tell a story to communicate our successes and challenges to our team members, clients, and partners
• You specialize in identifying and resolving data issues, developing and implementing data quality standards, and collaborating with various teams to improve overall data management
• You know that in-depth data analysis can identify problems and determine root causes
• You excel at verbal and written communication and you have strong storytelling to gain buy-in for your products
• You can easily translate client needs to product strategy
• You're as comfortable presenting to stakeholders as you are training team members
• You understand that as a shared service, your role is to enable and empower teams with the products they need, and you approach this with strong customer service skills, ensuring their requirements are met with precision and timeliness
• You have a voracious appetite for learning and sharing your knowledge
• You aim to bring your team up with you, guiding others with wisdom, patience, and understanding
• You understand the unique challenges in this sector and are driven to find creative solutions to overcome them
• 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
• 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
• Knowledge of custom fields, validation rules, workflow rules, and process flows in Salesforce
• Experience building programs and processes within Salesforce
• Background in human-centered design and agile methodologies