Mackenzie Porupsky
Analytics Engineer
Nashville,TN
Summary
Dynamic analytics professional with a proven track record, excelling in business intelligence, and cross-functional team collaboration. Proficient in SQL and dbt, I successfully led a global reporting migration project, enhancing accessibility and decision-making through impactful reports. Passionate about process improvement and delivering actionable insights to drive business growth.
Overview
5
5
years of professional experience
Work History
Sr. Manager, Analytics Engineer
BMG
Nashville
08.2023 - Current
- Compiled, analyzed, provided, and presented data solutions for new applications and business logic, utilizing modeling in dbt and Looker.
- Directed legacy reporting migration project for global analytics engineering team, ensuring accessibility of all business-critical reporting to global teams.
- Designed collection of engaging, pertinent dashboards supporting A&R team to extract crucial insights for effective decision-making.
- Guided business users in adopting new tools and coordinated with team to discuss requirements and new opportunities.
- Fulfill ad-hoc requests from business users concerning new reporting, bug fixes, and enhanced features.
Operations Sr. Analyst
Goldman Sachs
Salt Lake City
07.2021 - 07.2023
- Collaborated with upper management and cross-functional teams to define business requirements and deliver data testing for displaying daily and historical metrics to enhance efficiency and productivity.
- Managed daily payment settlement and reconciliation before market close, focusing on fraud detection and manual error identification.
- Designated by leadership as team liaison on working group to chart process flows, assess areas of risk and opportunity, and develop new metric tracking.
- Swiftly attained subject matter proficiency across a range of products and conducted numerous training sessions to convey insights and enhance team education.
Regional Marketing Intern
Pegasystems
Waltham
06.2020 - 12.2020
- Delivered campaign insights for seven individual accounts to enhance engagement and foster growth.
- Developed marketing and engagement benchmark reports for communications and consumer services industries.
- Implemented biweekly industry newsletters for sales teams to leverage in strategic planning.
- Worked alongside 12 interns in summer competition to design UI mockup for company intern portal.
Education
BS in Business Administration - Business Intelligence & Analytics And Marketing
Creighton University
Omaha, NE05-2021
Skills
- Business intelligence
- Cross-functional team coordination
- Process improvement
- Project management
- Problem solving
- SQL, dbt, git, Python, Looker, Jira, Confluence
Timeline
Sr. Manager, Analytics Engineer
BMG
08.2023 - Current
Operations Sr. Analyst
Goldman Sachs
07.2021 - 07.2023
Regional Marketing Intern
Pegasystems
06.2020 - 12.2020
BS in Business Administration - Business Intelligence & Analytics And Marketing
Creighton University
Similar Profiles
Michael MaloshMichael Malosh
Estimator at BMGEstimator at BMG
CRYSTAL KHALEKCRYSTAL KHALEK
Bookkeeping Assistant at BMGBookkeeping Assistant at BMG
Mohamed FayedMohamed Fayed
Success Manager at BMGSuccess Manager at BMG
Lydia AbsarLydia Absar
Overnight Kitchen Production Manager at Five Daughters BakeryOvernight Kitchen Production Manager at Five Daughters Bakery
Caroline UppCaroline Upp
Commercial Account Manager at Dell TechnologiesCommercial Account Manager at Dell Technologies