Brock Nelson
Saco,ME
Summary
Accomplished Senior Data Analyst at IDEXX Laboratories, with a proven track record at multiple companies. Expert in leveraging Snowflake and R for comprehensive data analysis and dashboard creation. Excelled in developing global-reporting frameworks and data pipelines, enhancing data accuracy and business performance metrics. Skilled in financial data analysis and fostering team collaboration with a passion for making sense of everything Big Data has to offer.
Overview
7
7
years of professional experience
Work History
Data Analyst Senior II
IDEXX Laboratories
09.2020 - Current
- Promoted from Data Analyst Senior I to II August 2021.
- Designed and enacted a global-reporting framework for needs specific to Finance.
- On-boarded and managed a new-to-the-company direct report since 2023.
- Analyzed large amounts of data from various sources to identify trends and find patterns, signals and hidden stories within data.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Leveraged text, charts and graphs in curated dashboards to communicate findings in understandable format.
- Used custom-coded queries within Snowflake and/or R to extract data from data solutions and data warehouses.
- Interpreted business questions and collaborated with data engineering teams to identify data sources.
Senior Data Analyst
IDEXX Laboratories
09.2018 - 08.2020
- Created dashboards focusing on Customer Lifetime Value, leveraging various sources of data such as invoicing, install, and customer activity.
- Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
- Provided technical support for troubleshooting analytics and reporting issues such as mismatched customer information.
- Designed and developed data pipelines to acquire, clean and process data, specifically for onboarding new customers across multiple CRMs such as Salesforce and Hubspot.
Analyst, Advanced Analytics
Liberty Mutual Insurance
12.2017 - 08.2018
- Performed audits of subsidiaries to protect shareholders and potential investors from fraudulent or unrepresentative financial claims.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Developed data mining algorithms to identify and classify patterns in data.
- Tracked performance of automated models and recommended when a refresh to the regression coefficients was necessary.
Education
Master of Science - Data Science
10-2017
- 3.5 GPA
- Research Project: Predicting Likelihood of Brexit Results Using Local Demographics
- Dissertation: Impact of Selected Characters on Professional League of Legends eSport Matches
- Relevant Coursework: Predictive Modeling, Data Wrangling, Large-Scale Analytics, and Root-Cause Analysis
Bachelor of Science - Statistics
05-2015
- Relevant Coursework: Statistical Modeling Techniques, Variable Selection, and Foundations of Data Analysis
- Extracurricular Activities: Michigan Cheerleading
Skills
- Snowflake (SQL)
- R
- Tableau
- Financial data analysis
- Data modeling
- Advanced analytics
- Machine learning
- Big data technologies
- Time series analysis
- Predictive analysis
- Dashboard creation
- Executive-level presentations
Accomplishments
- Fostered a global standard for finance-based reporting by collaborating with various stakeholders.
- Achieved an automated financial Sources of Growth report, saving corporate finance hundreds of hours of work at the end of every quarter.
- Created a finance-focused database and supervised data engineering's port to business objects 4 for use by non-SQL proficient financial analysts.
- Improved relationship with our largest corporate customer by developing an automated suite of dashboards & reports for their regular use.
2023 Idexx High-Performer
Awarded due to the significant overhaul of automated reporting for our Corporate Accounts segment of Idexx. This not only standardized the North America and European dashboards, but provided more insight into contractual performance of our customers.
Timeline
Data Analyst Senior II - IDEXX Laboratories
09.2020 - Current
Senior Data Analyst - IDEXX Laboratories
09.2018 - 08.2020
Analyst, Advanced Analytics - Liberty Mutual Insurance
12.2017 - 08.2018
University of East London - Master of Science, Data Science
University of Michigan - Bachelor of Science, Statistics
Similar Profiles
Jenna RoderickJenna Roderick
Production Specialist at IDEXX LaboratoriesProduction Specialist at IDEXX Laboratories
Bobbie KallnerBobbie Kallner
Vice President of Human Resources - Global at IDEXX LaboratoriesVice President of Human Resources - Global at IDEXX Laboratories
Alexa GuerraAlexa Guerra
Team Lead Scientist I at Idexx LaboratoriesTeam Lead Scientist I at Idexx Laboratories