MEGAN RYAN
Spokane,WA
Summary
Results-driving analyst and analytics engineer with 7 years of experience across analytics, professional services, and financial analysis. Seeking a position in advanced analytics to improve business performance through data-driven insights, collaborative working relationships, and relentless creativity in a fast-paced environment.
Overview
7
7
years of professional experience
Work History
Senior Analytics Engineer
Workiva
02.2024 - Current
- Utilize DBT to deploy certified datasets to be used across the organization, resulting in improved reporting accuracy, internal knowledge sharing, KPI definitions, and time to insight
- Serve as subject matter expert for widely used DBTs, data definitions, and executive level reporting
- Continuously work to improve data integrity, processes, and increase documentation both individually and by participating in data committees
Senior Insights & Analytics Analyst
Workiva
08.2023 - 02.2024
- Establish strong partnerships with internal stakeholders throughout the organization to develop strategy, provide guidance, define key metrics, and design solutions to solve critical data needs
- Streamline reporting procedures by creating user-friendly dashboards and deliverables for easy access to key performance indicators
- Identify trends and patterns in large datasets, leading to actionable insights for business growth
Insights & Analytics Analyst
Workiva
11.2021 - 08.2023
- Develop, maintain, and improve centralized analytics dashboards, leveraging business intelligence tools to promote visibility into metrics impacting the full lifecycle of customers, thereby informing decisions and accelerating growth
- Transform and interpret data from various source systems including Salesforce, Workday, OpenAir, and GainSight using complex Amazon Redshift SQL queries
- Validate results and perform quality assurance to assess accuracy of data
Graduate Student Consulting Project
Soona
05.2021 - 08.2021
- Individually consulted with a Denver startup company, combining quantitative insights with qualitative analyses to make recommendations to improve customer experience
- Utilized SPSS Modeler text mining analysis, regression modeling, and PowerBI to visualize findings.
Senior Financial Analyst
Packback
01.2019 - 08.2020
- Collaborated cross-functionally to increase trailing 12-month revenue fivefold between my start and end dates
- Designed a sell-through tracking process summarizing large volumes of transaction data to enable consistency and clarity in revenue reporting
- Streamlined monthly financial reporting including closing journal entries, budget analysis, and financial statement review, creating time to proactively promote financial health
- Developed a process to calculate bi-weekly revenue-based commission across forty sales reps
Revenue Analyst
Packback
02.2018 - 01.2019
- Prepared weekly data-driven analyses to advise the revenue management team on strategy and provided an objective review of risks, positive trends, and pacing towards goals
- Responsible for general Salesforce maintenance, including complete and accurate historical data, troubleshooting within the platform, training reps, and creating adaptive reports, call lists, and dashboards.
International Tax Associate
PricewaterhouseCoopers
01.2017 - 02.2018
- Advised multinational corporations on international tax related matters, including large corporate restructurings, by researching tax laws and preparing memos, presentations, and other relevant tax deliverables
- Supported clients' compliance with tax filing requirements by preparing and reviewing 5471s & 8858s.
Education
Master of Science in Business Analytics -
UNIVERSITY OF DENVER, DANIELS COLLEGE OF BUSINESS
08.2021
Bachelor's in Business Administration in Accounting, Spanish Minor Equivalent -
UNIVERSITY OF NOTRE DAME
05.2016
Skills
- Salesforce Admin Certified
- Tableau
- QuickSight
- Power BI
- Amazon Redshift
- SQL
- Python
- R
- SPSS Modeler
- Visio
- Visual Studio
- Workiva Wdesk and Wdata
Timeline
Senior Analytics Engineer
Workiva
02.2024 - Current
Senior Insights & Analytics Analyst
Workiva
08.2023 - 02.2024
Insights & Analytics Analyst
Workiva
11.2021 - 08.2023
Graduate Student Consulting Project
Soona
05.2021 - 08.2021
Senior Financial Analyst
Packback
01.2019 - 08.2020
Revenue Analyst
Packback
02.2018 - 01.2019
International Tax Associate
PricewaterhouseCoopers
01.2017 - 02.2018
Master of Science in Business Analytics -
UNIVERSITY OF DENVER, DANIELS COLLEGE OF BUSINESS
Bachelor's in Business Administration in Accounting, Spanish Minor Equivalent -
UNIVERSITY OF NOTRE DAME