Analytics Engineer - BT EnablementKey Responsibilities:* Partner with cross-functional stakeholders to design and develop processes, data integrations, and decision-making tools* Work with specific business applications, data pipelines, data warehouses, data modeling layers, and business intelligence tools* Partner closely with IT leaders, other data practitioners, and key stakeholders to implement a robust data systems strategy and scalable analytics solutionsTasks:* Work with business stakeholders to design & develop cross-functional processes, utilizing data integrations and transformation to enhance organizational capabilities. * Approach a variety of manual processes with a consistent eye for automation, standardization, and measurability. * Contribute to development and effective use of Abnormal’s data systems* Transform raw data into consumable datasets with key business logic implemented* Improve data infrastructure and governance through process definition, standards, and documentation* Ensure data quality by implementing re-usable data quality frameworks* Support growth on the team and across other teams via feedback and mentoring* Facilitate other ad hoc requests as neededStart date: Monday Sept 30th 2024

Data Analysis and Automation: * Data-Driven Insights: Extracted, transformed, and analyzed attendance and feedback data for global enablement initiatives, providing actionable insights for sales teams, leadership, and the CEO.* Process Optimization: Automated time-consuming processes using tools like SQL, Snowflake, and Tableau, significantly improving efficiency and accuracy.* Conference Analytics: Analyzed data for Okta's largest conference, including attendance, session data, and survey responses, to inform strategic decision-making and measure impact.* Salesforce Dashboards: Created and maintained Salesforce dashboards to track the impact of the SKO conference and provide valuable insights to leadership.* Post-Conference Analysis: Conducted in-depth analysis of workshop data to assess the effectiveness of post-conference initiatives and support sales success.Project Management and Collaboration* New Hire Onboarding: Developed and managed projects to increase visibility of Sales Enablement initiatives for new hires, ensuring successful onboarding and training.* Dashboard Development: Created and maintained Tableau dashboards to provide leaders with clear and actionable insights into the effectiveness of various workshops.* Data Engineering Partnerships: Collaborated with engineers to develop Snowflake models, streamlining data integration and reporting processes.* Subject Matter Expert: Became the go-to person for analytics questions related to initiatives, systems, processes, and ad-hoc requests.* Process Improvement: Led initiatives to streamline processes and improve efficiency across the organization.Technical Skills and Soft Skills* Technical Proficiency: Demonstrated expertise in tools such as SQL, Snowflake, Python, Salesforce, Tableau, and Tableau Prep Flows.* Soft

* Responsible for the products: Report Writer, Discovery Boards, Dashboards, Scorecards, and OfficeConnect, created KPIs.* Optimized business processes, query execution, and performance of all the products above: Cleaned & maintained data for all the products, optimizing the time that stakeholders, product managers, product owners, engineering, finance & everyone involved in those products took previously to understand how our customers use our products* Created more than 20 analytical dashboards using tools such as Python, R, ggplot2, and SQL extraction, which were utilized by cross-functional teams to make data-driven decisions.* Started & Maintained a project called Clean Your Room which consisted in checking all the data that each Analytics department shared with all customers and seeing how we can optimize the authoring experience of customers while using Report Writer, resulting in an uptake of the data and optimizing the processes that internal departments had* Earned the Outstanding Contributor Award for the Migration Project, which was an analysis done to be able to understand if a migration tool was necessary and see what tools were ready to be migrated, resulting in the allocation of resources in a better direction than originally planned based on data-driven decisions, saving time and money to the company and organization.* Created & maintained the guidelines that product managers and engineering used to keep track of the features that they develop, resulting in being able to track usage metrics of each product & feature on time and have created a dashboard that keeps track of all these metrics so anyone in the company can see which step the feature instrumentation is.* Created a monthly Know-your-product presentation in which I talked to stakeholders to share insights from the data such as monthly active users, and product/feature usage, and provided feedback on what needs to be changed based on the datastart to end: Feb 10th 2020 to may 1st 2023

* Enabled the Analytics organization to make succesfull business decisions bases on data.* Delivered monthly presentations to multiple levels of stakeholders based on data to tell stories of how customers use our products* Partnered with inbound and outbound principal product managers to gather insights that enabled product owners to prioritize feature enhancements and develpment* Created and maintained Products and Features usage metrics and adoption such as Monthly/Weekly/Daily active users, Stickiness Ratio, Normalized metrics, Continuous Customer Usage, Top & Bottom customers using the product* Go-to person for sharing insights of 5 analytical products including Workday's Analytics & Reporting and Financial Products.* Created and maintained analytical and ad-hoc dashboards that increased the productivity time of program managers who used to rely on creating queries or analyzing data in excel alone* Leveraged tools such as dashboard creating, python, sql, excel, Prism Analytics, Analytics and Reporting, and worked with folks across the Analytics organization and across Workday* LatinX Leader for internal events such as NHHM* LGBTQ+ Member, participatedDeliver effective presentations of findings and recommendations to multiple levels of stakeholders, creating visual displays of quantitative information.Collaborate with cross-functional stakeholders to formulate and complete full cycle analysis that includes data gathering, analysis, ongoing scaled deliverables and presentations.Analyzes complex business problems and issues using data from internal and external sources to provide insight to decision-makers, develop business intelligence, optimize effectiveness and/or predict business outcomes. Identifies and interprets trends and patterns in datasets to locate influences. Constructs forecasts, recommendations and strategic/tactical plans based on business data and market knowledge.Typically uses dedicated high end business intelligence applications.

Enabled analytical insights and data driven decisions to the organization sharing what the data is saying and helping PMs with what is most important to focus on. Analyzing usage and adoption metrics of various Enterprise Analytics and Reporting tools such as Workday's Report Writer and one of our newest products: Discovery Boards. Insights helped PMs to develop new functionalities for the products as well as see what customers love. Duties/Responsibilities and skills that I developed for this role are but not limited to:- Cleaned, Prepared and Analyzed high volumes of data to then create analytical dashboards to better visualize the data and help PMs to get insights faster and easier.- Developed a monthly insights page which contains the highlights of products in order to facilitate the way of sharing the data and insights and we can have an archive of the insights of every month.- Presented insights of products to leadership in the organization which includes but are not limited to GM, VP, SM, Directos, Data Scientists, etc.- Created reports and datasources to better understand and display the data in dashboards.- Contributed to different projects that required the use of Python to analyze and prepare the data.- Skills & Tools: Dashboards, SQL, Python, Excel, Data Driven Decisions, Prism Analytics, Discovery Boards, Report Writer, Financial Analytics, Presentation tools.

Update: Working with Workday’s Prism Analytics and Discovery boards to analyze large amounts of data, making graphs, adding filters, and finding improvements and bugs in those new tools. Also created datasets based on different datasources.Gathered information about the usage of different type of reports that Workday delivers to all of their customers, understanding what the number says showing the results in pivot tables, filtering and adding related information to more than 2K report, and more than 30K data rows.Gained skills on:- Working with Sr. Directors, Sr. Product Managers, Managers, Vice Presidents, Data Analysts, with more than 10 years of experience in the industry- Prism Analytics- Discovery Boards / Data Discovery- Report Writing- Hive SQL- Goku Notebooks / Flow- Internal tools which require writing SQL- Confluence- Jira- Advanced excel skills (vlookup, pivot tables, graphs, conditional formulas)- Zoom

* Facilitated weekly computer classes for senior citizens, to improve their internet and Microsoft Officeskills, leading to the receipt of an IC3 certificate* Instructed 10 ESL students of various ethnic backgrounds and age, weekly, resulting in an increasedunderstanding of English language and mechanics

* Successfully helped 100 customers daily serving healthy food to people from all around the worldassuring customer satisfaction* Create and organize the weekly working schedule using Libre Office in order to achieve employees fullunderstanding of their working days and hours* Onboard employees for 2 weeks to ensure that they gained the knowledge and skills needed toeffectively perform their roles and responsibilities