Job

Marketing Data Manager, Information Technology Services

Posted by
UJA-Federation of New York | New York, NY
Apply

UJA-Federation of New York


New
|
Published 10 days ago

About the Organization:

UJA-Federation of New York is the largest local philanthropy in the world. For more than 100 years, we’ve brought New Yorkers together to solve some of the most pressing problems facing our community. Thanks to our network of hundreds of non-profits, we can leverage our expertise across any number of areas — including health and human services, arts and culture, and education — to care for Jews everywhere and New Yorkers of all backgrounds, respond to crises close to home and far away, and shape our Jewish future. Our reach extends from New York to Israel to nearly 70 other countries around the world, touching 4.5 million people each year.

Position Summary:

Provide data management and reporting support for the direct marketing channels (direct mail, telegiving, and email/online). Manage data flows within and between the marketing department and its vendors or other departments. Coordinate with Information Technology Services (ITS) and Operations, Production, and Reporting (OPR) to ensure code and processes are in line with established standards. Expert knowledge of SQL for data manipulation and generation of lists and reports is required. Experience in SSRS and direct marketing and knowledge of Adobe Campaign are a plus.

Primary Responsibilities:

  • Program, execute, and manage list-pull operations and queue development for solicitation and cultivation campaigns for all direct channels (direct mail, telegiving, and email), with superior attention to detail.
  • Create, import, export, de-dupe, and transfer data files, interfacing with other departments and external vendors as necessary.
  • Use SQL and Excel to execute ad hoc queries; respond to Donor Center and fundraiser questions.
  • Contribute IT solutions to quality-control concerns.
  • Maintain a thorough understanding of all CRM data sources internal to the organization.
  • Manipulate and present data in an appropriate format, ensuring data integrity and quality of data prior to releasing.
  • Develop and maintain accurate and complete documentation of data extraction and report specifications and standards.

Competencies/Skills:

  • Expert knowledge of Microsoft SQL Server, with two plus years of experience writing and modifying complex queries in Microsoft SQL Server Management Studio (SSMS), including use of inner and outer joins, sub-queries, and stored procedures.
  • Strong understanding of CRM database structures as implemented in a relational database.
  • Intermediate to advanced knowledge of Microsoft Excel, including experience with Excel pivot tables and VLOOKUP formulas.
  • Experience developing, generating, and formatting custom datasets.
  • Knowledge of Windows environment essential.
  • Ability to communicate complex technical issues in terms clearly understood by technical and nontechnical audiences.
  • Ability to balance multiple activities and priorities while meeting deadlines.
  • Must be detail-oriented, organized, and able to work at a very high level of accuracy.
  • Analytical skills to independently diagnose and correct problems required.
  • Experience working in, or interest in learning, Adobe Campaign required.

Education and Experience:

  • B.S. in computer information systems or related field, or equivalent experience.

About the Organization:

UJA-Federation of New York is the largest local philanthropy in the world. For more than 100 years, we’ve brought New Yorkers together to solve some of the most pressing problems facing our community. Thanks to our…

Details at a glance

  • On-site Location
  • Full Time Schedule

How To Apply

How to Apply: Equal Opportunity Employment. Only qualified applicants will be contacted. Please submit your application directly to our job board at https://recruiting.ultipro.com/UNI1075UJAF

How to Apply: Equal Opportunity Employment. Only qualified applicants will be contacted. Please submit your application directly to our job board at https://recruiting.ultipro.com…

Location

130 East 59 Street, New York, NY 10022
Apply