About Us
God’s Love We Deliver, a nonsectarian organization, is the New York metropolitan area’s leading provider of life-sustaining meals and nutrition counseling for people living with severe illnesses. Begun as an HIV/AIDS service organization, today God’s Love provides for people living with more than 200 individual diagnoses. God’s Love cooks and home delivers the specific, nutritious meals a client’s severe illness and treatment so urgently require. Meals are individually tailored for each client by one of our Registered Dietitians, and all clients have access to unlimited nutrition counseling. God’s Love supports families by providing meals for the children and senior caregivers of its clients. All of the agency’s services are provided free of charge to our clients.
About the Role
God’s Love has recently transitioned our client and production management system to Salesforce. During this time of change, we identified a strong need to manage our enterprise reporting data capacity, in Salesforce, Microsoft SQL, and PowerBI. The CRM ERP Data Manager will provide the skills and expertise to oversee and manage our Microsoft SQL server system data sourced from Salesforce and support the continued development of our data warehouse capabilities and efficiencies.
This role requires experience in data management, reporting tools, and a deep understanding of CRM and ERP systems to optimize reporting processes and ensure data quality. The CRM ERP Data Manager reporting to Information Technology/Systems will work closely with cross-functional teams, including Strategy and Growth, to provide insight and ensure the accuracy of reporting across all systems.
The ideal candidate will be able to assume responsibility for ensuring the efficient collection, processing, and accessibility of data from CRM and ERP platforms to be used by the Systems and Analytics teams at God’s Love for analysis and reporting.
Essential Duties and Responsibilities
● Manage, maintain, and optimize CRM and ERP data sources including Microsoft SQL server sourced from Salesforce.
● Manage the MS SQL server reporting environment including managing backups and Salesforce API.
● Assist with the management of reports in PowerBI and Salesforce.
● Work closely with the Salesforce Administrator, the Salesforce Solution Architect and other consultants regarding Salesforce data architecture as then made available in MS SQL Server.
● Ensure the integrity, accuracy, and timeliness of data for reporting purposes.
● Perform data cleansing, validation, and transformation tasks to ensure high-quality data; perform Extract, Transform, Load tasks as needed.
● Design and build data models in collaboration with the analytics team to support the organization's reporting needs.
● Participate in the development and maintenance of custom dashboards, reports, and visualizations using CRM and ERP data in PowerBI.
● Collaborate with Business Analysts and Business Intelligence Analysts in the creation of regular reports for the Strategy & Growth, Program Services, Business Development, Philanthropy and the Executive Teams. Respond to user requests for reporting.
● Participate in strategic planning for the organization's data architecture.
● Participate in the oversight and management of the organization's Data Governance initiatives.
● Ensure compliance with data privacy and security policies while handling CRM and ERP data.
● Manage access controls and data permissions to ensure appropriate access to sensitive information.
● Troubleshoot system issues and work with technical teams to resolve any data-related issues promptly.
About You
You are highly motivated, empathetic and client-focused with a strong desire to support our mission. You are seeking an opportunity that allows you to engage in continuous improvement and problem-solving in a team-oriented environment.
In addition, you meet the following requirements:
• Bachelor’s degree in Business Administration, Information Technology, Data Science, or a related field; Master’s degree is a plus.
• 3- 5 years of experience of Microsoft SQL Server, data management, specifically within CRM and ERP environments.
• Proven experience with CRM tools and ERP systems.
• Strong background in creating reports and dashboards using Power BI.
• Well organized, thorough and detail oriented.
• Proven ability to handle multiple priorities at the same time.
• Excellent interpersonal and communication skills.
• Strong business and technical writing skills.
• Excellent troubleshooting, technical/ creative problem-solving and analytical ability.
• Experience in data visualization and/or reporting tools, including PowerBI.