Senior Data Analyst (Sr. Marketing Business Intelligence Analyst)

$70,000 - $146,600/Yr

Delta Dental - San Francisco, CA

Full-time - Mid Level

San Francisco, CA

501-1,000 employees

Insurance Carriers and Related Activities

About the position

The Senior Data Analyst, also known as the Senior Marketing Business Intelligence Analyst, plays a crucial role in partnering with various stakeholders including business leaders, technology teams, product development, and marketing partners. This position is focused on identifying business challenges and formulating a comprehensive data plan to drive insights and develop actionable solutions. The successful candidate will leverage multiple data sources to execute complex data analyses, ultimately delivering quantifiable results that significantly impact the enterprise. In this role, the Senior Data Analyst will manage the requirements elicitation, analysis, and documentation processes to capture the needs of both the business and end users. They will prioritize these needs based on their business impact and drive analytics design decisions by collaborating with business teams to define a clear plan. The analyst will lead projects utilizing data mining and visualization techniques to uncover insights that guide strategic decisions and identify optimization opportunities. Additionally, the Senior Data Analyst will utilize programming languages to perform advanced data extraction, transformation, and management, ensuring that all source code and algorithms are well-documented for future use. They will act as an expert on business data, working closely with the Data Center of Excellence (COE) and technology teams to enhance data quality and consistency. The role also involves ensuring compliance with standards, policies, and processes in delivering data solutions, as well as collaborating with internal and external partners to resolve support-related questions and issues. The analyst will participate in presentations to stakeholders, effectively communicating key findings and recommendations to support data-driven decision-making. They will own the end-to-end solutioning for marketing database systems and applications, analyze current processes to identify potential problems, and discover new process improvement opportunities. Experience with Salesforce is also a key requirement for this position.

Responsibilities

• Performs data analysis, time series analysis, experimentation, and data visualization, responding to ad-hoc requests from business partners to identify and quantify opportunities and address specific questions to deliver business outcomes.
• Manages requirements elicitation, analysis, and documentation processes to capture business and end user needs, prioritizing needs within and across projects based on business impact.
• Drives analytics design decisions by taking relevant inputs from business teams and defining a clear plan.
• Leads projects using data mining and data visualization techniques to discover insights that will guide strategic decisions and uncover optimization opportunities.
• Utilizes programming language to perform advanced-level data extraction, transformation, and data management; fully documents and manages a library of source code and algorithms for future use.
• Acts as an expert on business data and works closely with Data COE and Technology team to improve data quality, data definition, and consistency.
• Collaborates with internal and external partners to resolve immediate support-related questions and issues.
• Provides team leadership and enterprise leadership across data domains.
• Participates in presentations to stakeholders, effectively communicating key findings and recommendations to support data-driven and evidence-based decision-making.
• Owns end-to-end solutioning for Marketing database systems and applications.
• Analyzes current processes and identifies existing or potential problems in order to discover new process improvement opportunities.

Requirements

• 5+ years professional experience with a Bachelor's degree.
• Strong experience in facilitating the discovery process with functional stakeholders to identify requirements and expected outcomes.
• Strong knowledge of data mining principles.
• Understanding of and experience using analytical concepts and statistical techniques: hypothesis development, designing tests/experiments, analyzing data, drawing conclusions, and developing actionable recommendations for business units.
• Excellent SQL and data warehouse skills, with experience writing complex queries on large data sets.
• Ability to build spreadsheet models and sort through complex data.
• Expertise with data visualization and dashboard tools such as Tableau, Looker, or equivalent.
• Experience manipulating data sets using programming skills in any language (Python, R, etc.).
• Excellent verbal/written communication skills, including the ability to communicate technical issues to non-technical audiences.
• Strong presentation skills, comfortable presenting to all levels of management.
• Ability to build strong working relationships with cross-functional teams.
• Solid planning, priority setting, and project management skills with experience managing multiple projects concurrently.
• A self-starter that adapts well to change in a fast-paced, dynamic workplace and works well in cross-functional teams/projects.
• A problem solver and planner with strong quality control, adaptability, and customer service skills.
• Ability to break down complex problems into pieces that can be solved with data, analysis, assumptions, and judgment.

Nice-to-haves

• Experience working with Salesforce.

Benefits

• Competitive base and incentive pay
• 401(k) with robust matching and non-matching contributions
• Rich medical & pharmacy benefits
• 100% employer-paid dental and vision benefits
• Holistic wellbeing program with deep financial incentives
• Generous paid time off plus 12 paid holidays and your birthday off
• Culture of growth and learning: career development; tuition reimbursement; recognition program
• Family support: adoption assistance, fertility treatment, child, elder & pet care assistance
• Social responsibility and volunteer opportunities
• Employee discount program