Station Finance Reporting & Solutions Coordinator
Our Organization CDP, a Boston-based public benefit corporation, uses the collaborative fundraising model to improve the operational efficiency and revenue generation capacity of the public media system. CDP currently provides more than 230 NPR and PBS public media organizations (PMOs) with outsourced marketing, data analytics, fundraising, and technology services. These services help PMOs raise more net income, grow their donor files faster, lower their fundraising costs, and free up development talent allowing stations to better focus on local engagement. Since its inception, CDP has delivered more than $1 billion in membership revenue for local PMOs participating in its services and has become the most widely adopted Public Media service in the history of public broadcasting. Just as CDP is committed to supporting public media organizations around the country, we are equally committed to supporting each of our team in their own professional development. For more information, visit www.cdpcommunity.org.
Position Overview The Station Finance Reporting & Solutions Coordinator will report to the Sr. Reporting & Solutions Manager and will assist in duties and projects related to data reconciliation, data warehouse reporting, expense reporting, budget development, among other tasks required to support the MSB services to our partner stations. This role requires SQL knowledge and comfort in data warehouse environments. In addition, a keen eye for detail and a ferocious devotion to accuracy in reporting are crucial, with an ability and ease in being the knowledgeable party in client and vendor interactions. The role will also demonstrate judgment to ask clarifying questions and the ability to share critical knowledge to identify and resolve outstanding issues.
This position involves meeting with internal and external stakeholders and will require a level of comfort and confidence with public speaking, as well as the ability to tailor their presentation style and content to the intended audience.
Priorities include, but are not limited to:
Snowflake Reporting & Data Efficiencies:
- Writing queries in Snowflake to find relevant data in support of reporting needs.
- Managing offline template updates by running existing queries in Snowflake.
- Assisting Sr. Reporting & Solutions Manager on Tableau Cloud projects.
- Collaborating with Sr. Reporting & Solutions Manager across miscellaneous data tasks and projects.
Station Expense Tracking:
- Collecting data from individual teams and stations to complete station Budget v. Actuals reports:
- Retrieve station expenses from station Teams folders.
- Verify station expense data against budget & historical expectations.
- Communicating with Client Services Representative & Station to resolve any expense accuracy concerns.
- Uploading station expenses in Excel to Tableau via Salesforce.
- Export reports and sharing with Client Services team.
- Track all steps accordingly.
Budgeting and Reforecasting:
- Analyze historical data.
- Prepare templates in Excel/budgeting tool.
- Collaborate with Marketing and Digital teams to assess projections for revenue areas.
- Prepare budget/reforecast drafts for station delivery.
- Participate and lead follow-up budget review meetings.
Operational Efficiency:
- Continually identify, propose, evaluate, and implement process improvements discovered via Station Finance activity as related to operational workflows, budget development, data hygiene, and client communication, etc.
Other duties as required, including but not limited to:
- Triaging Salesforce cases.
- Triaging station emails and collaborating closely with Client Services, Digital Marketing, Direct Mail Marketing to resolve queries.
Experience/Skills
- SQL knowledge required, other programming languages welcomed; 1-2 years of Analysis, Statistics, Data or related field, strongly preferred.
- Experience working with customers/clients; experience in forecasting and budgeting.
- Critically important to have experience and be at ease in holding client discussions.
- Salesforce or other CRM platform familiarity (cases and reporting).
- Strong Excel skills, with proficiency in basic formulas including variance formulas.
- Exacting attention to detail.
- Of critical importance: The successful hire will be collaborative, have a sense of humor, have demonstrable multitasking skills, and will be able to prioritize competing deadlines.
Educational Requirements
- Bachelor’s degree or higher in a finance-related field and/or equivalent work experience preferred.
Commitment to Inclusion We strongly encourage individuals from historically marginalized and underrepresented groups to apply, even if you don’t meet every qualification. We value diverse perspectives, lived experiences, and commitment to public service. All CDP people have unique talents and experiences that create our company culture where we can all thrive and bring our whole selves to work each day. Successful candidates will identify easily with a set of character attributes, as listed below:
- Inclusive mindset: You embrace and demonstrate an inclusion mindset and role model these behaviors for the organization.
- A Communicator: You possess strong communication skills and have great customer service skills; you like people and want to help.
- A Critical Thinker: You regularly look for ways to find efficiencies, innovate, and make improvements where you can.
- Process Oriented: You’re able to understand, work in, create, and improve processes.
- A Collaborator: You’re a team player willing to help where needed; a relationship builder whose can-do attitude inspires others; you actively share your job knowledge with team members.
- Someone Who Seeks to Learn: You are eager to listen, study, and learn new things quickly; you are resourceful and are open to regularly accepting and growing from feedback.
- Enterprising: You have proven success working in a fast-paced and changing environment; you have a strong work ethic and are excited to add value to the organization and its mission. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CDP is proud to be an equal opportunity workplace and employer. We are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, national origin, nationality, immigration status, citizenship, religion or religious creed (or belief, where acceptable), sex/gender, sexual orientation, gender identity and gender expression, pregnancy, marital status, age, citizenship, marital status, handicap or disability, genetic information or characteristics (or those of a family member), Veteran or military status, political belief, or socio-economic status. CDP does not discriminate against individuals on the basis of those characteristics or any other characteristic protected by law. CDP provides reasonable accommodations for applicants with a disability in completing job application procedures. Please notify CDP Human Resources in advance so necessary arrangements can be made. If you need assistance or accommodation