Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nicholas Schmidt

Fredericksburg,VA

Summary

Senior Data Engineer and analytics professional with 6+ years of data analytics experience at a major company, ingesting data via Airflow and building DBT analytics data models, front end dashboards, and KPI reporting that support product and business decisions. I am eager to bring my analytics and leadership experience to your company.

Overview

5
5
years of professional experience

Work History

Senior Data Engineer

Government Employees Insurance Company (GEICO)
Fredericksburg, VA
06.2024 - Current
  • Leadership & delivery: Lead analytics delivery and team operations; mentor junior engineers, facilitate Agile ceremonies, and run troubleshooting sessions to unblock team members.
  • Cross-functional collaboration: Partner with stakeholders and other teams on requirements and data/analytics issues; drive outcomes that support business KPIs and strategic decision-making.
  • BI & reporting: Develop Power BI dashboards and KPI reporting to enable data-driven decision-making across business units; Power BI data modelling, DAX measure creation, visual configuration.
  • Data engineering: Design DBT analytics data models (star schema fact/dimension tables) and Airflow ingestion pipelines into Snowflake; own ETL/ELT processes for reporting and analytics.
  • Pipeline Management: Deploy and monitor daily Azure pipeline runs and troubleshoot production issues quickly and effectively.
  • Emerging tech: Collaborate with internal AI/LLM chat-bot team on generative AI use cases.

Data Intelligence Analyst

Government Employees Insurance Company (GEICO)
Fredericksburg, VA
08.2021 - 06.2024
  • BI & reporting: Delivered Power BI and Salesforce Analytics reporting for sales, service, and customer verticals (e.g., Multi-line Cancellations, First Sale Call Resolution, WFH Eligibility) to support stakeholder decision-making.
  • Data Engineering: Developed DBT Analytics models and Salesforce Analytics recipes which transformed raw data into report-ready datasets which offered concrete insights into key business questions.
  • Analysis: Analyzed data trends to support intelligence gathering and decision-making processes.

Education

Bachelor of Science - Mathematics

George Mason University
Fairfax, VA
05-2018

Skills

  • SQL
  • DBT
  • Power BI
  • Snowflake
  • Data modeling
  • Dashboard development
  • Salesforce Analytics
  • Agile/Scrum
  • Azure DevOps
  • Git version control
  • ETL development
  • Metadata management
  • Database design
  • Data analysis

Timeline

Senior Data Engineer

Government Employees Insurance Company (GEICO)
06.2024 - Current

Data Intelligence Analyst

Government Employees Insurance Company (GEICO)
08.2021 - 06.2024

Bachelor of Science - Mathematics

George Mason University