Tim Vogel
Canton,MA
Summary
Senior Analytics Engineer with extensive experience in data modeling and visualization, currently contracting at Glossier. Extensive experience curating impactful dashboards and transforming complex datasets into actionable insights, enhancing data-driven decision-making across teams. Proficient in ETL processes and SQL querying, with a strong ability to collaborate and manage projects in fast-paced environments.
Overview
11
11
years of professional experience
Work History
Senior Analytics Engineer
Glossier
Boston, MA
12.2024 - Current
- Built ETL jobs for extracting data from various sources such as databases, APIs, and flat files.
- Developed custom visualizations that enabled better understanding of complex datasets.
- Troubleshot issues with existing analytics solutions while ensuring minimal disruption in service availability.
- Analyzed large datasets to identify trends and patterns in data.
- Collaborated with product teams to define requirements for new analytics features.
Data Analyst
Rhino
Boston, USA
11.2023 - 11.2024
- Collaborated with product, finance, sales, and marketing to ensure comprehensive and accurate data alignment with business needs.
- Maintained ETL and warehouse tooling (dbt, Stitch, Fivetran, BigQuery) for effective tracking of key performance indicators.
- Created data visualization dashboards using Tableau/Retool to enable business performance tracking and trend identification.
- Developed a data dictionary to enhance data fluency and reduce ad-hoc data requests across the organization.
Data Analyst
LinkSquares
Boston, USA
10.2022 - 08.2023
- Established new data sources for reporting and analysis to support marketing team.
- Developed and maintained innovative data models using dbt, Fivetran, Hightouch, and Snowflake.
- Created reporting dashboards in Looker to assist marketing and build teams.
- Identified unique analytical opportunities to enable data-driven decision-making.
- Set expectations with cross-functional stakeholders to ensure alignment and clarity.
Senior Data Analyst
Regal.io
Boston, USA
04.2022 - 09.2022
- Constructed and maintained data transformations with dbt for production-level reporting needs.
- Created internal and customer-facing Looker dashboards while managing LookML codebase.
- Conducted ad hoc data analysis in Snowflake to address mission-critical inquiries.
Data Analyst
TechTarget
Newton, USA
12.2019 - 04.2022
- Established novel reporting mechanisms utilizing Zendesk API, Gainsight, and Amazon S3.
- Executed ad-hoc SQL queries from Oracle and Google Cloud BigQuery for client-facing units.
- Performed data analysis with Python/Pandas to generate insights for non-technical stakeholders.
- Constructed ETL pipelines using stored SQL procedures from diverse data sources.
- Developed and maintained dashboards in Tableau and GoodData to facilitate data-driven decision making.
- Automated business processes with Python, resulting in a 20% reduction in manual helpdesk ticket volume.
Data Consultant
Percent Pledge
08.2019 - 12.2019
- Established ODBC connections between Excel and Metabase data warehouse for automated reporting
- Identified new key business metrics and implemented reporting in existing Excel workbooks
Senior Research Associate, Healthcare
Gerson Lehrman Group (GLG)
Boston, USA
12.2017 - 04.2018
- Facilitated ad hoc consulting engagements between clients and healthcare/life science subject matter experts
- Recruited key-opinion leaders and esteemed healthcare professionals into the GLG network for consulting work
- Managed daily client project requests to ensure timely execution
Intellectual Property Assistant, Life Sciences
Lando & Anastasi, LLP
Cambridge, USA
03.2016 - 12.2017
- Managed all projects related to patent prosecution for multimillion-dollar pharmaceutical portfolios
- Handled robust dockets for 10 patent attorneys
- Addressed daily deadlines in a timely manner to avoid extensions and ensure costs were minimized for clients
- Interfaced with internal and external stakeholders to ensure projects met deadlines
- Performed final review of all patent applications and official submissions to ensure USPTO compliance
Research Data Coordinator
Boston Children's Hospital
Boston, USA
02.2015 - 03.2016
- Supported 24+ physicians to develop protocols to meet research needs
- Recruited over 500 individuals for clinical research participation
- Oversaw operational aspects of clinical research to ensure projects met milestones
- Observed strict privacy practices and ensured sensitive information was protected
Ambulatory Services Representative II
Boston Children's Hospital
Boston, USA
09.2014 - 02.2015
- Orchestrated daily schedule, exam room utilization and flow of 150+ patients
- Prepared charts prior to start of clinic to ensure smooth operations
Sales Development Associate
Experian Data Quality
Boston, USA
01.2014 - 09.2014
- Booked meetings on behalf of account executives to drive new business
- Managed relationships with prospective clients ahead of sales calls/engagements
Education
CS50 - Intensive Intro to Computer Science -
Harvard Extension School
Online05.2021
Product Management -
General Assembly
New York, NY01.2018
Bachelor of Science - Neuroscience, Spanish (Minor)
University of New Hampshire
12-2013
Skills
- Data modeling and visualization
- ETL processes and SQL querying
- Business intelligence tools
- Python programming
- Data analysis with Pandas and NumPy
- Looker and Tableau expertise
- Excel proficiency
- Version control with Git
- Project management with Jira
- BigQuery and Snowflake knowledge
- Data transformation with dbt
- Fivetran and Stitch connectors
- Reverse ETL with Hightouch
- Cloud services: AWS and Google Cloud Platform
- Customer support with Zendesk
Timeline
Senior Analytics Engineer
Glossier
12.2024 - Current
Data Analyst
Rhino
11.2023 - 11.2024
Data Analyst
LinkSquares
10.2022 - 08.2023
Senior Data Analyst
Regal.io
04.2022 - 09.2022
Data Analyst
TechTarget
12.2019 - 04.2022
Data Consultant
Percent Pledge
08.2019 - 12.2019
Senior Research Associate, Healthcare
Gerson Lehrman Group (GLG)
12.2017 - 04.2018
Intellectual Property Assistant, Life Sciences
Lando & Anastasi, LLP
03.2016 - 12.2017
Research Data Coordinator
Boston Children's Hospital
02.2015 - 03.2016
Ambulatory Services Representative II
Boston Children's Hospital
09.2014 - 02.2015
Sales Development Associate
Experian Data Quality
01.2014 - 09.2014
CS50 - Intensive Intro to Computer Science -
Harvard Extension School
Product Management -
General Assembly
Bachelor of Science - Neuroscience, Spanish (Minor)
University of New Hampshire
Similar Profiles
Ray Blackwood-BloomRay Blackwood-Bloom
Senior Director, Creative and Marketing Operations at GlossierSenior Director, Creative and Marketing Operations at Glossier
Dallas PerryDallas Perry
Editor at GlossierEditor at Glossier
Mary Jane HansonMary Jane Hanson
Market Specialist at GlossierMarket Specialist at Glossier
Samaris PagánSamaris Pagán
Associate Store Director at GlossierAssociate Store Director at Glossier
Zachary SigmanZachary Sigman
Sales Associate/ Key Holder at Marathon SportsSales Associate/ Key Holder at Marathon Sports