Mariel Marcano
Sr. Data Analyst
Seattle,WA
Summary
Highly motivated and advanced senior data analyst with strong analytical skills for the past 8 years. Enjoy automating business processes and data manipulation while also providing insights and building business models. Passionate about visualizing data and storytelling
Overview
7
7
years of professional experience
5
5
years of post-secondary education
1
1
Certification
2
2
Languages
Work History
Sr. Data Analyst, Finance and RevOps
Clari
08.2022 - Current
- Built an ARR model in dbt using SQL and Python to calculate churn, contraction, new logo, expansion, and contract increase/decrease using Salesforce subscription and opportunity data in Snowflake, reducing 95% of manual calculation in Excel, and increasing ad-hoc analysis across GTM departments.
- Provided analysis of opportunity conversation rates and product usage for the sales team, which was used for a marketing campaign and generated a 5% increase in leads driven to webinars.
- Implemented Salesforce CPQ with RevOps, Order Management, Business Systems departments, and an external consulting firm, and was responsible for mapping and documenting fields, updating SFDC and Snowflake formulas, consulting on ARR calculation best practices, and formatting subscriptions, quote lines, and opportunities in SFDC.
- Worked with Order Management, RevOps, Business Systems, and an external consulting firm on Salesforce instance migration after an acquisition. Worked on reducing data redundancy and inconsistency in Salesforce UAT and Snowflake datamarts before migrating to the production instance, improving data accuracy for downstream reporting.
- Prepared analysis and provided insights on post-sales metrics for executive staff meetings, such as renewal retention rate, monthly active users, product arr by event types, and more.
- Built Top 20 KPI metrics for the company dashboard in Tableau by collaborating with executive staff members across the company and agreeing on definitions and terms.
Sr.Data Analyst, Customer Success
Auth0/Okta
11.2021 - 08.2022
- Worked closely with VP, Revenue Strategy, and Customer Success leadership team to evolve core go-to-market strategy and execute CS reporting and analytics roadmap.
- Collaborated with CS leadership on building a Customer Success Scorecard dashboard in tableau showing KPI metrics. It is the most viewed dashboard in Customer Org, with 5,065 views in less than a year.
- Owned ad hoc and ongoing data exploration projects digging into professional services, adoption trends, NPS scores, and much more.
- Responsible for communicating with Auth0's Customer First leaders about changes, updates, and processes during the Auth0/Okta integration and consulting best approaches.
- Built accurate and detailed dashboards for CS leadership to understand trends, performance metrics, and areas of opportunity within their respective businesses.
Data Analyst
Auth0
10.2019 - 11.2021
- Built the GTM dashboard and automated processes through Google API via Python, reducing 10% maintenance monthly.
- Identified trends and work with marketing and sales to determine root causes and recommend actions by visualization leads to qualified opportunities conversion, net retention rate, and much more.
- Mentored team members by providing best practices in Tableau and understanding the foundation of the GTM dashboards.
- Provided ad-hoc analysis requested by GTM leadership by meeting SLA and received positive customer satisfaction.
Marketing Analyst
Optime Consulting
10.2017 - 09.2019
- Created, modified, and automated reports using MySQL and transform raw data into meaningful information.
operation and customer service. - Worked on creating a complex ETL to feed a user interface gaming platform under a strict deadline for a Fortune 500 company.
- Managed a team on date cleansing incoming sales leads and making necessary adjustments to the ETL.
Education
MBA - Business Intelligence
Nova Southeastern University
Davie, FL 01.2017 - 12.2018
BBA - Human Resources Management
Florida International University
Miami, FL 08.2012 - 12.2015
Skills
SQL
Python
Jinja
Snowflake
AWS Redshift
Dbt cloud
Tableau
Looker
Thoughtspot
Fivetran
Salesforce
GitHub
Confluence
Google Sheets
Excel
Certification
Tableau Desktop Certified Associate
Timeline
Sr. Data Analyst, Finance and RevOps
Clari
08.2022 - Current
Sr.Data Analyst, Customer Success
Auth0/Okta
11.2021 - 08.2022
Tableau Desktop Certified Associate
07-2021
Data Analyst
Auth0
10.2019 - 11.2021
Marketing Analyst
Optime Consulting
10.2017 - 09.2019
MBA - Business Intelligence
Nova Southeastern University
01.2017 - 12.2018
BBA - Human Resources Management
Florida International University
08.2012 - 12.2015
Similar Profiles
Rohit UppalapatiRohit Uppalapati
Software Engineer - Platform Engineering at ClariSoftware Engineer - Platform Engineering at Clari
Elena RimskayaElena Rimskaya
Sr. SDET at ClariSr. SDET at Clari
Mayank ChauhanMayank Chauhan
Lead Software Engineer at ClariLead Software Engineer at Clari
Michael BradfordMichael Bradford
Delivery Courier at Uber EatsDelivery Courier at Uber Eats
Becks DeVriesBecks DeVries
Senior Social Strategist - Jordan | @jumpman23 at KinessoSenior Social Strategist - Jordan | @jumpman23 at Kinesso