Senior Marketing Data Analyst

Location: 560 Mission Street, 13th Floor, San Francisco, CA 94105. Must appear in office 2 days per week; work from home permitted 3 days per week.

Salary: $74,000 - $170,900 /year

Job Description: 

• Partner with business leaders, staff clinicians, utilization management, network development, provider services, product development and marketing departments to identify business challenges, formulate a data plan, drive the insights and develop solutions to enable the business teams to perform at the highest levels. 
• Execute complex data analysis, using multiple data sources, to achieve quantifiable results that will impact either business units or enterprise business processes. 
• Provide support to our Segment Strategy, Integrated Marketing, Sales, Network Development, and Product Strategy teams by: identifying growth opportunities, evaluating market opportunities, assessing business performance, and conducting predictive analytics. 
• Manage end to end analytics project planning, execution, testing, and insights delivery to foster data-driven decision making by analyzing Enrollment Provider. 
• Research and analyze market data, sales activity, network depth and breadth, network financial, and segment performance trends to identify and help business focus on most promising growth opportunities. 
• Lead projects end to end by identifying approach, developing project plans, designing data solutions, conducting data analyses, and presenting insights to stakeholders. 
• Serves as a key member of cross functional growth teams providing these teams with data driven insights that lead to improved customer experiences and business performance. 
• Manage requirements elicitation, analysis, and documentation processes to capture end user needs. 
• Drive analytics design decisions by taking relevant inputs from business teams and defining clear plan for analysis. 
• Ensure validity of all data loaded into data systems by identifying and establishing appropriate business rules, KPIs and validation criteria. 
• Design and develop data pipelines and solutions in ETL tools, SQL procedures, and Python Scripts for Salesforce, Adobe Campaign, Call Center, Financial, external firmographic and economic datasets. 
• Creates reports and analyzes data to identify solutions that meet business goals. 
• Must appear in office 2 days per week; work from home permitted 3 days per week.

Requirements: 

• Bachelor’s degree or foreign degree equivalent in Statistics, Engineering, Analytics or other quantitative fields and four (4) years of experience in the job offered or related role. Alternatively, master’s degree or foreign degree equivalent in Statistics, Engineering, Analytics or other quantitative fields and two (2) years of experience in the job offered or related role. Employer will accept any combination of education and experience.

Experience and/or education must include: 

1. SQL to transform, analyze and extract data from large, disparate data sources including databases, external data sources, flat files, etc. 
2. SQL and Alteryx to prepare data for analysis in a methodical and repeatable manner and to leverage statistical concepts and methodologies to determine relationships and trends in datasets relevant to established analysis goals;
3. Designing and building Tableau dashboards to visualize and report on trends and relationships in our data;
4. Data querying from data warehouses, data analytics, and developing and communicating insights for analyses;
5. Applying statistics including hypothesis testing, experiment design, regression, clustering and principal component analysis;
6. Applying data analytics and statistical analysis methods for the purpose of driving marketing strategy in a direct-to-consumer or e-commerce environment;
7. Managing requirements elicitation, analysis, and documentation processes to capture stakeholder needs; and
8. Developing effective and concise written reports and presenting on them to senior level stakeholders to communicate key findings and recommendations to support data driven and evidence-based decision making.

CONTACT: Reference job # 5387089 and send resume to DDTA@delta.org.

Base Pay Information

The national base pay range at the end is a good-faith estimate of what Delta Dental may pay for new hires. Actual pay may vary based on Delta Dental’s assessment of the candidate’s knowledge, skills, abilities (KSAs), related experience, education, certifications and ability to meet required minimum job qualifications. Other factors impacting pay include prevailing wages in the work location and internal equity. $74,000 - $170,900 /year