Senior Commercial Data Analyst

Malwarebytes

13d•$130,000 - $175,000•Hybrid

About The Position

Malwarebytes is seeking a collaborative, motivated, and skilled Senior Commercial Data Analyst to join their data and insights group, supporting Finance. The role ideally requires the candidate to be located in the Santa Clara, CA area and work a hybrid schedule (2 days per week). The ideal candidate possesses strong data analysis skills, including window functions and transformation frameworks, alongside an understanding of common financial KPIs. They should be adept at collaborating with Finance and Marketing/Retention teams in a multi-project environment. Experience with advanced SQL, the dbt Core framework (including advanced materialization options, incremental loads, and Jinja macros), and the Snowflake data cloud platform is essential. The ability to tune data models for optimal execution plans and warehouse usage, along with comfort in Git-based CI/CD workflows (including raising PRs), is also required. The candidate should be a proactive problem-solver with a continuous-learning, can-do attitude. This role is crucial for establishing a central hub for commercial data at Malwarebytes, involving data extraction from Snowflake, Power BI dashboard creation, and cross-functional partnerships with Retention/Marketing, Product, and Finance teams. Key projects include retention model updates, Annual Operating Plan (AOP) metric updates, modeling for price increase campaigns, and ARR model enhancements.

Requirements

Understanding of financial KPIs
Ability to work cross-functionally and manage multiple projects simultaneously
Advanced SQL, Power BI and basic DAX required
Hands-on experience with the dbt framework (dbt Core), including advanced materialization options, incremental loads, and Jinja macros
Familiarity and working exposure with Snowflake, including the ability to tune data model implementations to optimize the execution plan and warehouse usage
Experience building and publishing Power BI dashboards
Proficiency with Git-based processes and CI/CD workflows, including raising PRs against CI and pre-production schemas
Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, or a related field
4-6+ years of experience in analytics engineering, data analysis, or FP&A, preferably in a SaaS or consumer technology environment

Nice To Haves

Ideally located in the Santa Clara, CA area
Able to work a hybrid schedule 2 days per week
Understanding of common financial KPIs
Ability to collaborate with Finance and Marketing/Retention teams in a multiple-project environment
Think outside the box to solve business problems
Brings a continuous-learning, can-do attitude

Responsibilities

Translate business and executive requirements into curated financial and operational datasets
Build and maintain Power BI dashboards for company-wide consumption
Map business metrics to various eCommerce vendors and internal engineering data sources
Update revenue system configurations as a result of new product launches and bundle configuration changes
Run pre-production versus production data comparisons as part of CI/CD
Proactively monitor existing processes and investigate root cause in the event of failures
Partner cross-functionally with Retention/Marketing, Product, and Finance while managing multiple projects simultaneously