Tyler Wood

About Tyler Wood

I’m a seasoned Data Engineering leader with over a decade of hands‐on experience designing, building, and scaling end‐to‐end data platforms in high‐growth technology environments. My background spans every layer of the modern data stack—from raw data ingestion through transformation, modeling, and delivery into analytics and operational systems. I excel at turning ambiguous business questions into reliable, production‐grade pipelines that empower cross‐functional teams to make data‐driven decisions.Key strengths include:* Data Platform Architecture & Infrastructure: Architected cloud‐native data ecosystems on AWS (S3, ECS, Spark, EML, Redshift, Athena, Glue, MWAA, RDS/Aurora) using Terraform and GitLab/Jenkins CI/CD, reducing legacy costs by 80% and improving warehouse latency from daily to hourly loads.* End‐to‐End Data Engineering: Built scalable, idempotent ingestion frameworks (Python, SQL) deployed on Kubernetes/ECS, loading raw data lakes and implementing robust ETL into Redshift with automated monitoring (row‐count checks, schema‐drift alerts) to ensure data quality.* Reverse ETL & Self‐Service Analytics: Developed production‐grade pipelines to surface governed account and event data into tools like Tableau and Amplitude, enabling near–real‐time reporting and self‐service BI across sales, marketing, and product teams.* Generative AI for Analytics: Led “BI Navigator,” a LangChain/OpenAI–powered proof‐of‐concept that dynamically generates SQL queries against our modeled warehouse, slashing ad‐hoc reporting turnaround and democratizing data access for non‐technical stakeholders.* Leadership & Team Building: Grew and mentored high‐performing Analytics Engineering teams—hiring top talent, instituting coding and DevOps best practices, and fostering a culture of collaboration with product, security, and DevOps partners.* Strategic Collaboration & Value Delivery: Partnered with executives, product managers, and business stakeholders to define a comprehensive data strategy, embedding data capabilities into customer‐facing features and internal tools to drive measurable business outcomes.I’m passionate about leading broad‐scale data programs and organizations that bridge technical excellence with strategic vision. If you’re looking for someone who can both architect complex data solutions and galvanize teams to operationalize insights, let’s connect!

Experience

1. Senior Software Engineer Ii (Data)

   Foreflight

   Jan 2024 — Present · Boulder, CO, US

   Rearchitected teams infrastructure in AWS migrating to team-managed IaC deployment with multi-env deploys and a mirrored local dev environment, accelerating feature delivery while remaining compliant with org security requirements.* Redesigned ingestion pipelines with a custom Python framework deployed in AWS ECS and MWAA (Airflow), enabling horizontally scalable, idempotent data ingests into S3 (raw data lake) and governed loads into Redshift for organized warehousing - 60GB+ daily volume into S3 and Redshift* Implemented automated data monitoring and quality checks (e.g, row-count validations, schema drift alerts) to ensure high data integrity across ingestion and transformation workflows* Developed production-grade reverse ETL pipelines to surface governed account attributes and event data into SaaS platforms to support product, marketing, and sales teams operations* Collaborated with business stakeholders to translate requirements into data solutions—integrating data assets into internal tools and product features* Developed and deployed a novel AI application as an internal tool. This tool leveraged sophisticated context management for mapping natural language business queries to reliable and modeled data warehouse assets, documentation, SQL history, and user feedback, to generate SQL, produce data, and generate visualizations.

Education

• University of Colorado Boulder

  Bachelor of Arts (BA), Economics

  2006 — 2011