Analyst, Platform & Enablement (Waterloo)

**_Role Overview:_** Job Description Summary We are seeking a Data Analyst to join the Analytics Architecture team within McAfeeu2019s Analytics Platform & Enablement organization. In this role you will build, validate, and maintain the analytical logic behind McAfeeu2019s most critical consumer business metrics u2014 retention rate, trial conversion, bookings, subscriber counts, and marketing effectiveness. You will work directly in Databricks writing SQL and Python to transform raw data into certified KPIs that drive decisions at the VP and C-level. This is a hands-on, high-output role. You will own end-to-end analysis cycles: receiving business questions from leadership, translating them into data logic, validating results against source-of-truth systems, and delivering findings that directly influence how McAfee measures and optimizes its subscription business. You will partner closely with Data Engineering, Finance, Marketing, and Product teams on a daily basis. This position reports to the Senior Manager of Analytics Architecture and works alongside 2u20133 peer analysts who collectively own the analytical foundations for McAfeeu2019s consumer business. This is a Hybrid Position located in either Waterloo or Toronto, Canada. We are only considering candidates within a commutable distance to either location. You will be required to be onsite on an as-needed basis; when not working onsite, you will work from your home office. **About the Role** Build and validate the data logic behind core business KPIs u2014 translating business definitions into certified analytical models across multiple dimensions. Perform end-to-end data reconciliation u2014 validating analytical datasets against finance and operational source-of-truth systems, investigating discrepancies, and ensuring accuracy of reported metrics. Conduct customer lifecycle analysis u2014 defining and measuring customer populations, segmenting behavior across acquisition, engagement, and renewal stages, and identifying drivers of key business outcomes. Build waterfall and funnel analyses u2014 decomposing aggregate metric movements into contributing factors, quantifying the impact of each, and presenting findings to leadership in a clear and actionable format. Build and maintain data models and transformation logic u2014 working in Databricks to create, migrate, and backfill analytical tables, validate data transformations, and ensure consistency between raw and curated data layers. Produce and maintain automated dashboards and reports u2014 building executive-facing visualizations that track business performance across multiple data sources with automated refresh pipelines. Conduct root cause analysis on metric anomalies u2014 investigating unexpected movements in KPIs, tracing issues through multiple data layers, and producing actionable findings for business stakeholders. Deliver ad-hoc analysis for senior leadership u2014 responding to executive requests with data-driven insights on topics such as customer sizing, audience segmentation, and business performance deep dives. Document data lineage and business logic u2014 mapping how metrics flow from source systems through transformation layers to final reporting, ensuring traceability and auditability of all certified KPIs. Collaborate cross-functionally with Data Engineering, Finance, and Data Stewards to certify data logic before it enters production reporting, and flag data quality issues proactively. **About You** You have 5+ years of experience in data analytics, business intelligence, or a related quantitative field. You have deep expertise in subscription or SaaS business metrics u2014 including retention rate, churn, auto-renewal, trial conversion, LTV, and bookings u2014 ideally in a consumer technology or eCommerce context. Data and coding fluency u2014 you are a self-starter comfortable using SQL, Python, and generative AI tools to access data and deliver analysis independently. You have hands-on experience with Databricks (SQL,Python, PySpark, Delta Lake) and can write, review, and troubleshoot complex analytical queries and data pipelines. You have experience with BI and reporting platforms u2014 particularly Power BI. You have experience with data validation and reconciliation u2014 comparing data across source systems, identifying discrepancies, and documenting business rules that govern metric calculations. You are comfortable performing root cause analysis u2014 diagnosing why a metric moved, tracing issues through multiple data layers, and presenting findings clearly to both technical and non-technical stakeholders. You can translate ambiguous business questions into structured analytical approaches u2014 scoping the data needed, defining assumptions, and delivering concise answers under time pressure. You have experience working in agile environments u2014 managing your own backlog across 2-week sprints, balancing recurring reporting with project work, and communicating progress and blockers proactively. \#LI-Hybrid **_Company Overview_** McAfee is a leader in personal security for consumers. Focused on protecting people, not just devices, McAfee consumer solutions adapt to usersu2019 needs in an always online world, empowering them to live securely through integrated, intuitive solutions that protects their families and communities with the right security at the right moment. **_Company Benefits and Perks:_** We work hard to embrace diversity and inclusion and encourage everyone at McAfee to bring their authentic selves to work every day. Weu2019re proud to be Outstanding Place to Worku00ae Certified in 10 countries, a reflection of the supportive, empowering environment weu2019ve built where people feel seen, valued, and energized to reach their full potential and thrive. We offer a variety of social programs, flexible work hours and family-friendly benefits to all of our employees. Bonus Program Pension and Retirement Plans Medical, Dental and Vision Coverage Paid Time Off Paid Parental Leave Support for Community Involvement We''re serious about our commitment to diversity which is why McAfee prohibits discrimination based on race, color, religion, gender, national origin, age, disability, veteran status, marital status, pregnancy, gender expression or identity, sexual orientation or any other legally protected status. The starting pay range for this position is $122,010.00-$165,070.00. McAfee takes into consideration an individualu2019s skillset, experience and location in making final salary determinations. For further details, please discuss with the Talent Acquisition Partner. Apply on Kit Job: kitjob.ca/job/2p0tix