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
Remote WA
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
Remote CO
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
Remote CO
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
Denver, CO
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
Chicago, IL
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
Chicago, IL
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
Chicago, IL
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