Constellation Brands

Senior Snowflake Data Engineer

Dealerware

- Continue the duties and responsibilities as Data Engineer I
- Lead a hackathon team to develop a prototype analytics dashboard for visualizing vehicle and fleet telemetry data using Dash (Python)
- Presenting at Data Engineering Guild meetings for sharing technical knowledge and skills with team members (Big Data, AWS, Docker, Kubernetes, Python)
- Implementing logging/monitoring (Python logger, Cloudwatch) and alerting (Prometheus, Opsgenie) for Flask API
- Generating architecture diagrams (Lucidcharts), including entity relationships (ERD) and data flow (data pipeline/lineage diagrams)
- Optimize performance of Flask API through adjustments to Redis caching, SQL profiling, Kubernetes auto-scaling, and load testing (k6), to lower API response time by >50% (for select requests)
- Fulfill data requests from various stakeholders, including customer success, clients, and management
- Implement Great Expectations (Python) data testing framework in an Airflow data pipeline to ensure data quality and integrity for ETL/ELT processes in Snowflake
- Add alerts to Airflow pipeline jobs to send a Slack alert message for failing pipeline jobs, the alert message including metadata regarding the failed job for easier root cause determination/debugging
- Spearhead configuring Snowpipe with AWS and Snowflake for ingesting near real-time vehicle telemetry data into Snowflake from S3 using S3 Event Notifications
- Assist and work with Devops team for production deployment setup of Airflow data pipeline using Kubernetes and Terraform
- Cooperate with team to build a new production Snowflake database using Alembic migrations - including role hierarchy structuring, schema and table creation, and initial population of database with production data

Data Engineer II

- Build out an Airflow data pipeline to populate tables in a Snowflake data warehouse
- Build out a Flask API (Snowflake back-end; controller-repository design pattern) having multiple REST endpoints to deliver vehicle and fleet utilization metrics to API consumers
- Add Auth0 authentication and authorization to the Flask API using Python auth'N/auth'Z decorators
- Setup production deployment for Flask API using CircleCI, ArgoCD, and Kubernetes
- Contribute to API documentation using Open API (yaml)
- Add unit/integration tests (Python) and end-to-end tests (Postman) to test suite collection
- Perform various devops-related work, including setting up AWS infrastructure with Terraform (infrastructure as code), updating CircleCI CI/CD process, adjusting Dockerfiles, configuring Kubernetes/Helm files, and creating Prometheus metrics/alerts
- Perform Snowflake database migrations using Alembic (Python)
- Use Github and Pycharm IDE to contribute to various code repositories
- Providing various BI reports to various stakeholders using Looker (lookml) and Treasure Data (data warehouse)
- Assisting data science in deploying a prototyping analytics dashboard (with Dash/Plotly) to Kubernetes using a Snowflake back-end
- Practice Agile/Scrum ceremonies, including standup, sprint review, refinement, and retrospective meetings
- Demoing new data engineering features at semi-weekly sprint reviews

Data Engineer I

Spyke.ai

• Built out the technology infrastructure for a next-generation recruiting platform focused on efficient candidate-employer engagement using a unique talent pipeline solution
• Lead application development using Python/Flask framework
• Deployed web application on AWS (Elastic Beanstalk, EC2, S3, Amazon RDS, and Route 53)
• Integrated Firebase/Firechat API (Javascript) for chat functionality and Sendgrid API (Python) for email functionality
• Developed front-end design using Atom IDE and Webflow
• Built back-end using SQLAlchemy and Flask helper libraries

Technical Co-Founder and Python/AWS Developer

Law firm

- Drafted and prosecuted patents in a variety of technological fields, including: software, hardware, machine learning, artificial neural networks, predictive modeling, FPGAs, chemical sensors, magnetic field sensors, drones/UAVs, electronics, circuit design, mechanical devices, acoustic-electric instruments, blockchain, cloud systems, Internet of Things (IoT) devices, virtual mask fitting, artificial trees, LED lamps, aircraft interior, pneumatic pumps, firearm accessories, and more
- Served a wide array of clients, including individual inventors, start-ups, medium size organizations, and Fortune 1000 companies

Patent Attorney

Indeed.com

• Served as a de-facto dedicated developer/engineer for the online marketing team by using R/Python scripting and MySQL queries to fulfill reporting and infrastructure requirements
• Modeled and predicted website traffic using statistical regression techniques (e.g., Linear Regression/SARIMAX models), and measurably grew paid search traffic >100% YoY
• Spearheaded Indeed’s expansion into Bing Ads and Yandex Direct (using Python and Java APIs) to significantly expand sources of paid search traffic for multiple web domains
• Leveraged Hadoop/Pig scripts to analyze server log data to compute big-data metrics (e.g., return visitor rate or RVR)
• Performed ad-hoc/exploratory data analysis in RStudio
• Created, managed, and optimized Google Adwords accounts to drive website traffic for Indeed’s various web domains, including Indeed UK, Canada, and Russia
• Coded keyword bidding algorithms and keyword expansion scripts (using R, Python, and MySQL) to increase overall team efficiency by >4X
• Delivered weekly analytics reports to management with the aid of data visualizations generated with the assistance of Matplotlib (Python) and Ggplot2 (R)

Technical Data Analyst/Engineer

Challenge Games

• Prepared BI reports for various business divisions, including marketing, product, and management teams
• Tested game features and updates using dashboards, database queries, data visualizations, and A/B testing
• Developed and tracked business metrics for multiple games, including Warstorm, Grid Iron Live, and Ponzi, Inc.

Business Intelligence Analyst

UT Learning Center

Math (Calculus) Tutor

Experienced data and analytics specialist having technical background in mathematics, statistics, computer programming, machine learning, physics, electronics, and economics

Taplio

Vincent Musgrove's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Vincent Musgrove's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Vincent Musgrove's Linkedin Analytics