Meals on Wheels America is seeking a Data Coordinator to support critical daily processes that uphold the organizations data infrastructure and enable business intelligence for strategic decision making for funding, advocacy, digital marketing, and Member engagement. This is an incredible opportunity to gain experience in supporting databases, data transformations, system integrations, and data analysis and have impact on the wellbeing of Americaís homebound seniors.
Reporting to the Senior Manager, Data Management, the Data Coordinator will be responsible for maintaining the data processes that support the Associationís infrastructure and will be the primary subject matter expert of what and how information flows between systems at the Association, ensuring data integrity and credibility for decision making.
Duties and Responsibilities
Maintain data integrations between the Association Management System and ancillary systems and resolve discrepancies daily
Ensure AMS and CRM database integrity by querying, evaluating, and merging duplicate records
Export, transform, import large datasets at planned cadences that enable Membersí and Supportersí personalized journeys with Meals on Wheels America, monitoring discrepancies in outputs, resolving or escalating issues as they arise (i.e., email segmentation process)
Export, transform, import large datasets at planned cadences that enable revenue reconciliation between finance systems and other source systems, monitoring, resolving, or escalating output discrepancies as they arise
Maintain external data sources and reference tables to ensure reports are utilizing most current data available (US Zip Code database, Census data, etc.)
Assist with custom query building and ad-hoc list pulls
Create SOPs and instructional documentation on processes and provide training to staff as needed
Perform other related duties as assigned
Qualifications & Requirements Bachelorís degree with relevant coursework or 1 or more year(s) related work experience or equivalent relevant experience and education.
Knowledge of SQL querying, Microsoft Excel, and Tableau highly preferred
Ability to learn/adopt new tools quickly
Curious mind and investigative approach
Critical thinker with strong logic and problem-solving skills
Self-motivated and proactive with a can-do attitude
Keen eye for details
Organized with good time management
Ability to clearly communicate issues, causes, and findings
Commitment to the cultural values of Meals on Wheels America (including Racial Equity, Diversity, and Inclusion)
Please consider applying if you meet 75% of the qualifications.††
Meals on Wheels America is an inclusive workforce/employer and encourages applications from qualified persons of every race, ethnicity, national origin, religion, sex, age, veteran status, sexual orientation, and disability.
Meals on Wheels America is the leadership organization supporting the more than 5,000 community-based programs across the country that are dedicated to addressing senior isolation and hunger. This network serves virtually every community in America and, along with more than two million staff and volunteers, delivers the nutritious meals, friendly visits and safety checks that enable Americaís seniors to live nourished lives with independence and dignity. By providing funding, leadership, education, research and advocacy support, Meals on Wheels America empowers its local member programs to strengthen their communities, one senior at a time.