Stephanie Hertl

As a data analytics leader with expertise digital marketing intelligence, I excel in data automation, business analytics, and strategic planning to drive impactful marketing campaigns. I lead initiatives that transform complex data sets into revenue-driven insights, enhancing organization efficiency and performance.

Associate Director, Data Operations

• WebMechanix, A Level Agency
• 8/2023 ‑ Present
• Columbia, Maryland, United States
• Full-time

1. Scaled technical onboarding (dbt/GitHub) for 70+ new clients annually, netting +25% growth.
2. Shifted data warehouse configuration to pre-sale, speeding client delivery 86% (14 to 2 days).
3. Oversaw 60+ client migrations, documenting DPAs, InfoSec, and Master Service Agreements.
4. Engineered SQL-based CRM record URLs for secure record access without PII exposure.
5. Documented API extraction names for core data, cutting analyst onboarding time by 40%.
6. Enabled CRM data via SFTP, Supermetrics, Meltano, and Funnel.io for adaptable analysis.

• WebMechanix, A Level Agency
• 7/2022 ‑ 8/2023
• Columbia, Maryland, United States
• Full-time

1. Oversaw marketing data pipeline transformation for over 45 media and account managers.
2. Built executive report integrating $3M in spend and setting KPI benchmarks for 50+ accounts.
3. Leveraged SQL, regex, and case logic in BigQuery/BI tools to tailor high data volume clients.
4. Unified syntax, casing, and spacing logic to ensure 99% data integrity across environments.
5. Modeled multi-year data to forecast KPI trends with 90% accuracy on monthly goal targets.
6. Negotiated ETL software consolidation with vendor contacts, saving 20% in annual tool cost.

• WebMechanix, A Level Agency
• 10/2021 ‑ 7/2022
• Columbia, Maryland, United States
• Full-time

1. Managed analytics across 40+ clients, implementing reporting and attribution frameworks.
2. Automated multi-channel BI dashboards, accelerating stakeholder analysis time by 20%
3. Engineered data flows for campaigns and audiences, delivering precise marketing insights.
4. Implemented API authentication software automating reports, saving analysts 5 hrs per week.
5. Partnered with IT and operations to automate data ingestion, improving refresh rates 30%.
6. Consolidated KPIs across 3 departments, standardizing definitions to reach 98% accuracy.

• WebMechanix, A Level Agency
• 9/2017 ‑ 10/2021
• Columbia, Maryland, United States
• Full-time

1. Designed workflows routing CSVs into live sheets, cutting 25 hrs/month of manual work.
2. Conducted query analyses revealing retention drivers, driving 2-3X conversion rate gains.
3. Configured CRM workflows to refresh spreadsheets, ensuring updated client metrics.
4. Utilized Excel formulas to transform client datasets, improving reporting accuracy and access.
5. Delivered monthly data briefings guiding budget realignment, improving allocation by 15%.
6. Standardized parameter values across 15 data sources, cutting reporting discrepancies 25%.

• Dalai Group
• 6/2016 ‑ 7/2017
• Towson, Maryland, United States
• Full-time

1. Developed 25 promo, 12 service, 8 category pages, and 4 case studies to rebrand website.
2. Created 10 short keyword videos, deploying content through the Vzzar hosting platform.
3. Contributed to the content strategy and optimization plan for a major client in Maryland.
4. Translated, revised, and rewrote 200+ Spanish link building comments for company keywords.

• Dalai Group
• 2/2016 ‑ 6/2016
• Towson, Maryland, United States
• Full-time

1. Installed 50+ header images with responsive code, call-to-actions, and design software.
2. Assisted in the development and execution of digital marketing campaigns.
3. Analyzed campaign performance and provided insights for optimization.
4. Created and managed content for social media and digital marketing initiatives.

Johns Hopkins University (2017 - 2022)

• Master's Degree: Liberal Arts

• Bachelor's Degree: Mass Communication & English
• Minor: Creative Writing