Senior Commercial Data Analyst
Malwarebytes Canada · $130K–$175K/yr
Computer and Network Security · 501-1,000 employees
About the role
The role involves translating business requirements into financial datasets and building Power BI dashboards for company-wide consumption. You will also partner cross-functionally with Finance, Marketing, and Product teams to support strategic initiatives and monitor data processes.
What they look for
Requirements
Candidates must have 4-6+ years of experience in analytics engineering or data analysis with advanced SQL and dbt framework skills. A bachelor's degree in a relevant field and proficiency with Snowflake and Git-based CI/CD workflows are required.
Benefits
Full description
Malwarebytes is looking for..
Malwarebytes is looking for a collaborative, motivated, and skilled individual (ideally located in the Santa Clara, CA area able to work a hybrid schedule 2 days per week) to join our data and insights group as a Senior Commercial Data Analyst supporting Finance.
We are looking for someone who has both strong data analysis skills, including window functions and transformation frameworks, as well as an understanding of common financial KPIs, and who is able to collaborate with Finance and Marketing/Retention teams in a multiple-project environment.
The ideal candidate has hands-on experience with advanced SQL and the dbt Core framework, including advanced materialization options, incremental loads, and Jinja macros. This position also requires an understanding of the Snowflake data cloud platform and the ability to tune data models to optimize execution plans and warehouse usage. You will also need to be comfortable with Git-based CI/CD workflows, including raising PRs against CI and pre-production schemas. The ideal candidate can work with business teams across the company, think outside the box to solve business problems, and brings a continuous-learning, can-do attitude.
This role is central to building an established, trusted home for all things commercial data at Malwarebytes: pulling data down from Snowflake, building Power BI dashboards for the company to consume, and partnering across Retention/Marketing, Product, and Finance. Below are examples of the projects and strategic initiatives this role will be aligned to:
- Retention model updates
- Annual Operating Plan (AOP) metric updates
- Modeling and support for price increase campaigns
- ARR model updates and enhancements
Compensation:
San Francisco Bay Area: $155 - 175K Annually
Region 2: $137 - $165K Annually
Region 3: $130 - 160K Annually
What You Will Do:
- 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
Skills You'll Need to Have:
- Understanding of financial KPIs and the ability to work cross-functionally and manage multiple projects simultaneously
- Advanced SQL, Power BI and basic DAX required
- Ideally have 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
Perks & Benefit:
- Comprehensive medical, dental, and vision insurance coverage
- Employee Referral Bonus Program
- Wellness programs
- 401k and employer matching for (US Employees)
- Comprehensive Time Off policy
- An opportunity to do something great for yourself and the world!
(Benefits and Perks subject to change by country/region)
Legal Language:
(US Employees Only)
Applicants have rights under the Federal Employment Laws:
- Employee Polygraph Protection Act
- Know Your Rights: Discrimination is Illegal
- Family and Medical Leave Act (FMLA)
This is to affirm our policy of providing equal employment opportunities to all employees and applicants for employment in accordance with all applicable laws and regulations.
Our company will not discriminate against or harass any employee or applicant for employment because of race, color, creed, religion, national origin, sex, sexual orientation, gender identity, disability, age, marital status, familial status, membership or activity in a local human rights commission, or status regarding public assistance. We will ensure that all our employment practices are free of discrimination. Such employment practices include, but are not limited to, the following: hiring, upgrading, demotion, transfer, recruitment or recruitment advertising, selection, layoff, disciplinary action, termination, rates of pay or other forms of compensation, and selection for training, including apprenticeship. We will provide reasonable accommodation to applicants and employees with disabilities whenever possible.
Similar roles
-
Data Analyst
DRW Montreal, Quebec, Canada
-
Research Data Analyst
Naughty Dog Santa Monica, California, United States · $108K–$135K/yr
-
Provider Data Analyst III
Medica Minnetonka, Minnesota, United States · $57K–$85K/yr
-
Data Analyst - Revenue Management
Public Storage Glendale, California, United States · $95K–$110K/yr
-
Data Analyst
ADAC Grand Rapids, Michigan, United States · $67K–$95K/yr
-
Performance and Data Analyst
CyberMedia Technologies Ashburn, Virginia, United States · $75K–$84K/yr