Assistant Manager, Membership Data Warehouse & Digital Marketing Support


About the USGA: 

The USGA conducts the U.S. Open, U.S. Women’s Open and U.S. Senior Open, as well as 10 national amateur championships, two state team championships and international matches. Together with The R&A, the USGA governs the game worldwide, jointly administering the Rules of Golf, Rules of Amateur Status, Equipment Standards and World Amateur Golf Rankings. The USGA’s working jurisdiction comprises the United States, its territories and Mexico.

The USGA is a global leader in the development and support of sustainable golf course management practices. It serves as a primary steward for the game’s history and funds an ongoing “For the Good of the Game” charitable giving program. Additionally, the USGA’s Course Rating and Handicap systems are used on six continents in more than 50 countries.

 


 

Location: 

Far Hills, NJ
 

Reports to: 

Assistant Director, Members
 

Position Summary: 

The Assistant Manager, Membership Data Warehouse and Digital Marketing Support is a hands-on, detail oriented professional that provides tactical execution and support for Membership initiatives involving strong technical or data-driven components.  S/He will support the Membership Analytics, Marketing and Operations teams through the development of queries and reports, data accuracy monitoring and investigation, monitoring and enhancing the Data Warehouse environment, and defining requirements, documentation, testing and deployment of digital marketing initiatives. 

 


Duties 

Digital Marketing Support:

  • Participate in the design, development and maintenance of a sustainable and manageable digital marketing/ecommerce environment and related business processes required to ensure efficient, accurate and timely development and execution of multi-channel marketing campaigns.
  • Working with the appropriate Membership, IT and vendor staff, elicit and understand business and marketing objectives for digital and integrated marketing campaigns, translate business objectives and requirements into functional requirements, and document, plan, and test digital marketing campaigns.  Define and document action plans and timelines, user experience flows, and functional requirements for landing pages, SQL queries, segmentation outputs, direct and vanity URLs, etc.  Define, document, communicate and coordinate testing and deployment plans, ensuring accurate and timely deployments.
  • For all initiatives, define and document action plans, timelines, roles and responsibilities; monitor progress to ensure deliverables and deadlines are met.

 

Data Warehouse Management and Operations Support:

  • Support the Membership Data Warehouse and Analytics Strategy by eliciting, understanding and documenting business and data requirements, and writing queries to extract and prepare data; develop and implement PowerPivot reports to support on-going and ad-hoc marketing analysis.
  • Working with the Membership Analytics Manager, document data accuracy rules for incoming data; develop and monitor data accuracy reports; work with appropriate Membership department staff to determine causes of invalid data and to develop and implement recommendations for short- and long- term correction. 
  • Audit and validate the Data Warehouse to ensure accuracy of data and related dimensions, measures, and reports.
  • Assist in the development and monitoring of business processes and programming necessary to capture and/or transfer timely and accurate marketing campaign and reference data to the Membership database and/or the Membership Data Warehouse as part of the monthly Campaign Management process.
  • Monitor Data Warehouse production processes to ensure that refreshes occur accurately, completely and on schedule.
  • Develop and maintain thorough documentation of the Data Warehouse including processes, schedules, procedures, databases, tables and fields.
  • Assist with requirements definition, documentation, design, quality control, and post-development maintenance of Data Warehouse enhancements.

 

  

Knowledge, Education, Skills & Abilities 

  • Bachelor’s degree preferred
  • 3 – 5 years experience in a digital marketing environment
  • Strong SQL development skills; Experience manipulating large datasets for analysis and reporting
  • MS Office proficiency, especially MS Excel and Visio; Excel 2010/PowerPivot and Tableau experience preferred;
  • Strong analytical and problem solving background; must have the ability to spot errors and inconsistencies, investigate causes, recommend solutions and follow through to implementation.
  • Must be extremely detailed to ensure thorough design, development and flawless execution of digital marketing campaigns
  • Strong project management skills
  • Good communication skills (verbal and written); ability to communicate effectively to both business and technical audiences


To Apply: 

 

Please click the following link: Assistant Manager, Membership Data Warehouse + Digital Marketing.