Mark Druffel

Data Scientist, Analytics Engineer

Objective

Data scientist and engineer with 10+ years experience in data analysis, modeling, systems design, development, and strategy. Proven leader with versatile soft skills developed working across industries in many roles. Eager to apply my technical expertise and collaborative mindset to drive strategic objectives within a dynamic team.

Experience

84.51°

Remote

Lead Data Scientist

Dec 2022 - Present

Lead team responsible for developing and supporting Kroger marketing campaign management and measurement tools:

  • Led design and development of the campaign measurement data pipeline refactor utilizing Kedro and Ibis, which improved maintainability, flexibility, and extensibility.
  • Redesigned the campaign management data model to be composable and flexible, improving platform scalability. The new data model unlocked several new business capabilities, improved engineering velocity, and decreased ETL times.

    • DocStation

    Remote

    Senior Data Analyst

    Apr 2021 - Dec 2022

    Founding member at a seed funded start-up that used technology to enable pharmacists to deliver value based care:

  • Expanded the data warehouse using pyspark and Airflow to support new business services and end user analytics.
  • Designed and developed KPI's and operational dashboards with Apache Superset, R Shiny, AWS, and docker.
  • Performed analysis that led to increased revenue by improving the app's task targeting for pharmacists.

    • Propeller

    Portland, OR

    Analytics Consultant

    Jan 2017 - Apr 2021

    First analytics consultant hired at a boutique management consulting company. Worked with clients to develop data strategies, road maps, and execute analytics and IT projects. Clients included Nike, Salesforce, Kindercare, Cambia, and Mercy Corps. Example projects included:

  • Created a feedback loop between a product team and their end-users by developing a text analysis and NLP pipeline, which reported user pain points from survey data.
  • Designed a prototype recruiting management dashboard that enabled HR team to manage a data-driven recruitment process improving consistency, velocity, and candidate experience.
  • Developed and facilitated workshops to upskill client analytics team's technical and project management skills.
  • Scaled Propeller's internal operations by developing infrastructure to automate KPI's including API wrappers, a data pipeline, process automation, and reporting using R, Python, and AWS.

    • Northern Trust

    Chicago, IL

    Manager, Reporting

    Oct 2015 - Dec 2016

    Mananged the reporting strategy, roadmap, and product development:

  • Designed a prototype reporting app with d3.js and React for rich, interactive reporting and user collaboration.
  • Designed and developed a data pipeline that transformed semi-structured and unstructured metadata for analysis to identify data processing bottlenecks, forecast server demand, and deprecate underutilized services.

    • Team Lead, Reporting

    Sept 2013 - Oct 2015

    Led a global team of data and operations analysts:

  • Developed and managed reporting for a global client portfolio and internal teams.
  • Decreased data quality issues in prod (~2x) by developing and managing data QA processes including transformation validation, profiling, consistency checks, and completeness checks.
  • Managed the enterprise user access process and customer data exchanges.
  • Trained and upskilled analysts with data analysis and programming including Excel, SQL, R, Python, and Tableau.

    • Plante Moran

    Chicago, IL

    Senior Auditor

    Mar 2013 - Sept 2013

    Staff Auditor

    Jun 2011 - Mar 2013

    Project managed and executed IT audits and risk assessments for clients in various industries.

    Fifth Third Bank

    Cincinnati, OH

    Staff Auditor

    Jun 2010 - Jun 2011

    Performed financial audits, IT audits, and risk assessments.

    Education

    University of Notre Dame

    M.S. in Business Analytics

    2016

    Ohio University

    Bachelors in Business Admin

    2010

    Soft Skills

    • Strategy
    • Presentation
    • People Mgmt
    • Project Mgmt

    Coding

    Tools

    Data Wrangling

    • tidyverse
    • Ibis
    • Polars
    • Excel

    Visualization

    • ggplot2
    • plotnine
    • Plotly
    • observable.js
    • Apache Superset
    • Tableau

    Pipeline

    • Kedro
    • Apache Airflow
    • targets

    Modeling

    • tidymodels
    • scikit-learn
    • tidytext
    • igraph
    • fable

    Backend

    • Apache Spark
    • Postgres
    • DuckDB
    • MS SQL
    • S3
    • ADLS
    • EC2
    • Droplets
    • knex.js
    • Apache Arrow
    • Apache Hive
    • neo4j

    Web Dev

    • R shiny
    • Hugo
    • Netlify
    • Quarto
    • Markdown
    • Typst

    Devops

    • git
    • docker

    Design

    • dbdiagram
    • mermaid.js
    • Gimp
    • Invision
    • Powerpoint

    Volunteer

    Civic Software Foundation

    Executive Producer

    Designed and developed longitudinal analysis app for Oregon Department of Education.

    Hobbies

    • Rock Climbing
    • Hiking
    • Biking
    • Cooking
    • Reading