Nutrafol

Data Engineer Manager

Lead data engineering for marketing, commerce, and measurement at a multi-channel consumer brand. Build shared API ingestion in Snowflake and the dbt models behind marketing mix modeling, customer acquisition cost reporting, and attribution. Partner with growth, finance, and analytics on definitions and delivery. Review code and QA practices, mentor colleagues, and own monthly change-log review for audit compliance. Semantic-layer models remain in development.

  • Own the models behind marketing mix modeling, CAC reporting, and multi-touch attribution
  • Architected the reusable framework that loads ad and commerce platform APIs directly into Snowflake, replacing third-party connectors for major sources
  • Lead the design of governed metric definitions on the dbt Semantic Layer so dashboards, forecasting, and AI tools share one source of truth
  • Set code review and QA standards for the data team, mentor engineers, and own the monthly audit change-log review
  • Snowflake
  • dbt
  • Python
  • SQL
  • Tableau
  • Datafold

Frameplay

Data Platform Lead

Owned the data platform at a gaming technology company, from architecture and governance through production operations. Built streaming and batch pipelines for BI and customer-facing analytics, the reporting API, and inventory prediction tooling. Unified orchestration with a Rust scheduler and developed a SQL modeling framework with column-level lineage before leading the move to SQLMesh. Established engineering standards, data governance, and retention policies supporting ISO certification.

  • Built the customer-facing reporting API and an AI-driven inventory optimization engine, both integrated into the core revenue-generating platform
  • Built a Rust job scheduler that unified orchestration previously spread across Airflow, Step Functions, and Dagster
  • Created an in-house SQL templating framework with column-level lineage, dependency graphs, and generated BI documentation, then led the transition to SQLMesh
  • Designed the data governance framework and retention policies that supported ISO certification
  • AWS Athena
  • Apache Airflow
  • Rust
  • Python
  • SQL
  • QuickSight

phData

Lead Data Engineer Consultant

Led data engineering delivery for enterprise clients including Aramark and Castle Lake, working within client engineering pods. Built data platforms across Snowflake, Databricks, and Azure Synapse environments, and defined technical standards for engagements. The role combined platform architecture and implementation with documentation, blog posts, and training material. Worked with Python and SQL, Airflow and dbt orchestration, and reporting tools including Power BI, Streamlit, and Sigma.

  • Architected and delivered production data platforms for enterprise clients
  • Defined and evangelized technical standards and engineering best practices across engagements
  • Produced technical documentation, blog posts, and training curricula
  • Snowflake
  • Databricks
  • Airflow
  • dbt
  • Power BI

Rocket Auto

Senior Data Engineer

Built data pipelines and analytical models from design through production alongside engineering, product, and business teams at an automotive retail venture. Worked across Informatica, SSIS, Azure Data Factory, Python, and SQL, with Power BI for analytics. Automated Informatica object promotion using GitHub Actions and Azure Logic Apps. The deployment workflow remapped environment-specific object identifiers so merged changes could move between environments without repeating manual export and upload steps.

  • Built production data pipelines spanning Informatica, SSIS, and Azure Data Factory
  • Automated Informatica object promotion through CI/CD with environment-specific ID remapping
  • Delivered Power BI analytics for marketing and operations reporting
  • Informatica
  • Azure Data Factory
  • Python
  • SQL
  • Power BI

Hearst Autos

Marketing Data Engineer/Analyst

Engineered production batch pipelines supporting marketing and sales operations for automotive publisher brands. Established and managed Apache Airflow infrastructure on GCP Composer, with BigQuery, Python, and SQL supporting the data workflows. Developed machine learning models for market basket analysis, customer segmentation, and revenue prediction. The role connected pipeline operations with customer insights and predictive analytics, alongside reporting delivered through Tableau and Looker for marketing and sales consumers.

  • Delivered high-reliability data pipelines serving marketing analytics and sales operations
  • Developed production machine learning models for customer insights and revenue optimization
  • Established and managed Apache Airflow infrastructure on GCP Composer
  • BigQuery
  • Airflow
  • Python
  • SQL
  • Tableau

Ford Direct

Data Engineer

Built and tuned production data pipelines on Databricks and Alteryx for the Ford and Lincoln dealer joint venture, with a focus on reliability and performance. Wrote a Python wrapper to automate management of thousands of Datorama vendor pipelines. Cached object definitions to reduce API calls, used historical durations to time job checks, evaluated queue capacity before adding work, and separated routine reruns from failures requiring manual investigation.

  • Built and tuned production data pipelines on Databricks and Alteryx
  • Automated Datorama pipeline management with a Python API wrapper
  • Kept thousands of vendor pipelines within Datorama workspace and API limits
  • Databricks
  • Alteryx
  • Python
  • SQL
  • Datorama

Dentsu

Senior Data Analyst

Led analysis projects, presented findings to executive leadership, and mentored junior analysts while maintaining data infrastructure from ingestion through production monitoring. Automated mainframe report collection for an accounts payable operation of approximately 80 associates. Combined vendor extraction tooling, Azure ingestion, and an MS Access interface to provide shared work items, standardized statuses, and persistent notes. The same data supported automated consolidation for recurring management reports.

  • Automated mainframe report collection and consolidation for accounts payable operations
  • Built the shared ingestion pipelines and MS Access workload tool that standardized statuses and reporting
  • Mentored junior analysts through technical mentorship and knowledge transfer
  • Azure Data Factory
  • Logic Apps
  • Python
  • SQL
  • Power BI

Certifications

Years shown are the years each certification was earned.

  • Snowflake SnowPro Core (earned 2024)
  • dbt Analytics Engineering (Certified Developer) (earned 2024)
  • Databricks Certified Data Engineer Associate (earned 2024)
  • Astronomer Apache Airflow DAG Authoring (earned 2024)
  • Astronomer Apache Airflow Fundamentals (earned 2024)
  • Fivetran Technical Certification (earned 2024)
  • AWS Developer Associate (earned 2023)

Education

  • Walsh College - Master of Science in IT, Data Science (2021)
  • Duke University - Big Data and Data Science Post Graduate Program (2020)
  • Ferris State University - Bachelor of Applied Science, Accounting (2015)
  • Southwestern Michigan College - Associate of Applied Science, Accounting (2013)

Contact

Email mark.styx@cheesy-games.com