The Data Manager (Manager) oversees the Alliance’s Salesforce database system, its integration with other tools from which information flows, administers all database-related projects, and ensures the integrity of the data in our systems. These systems manage contacts, data and metrics for fundraising, constituent engagement, volunteer management, and other data needs. The Manager will support all staff by leveraging our data to achieve our strategic goals, and train staff to be competent users of our database system. Considering both organizational and team member needs, the Manager will find opportunities for improvement in data management systems, processes, and best practices. The Manager also leads special data-related projects and assists teams in developing KPIs (Key Performance Indicators), reports, and dashboards. Applicants should have demonstrated passion for and experience with data, data systems, and analytics. They will create actionable insights that enable Alliance teams to improve the motivation and experiences of our supporters and track progress toward strategic program and fundraising goals.
A sample week for the Manager might start with reviewing to-dos in Asana, planning out tasks for the week, and meeting with Development and Communications staff to spec the needs for a new Salesforce functionality so you can get proposals from vendors on a custom build. You spend several hours merging duplicate records in Salesforce and note an integration that may be the source of the duplicates so you can troubleshoot next week. You help the Development Associate figure out an error they’re getting while entering donations in Salesforce. Later in the week, you meet with the Finance & Operations director to review quarterly progress metrics for our strategic plan and work on updating a dashboard for our board of directors. While updating the dashboard, you suspect there’s a better way to convey some of the KPIs. You note your thoughts and carve out some time to bounce ideas off some colleagues next week. You learn the financials are done, so you move some lower priority to-dos to next week and work with the Finance Manager to begin updating our quarterly financial dashboards. On Friday morning you meet with the Office Manager and our IT provider to discuss the status of our document file migration from the physical server to a cloud-based system and weigh in on a new file management strategy. It has been a hectic week, so you take time for yourself to relax and recharge.
The Manager reports to the Finance & Operations Director as part of our four-person Operations team. They work closely with the Development and Communications & Engagement teams which are the primary users of Salesforce and other Alliance data systems.
- Oversee all data management projects including adding/deleting/merging records in Salesforce, integrating data across multiple platforms, performing routine database maintenance/upgrades, and using existing data to achieve strategic goals
- Lead all Salesforce builds and adjustments, including work with contractors when necessary
- Translate data into easy-to-read spreadsheets, dashboards, and visualizations to provide ongoing analysis and insights
- Work with staff to understand their data needs and make recommendations on how our tools can address those needs
- Review current processes and develop new ones to minimize duplication and create, maintain, and enforce data integrity standards in collaboration with colleagues
- Monitor tools/systems to make sure standards are being followed, dive in to clean or upload data when needed, and troubleshoot errors
- Provide training on and serve as the staff resource for these tools
- Balance competing priorities in a cross-functional workspace
- Help lead ad hoc special projects that relate to operational efficiency, institutional knowledge management, streamlined information sharing, and improving data practices
- Advanced proficiency in Salesforce and Excel
- Strong database skills and working experience interacting with and managing vendors
- 5+ years related experience and project management experience
- Demonstrated next-level communication skills in person, writing, and virtually
- Impeccable attention to detail and ability to manage multiple projects, establish workload priorities
- Positive attitude, self-directed and a team player
- Adhere to and exemplify the Alliance for the Great Lakes values of community, relationships, courage, integrity, optimism and the principles of justice, equity, diversity, and inclusion in all our work
- Experience integrating Salesforce NPSP with tools such as Campaign Monitor, Phone2Action, Classy, Drawloop and Apsona
- Experience with desktop QuickBooks integrations
- Experience with Asana for project management
- This position is full-time and consistent with Alliance employment policy. Salary range is 62,000-70,000, commensurate with experience.
- Excellent benefits, including health, dental, FSA and vacation
- Eligibility to enroll in a retirement plan after 1 year of employment
- This position can work remotely based within the Great Lakes region. Occasional travel within the region is required, in keeping with anticipated COVID-19 safety protocols.
Please e-mail a cover letter, resume, references and writing sample to: firstname.lastname@example.org.
Include the job title in the subject line.
Applications will be accepted until the position is filled – we are looking to fill immediately. Materials should be compatible with Microsoft Word or Adobe Acrobat. Applicants will receive confirmation of receipt of their materials and further guidance and updates about the hiring process by e-mail, with interviews provided for finalists. No phone inquiries please.
About the Alliance for the Great Lakes
The Alliance for the Great Lakes is an Equal Opportunity Employer. The search process will reinforce the Alliance’s belief that achieving diversity requires an enduring commitment to inclusion that must find full expression in our organizational culture, values, norms, and behaviors.
AGL Operating Principles and Core Values Statement
Our vision is a thriving Great Lakes and healthy water that all life can rely on, today and far into the future. We aspire to be a voice for the lakes, and to support the voices of the communities that depend on the lakes and their waters.
The mission of the Alliance for the Great Lakes is to protect, conserve and restore the Great Lakes ensuring healthy water in the lakes and in our communities for all generations of people and wildlife. We advance our mission as advocates for policies that support the lakes and communities, by building the research, analysis and partnerships that motivate action, and by educating and uniting people as a voice for the Great Lakes.
For more information about the Alliance’s programs and work, please visit us online at www.greatlakes.org.