Senior Data Analyst (Sr. Marketing Business Intelligence Analyst)

$70,000 - $146,600/Yr

Delta Dental - Oakland, CA

Full-time - Mid Level

Oakland, 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 business leaders, technology teams, product development, and marketing partners to identify business challenges and formulate effective data-driven solutions. This position requires a comprehensive understanding of data analysis and the ability to drive insights that will significantly impact the enterprise. The successful candidate will utilize multiple data sources to execute complex analyses and work collaboratively with both internal and external partners to achieve quantifiable results that align with the business objectives of Delta Dental. In this role, the Senior Data Analyst will be responsible for managing the requirements elicitation, analysis, and documentation processes to capture the needs of the business and end users. This includes prioritizing needs based on business impact and driving analytics design decisions by gathering relevant inputs from business teams. The analyst will lead projects that utilize data mining and visualization techniques to uncover insights that guide strategic decisions and identify optimization opportunities. The position also involves advanced-level data extraction, transformation, and management using programming languages, as well as ensuring data quality and consistency in collaboration with the Data Center of Excellence (COE) and Technology teams. The Senior Data Analyst will be expected to communicate effectively with stakeholders, presenting key findings and recommendations to support data-driven decision-making. Additionally, the role includes ownership of the end-to-end solutioning for marketing database systems and applications, analyzing current processes to identify potential improvements, and providing leadership across various data domains.

Responsibilities

• Performs data analysis, time series analysis, experimentation, and data visualization, responding to ad-hoc requests from business partners to identify and quantify opportunities.
• Manages requirements elicitation, analysis, and documentation processes to capture business and end user needs, prioritizing needs 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 languages 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 the Data COE and Technology team to improve data quality, definitions, 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 decision-making.
• Owns end-to-end solutioning for marketing database systems and applications.
• Analyzes current processes and identifies existing or potential problems to discover new process improvement opportunities.

Requirements

• 5+ years of 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