SHSMD Career Center
New York, New York
Calhoun, Georgia
Fredericksburg, Virginia
Posted: 04-Mar-23
Location: Durham, North Carolina
Salary: Open
Categories:
Internal Number: 167034
Marketing Database Analyst, Senior
Job Code: 2426
FLSA: E
Job Level: D
Job Family: JF 08
**Visa Sponsorship is not available for this position.**
This position may have an opportunity to work remotely. All Duke University remote workers must reside in one of the following states or districts: Arizona; California; Florida; Georgia; Hawaii; Illinois; Maryland; Massachusetts; Montana; New Jersey; New York; North Carolina; Pennsylvania; South Carolina; Tennessee; Texas; Virginia or Washington, DC.
Purpose:
In this role, you will compile, analyze, and report on consumer, referral and marketing data to support the development and implementation of Duke University Health System strategic marketing plans and business decisions. As a key member of the Duke Health Marketing team, you will lead the new functionality design and maintenance of the marketing CRM (Salesforce and Salesforce Marketing Cloud) and related databases.
The successful candidate will have experience designing a systematic, disciplined, quantifiable approach for database management and configuration for the automated capture, transformation, and load of customer data from a variety of non-standardized sources and inputs.
Responsibilities Include
- SQL server data management tasks including importing, cleaning, transforming, and combining datasets, querying internal and external data sources, and computing business metrics.
- Salesforce (Sales Cloud) administration tasks, meta-data management, environment management, data loading, the development of forms, web, and API-based application tasks.
- 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.
- Project management of contracted work, 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. While Salesforce experience is preferred, job training can be provided.
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.
- 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:
- SQL Server database tasks including importing/exporting and querying data source
- Salesforce Sales Cloud and Marketing Cloud application administration, configuration, development, and maintenance
Preferred Qualifications at this Level
Experience: 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
Experience managing vendors in the areas of Salesforce technical development
Minimum/Required Qualifications
Education: Bachelors in Information Systems, Business or Health Administration, or related field
Experience: 3+ years database management experience (SQL server preferred).
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
Knowledge of consumer product data gathering and analysis.
Education/Training
Refer to Job Description
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.
