Marketing CRM Database Analyst

Employer
Duke University
Location
MARKETING ADMINISTRATION
Closing date
Oct 22, 2021

View more

Administrative Jobs
Institutional & Business Affairs, Communications & Marketing, Technology, Database Administration

Job Details


Marketing CRM Database Analyst

Job Code: 2426
FLSA: E
Job Level: D

Job Family: JF 08

**This is a Remote Opportunity employee can work remote from the following states: NC, CA, FL, GA, MD, NY, SC, TN, TX, VA, and DC.**

Purpose:

To provide support to the Duke University Health System (DUHS) and Duke Health System Marketing department in the new functionality design and maintenance of CRM (Salesforce and Salesforce Marketing Cloud) and related databases. To perform the compilation, analysis and reporting of consumer, referral and marketing information in the development and implementation of DUHS strategic plans and business decisions.

The Marketing CRM Database Analyst applies a systematic, disciplined, quantifiable approach for database management and CRM application development and configuration for the automated capture, transformation, and load of customer data from a variety of non-standardized sources and inputs.

Responsibilities Include

  1. Salesforce (Sales Cloud) administration tasks, meta-data management, environment management, data loading, the development of forms, web, and API-based application tasks.
  2. Salesforce Marketing Cloud (MC) management and configuration including administrative tasks, MC suite of applications expertise including journey building, extension configuration, and email performance analysis and optimization.
  3. SQL server data management tasks including importing, cleaning, transforming, and combining datasets, querying internal and external data sources, and computing business metrics.
  4. Manage technical projects completed by Salesforce vendors and partners, including Salesforce ticket opening and tracking to resolution, providing complete detailed requirements, delivered functionality assessment and testing, and milestone completion tracking and follow-up.

This position will be required to understand the fundamental structure of databases, have a natural ability to translate business user needs into efficient and effective database design, and have a working knowledge of programs used to manipulate, organize, and present data and information in a meaningful and informative manner. Further, this position requires the ability to interact with various levels of the organization in order to assist in the interpretation and use of that data.

Essential Skills

  • Ability to integrate multiple data sources (including Epic EMR data, Call Center data, external customer datasets, etc.) efficiently and on a large scale
  • Use relational database software (SQL Server) to design and troubleshoot complex SQL queries. Demonstrate the ability to create and use database functions to process unstructured data and/or perform geo-fencing computations.
  • In-depth working knowledge of Salesforce Sales Cloud and Marketing Cloud applications
  • Resourcefulness and self-sufficiency to research and resolve complex technical problems
  • Experience working as part of the database development team and business users team

Responsibilities:

  • Salesforce Sales Cloud and Marketing Cloud application administration, configuration, development, and maintenance
  • SQL Server database tasks including importing/exporting and querying data source

Minimum Qualifications

  • Bachelors in Information Systems, Business or Health Administration, or related field
  • 3+ years database management experience (SQL server preferred)
  • 3-5 years of Salesforce administrative and/or development experience (either Sales Cloud or Service Cloud or Health Cloud)
  • 1-2 years of Salesforce Marketing Cloud hands-on experience
  • Excellent verbal and written communication skills, including the ability to document and present reports suitable for audiences of all levels.
  • Advanced spreadsheet skills, with sound working knowledge of Microsoft business package to include PowerPoint, Access, Word, and Excel
  • Ability to work consultatively with business partners on problem definition
  • Experience managing vendors in the areas of Salesforce technical development
  • Knowledge of consumer product data gathering and analysis.

Required Qualifications at this Level

Education/Training

Refer to Job Description

Experience

N/A

Skills

N/A

Job Code: 00002426 ANALYST, IT, SR
Job Level: D

Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.

Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.

Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.

Organization

Read our Diversity Profile History

Duke University was created in 1924 by James Buchanan Duke as a memorial to his father, Washington Duke. The Dukes, a Durham family that built a worldwide financial empire in the manufacture of tobacco products and developed electricity production in the Carolinas, long had been interested in Trinity College. Trinity traced its roots to 1838 in nearby Randolph County when local Methodist and Quaker communities opened Union Institute. The school, then named Trinity College, moved to Durham in 1892, where Benjamin Newton Duke served as a primary benefactor and link with the Duke family until his death in 1929. In December 1924, the provisions of indenture by Benjamin’s brother, James B. Duke, created the family philanthropic foundation, The Duke Endowment, which provided for the expansion of Trinity College into Duke University.Duke Campus

As a result of the Duke gift, Trinity underwent both physical and academic expansion. The original Durham campus became known as East Campus when it was rebuilt in stately Georgian architecture. West Campus, Gothic in style and dominated by the soaring 210-foot tower of Duke Chapel, opened in 1930. East Campus served as home of the Woman's College of Duke University until 1972, when the men's and women's undergraduate colleges merged. Both men and women undergraduates now enroll in either the Trinity College of Arts & Sciences or the Pratt School of Engineering. In 1995, East Campus became the home for all first-year students.

Duke maintains a historic affiliation with the United Methodist Church.

Home of the Blue Devils, Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.

Mission Statement

Duke Science"James B. Duke's founding Indenture of Duke University directed the members of the University to 'provide real leadership in the educational world' by choosing individuals of 'outstanding character, ability, and vision' to serve as its officers, trustees and faculty; by carefully selecting students of 'character, determination and application;' and by pursuing those areas of teaching and scholarship that would 'most help to develop our resources, increase our wisdom, and promote human happiness.'

“To these ends, the mission of Duke University is to provide a superior liberal education to undergraduate students, attending not only to their intellectual growth but also to their development as adults committed to high ethical standards and full participation as leaders in their communities; to prepare future members of the learned professions for lives of skilled and ethical service by providing excellent graduate and professional education; to advance the frontiers of knowledge and contribute boldly to the international community of scholarship; to promote an intellectual environment built on a commitment to free and open inquiry; to help those who suffer, cure disease, and promote health, through sophisticated medical research and thoughtful patient care; to provide wide ranging educational opportunities, on and beyond our campuses, for traditional students, active professionals and life-long learners using the power of information technologies; and to promote a deep appreciation for the range of human difference and potential, a sense of the obligations and rewards of citizenship, and a commitment to learning, freedom and truth.Duke Meeting

 “By pursuing these objectives with vision and integrity, Duke University seeks to engage the mind, elevate the spirit, and stimulate the best effort of all who are associated with the University; to contribute in diverse ways to the local community, the state, the nation and the world; and to attain and maintain a place of real leadership in all that we do.”

Find Us
Location
US

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert