
Jacob Leonard
@jacobleonard
Data and AI consultant at Slalom building a collaborative future with AI and human-centered systems.
What I'm looking for
At Slalom, I currently work as a Consultant in data and analytics consulting. I also covered for the director of business intelligence at a global skin-care brand during a sabbatical, on a four-month contract.
At EcoCart, I built DBT reporting models and Glue data pipelines between DynamoDB and Redshift. I used DBT Cloud to turn nested JSON data into reproducible reporting datasets for self-service analytics in Sigma.
At OpenSesame, I helped improve data quality and reporting pipelines, and reverse-engineered LookML-generated SQL into DBT code for reproducible reporting. I also built a Terraform DBT module for self-hosted deployments through GitHub Actions on AWS.
I'm currently building my own ideas through TWF LLC and exploring how AI can support a collaborative future with systems optimized for human experience, harmony, and longevity. One project continued at Colossal Capital as an operating company, with redesigned art and scalable infrastructure for dynamic NFT projects.
Experience
Work history, roles, and key accomplishments
Warms my polish heart
Founder & CEO
TWF LLC
Aug 2023 - Present (3 years 3 months)
Sole-Proprietorship
Consulting: covered for director of business intelligence of global skin-care brand while on sabbatical for a month (4 month contract)
Dynamic NFT Hedge Fund, with NFTs as Collateral for a stable coin and a utility coin with charity built in
Test Example of the NFTs using tatum minting:
https://opensea.io/collection/world-turtle-farm-pol-prerelease
Rebranding (content obs
Built DBT Reporting models using Redshift, DBT Cloud, Sigma BI Tool, AWS Glue, and Fivetran
Built glue data pipelines to move data between DynamoDB and redshift, and used DBT cloud to extract nested data from json structures, to create reproducible reporting datasets for self-service analytics in Sigma
Worked within the Business Intelligence department to help improve data quality and reporting pipelines from legacy systems across all departments, and gather data warehousing and report generation requirements
Reverse Engineer LookML generated SQL code from Looker into DBT dry code for report reproducibility and warehousing, using CI/CD pipelines to auto-generate converted codebases
Technologies
Founder, President & CEO
Ackward Roots Inc
Jun 2020 - Jun 2022 (2 years)
Solo founder, placeholder logo was an ouroboros, then gay mask rainbow super hero, and finally a backward roots of saxophone unity logo, with 9 roots:
- Augmented Reality Crypto Coin Project
- Atmospheric Energy Extraction to combat global warming
- Study design in how perception and altered states of consciousness impact particle waveform duality and existence (got sidetracked by holomorphic re
Data Engineer
Opportunity Insights
Dec 2020 - May 2021 (5 months)
Hired to help improve & redesign the technology used to aggregate state and federal UI claims for the government
Primary technologies were written in python for data ingestion and manipulation, AWS S3 for storage, and DVC for data change logging. External clients were given access to shared server through RDP logins for increased data security
Main tasks included fixing existing ETL systems, stand
Machine Learning Engineer
Wag! Group Co.
Jun 2019 - Dec 2019 (6 months)
Projects include: NLP Analysis in Databricks for Label Generation, Graph Network Analysis for CS User Patterns, Distributed Reverse Geo-Geocoding for Address Verification
Continued refinement and additions of SQL data sets optimized and used directly for ML projects
Data Engineer
Wag! Group Co.
Nov 2018 - Dec 2019 (1 year 1 month)
Worked on the DataOps team, contributing to all elements of data at Wag such as infrastructure, security, resourcing, pipelining, modeling, reporting and dash-boarding
DataOps Projects: SQL report modeling using DBT and Snowflake for dash-boarding in Tableau, Databricks VPC, whitelisting, provisioning and ETL for Hive migrations, reverse-geocoding, and data science workflows, custom ETL pipelines
Bioinformatics Pipeline Engineer
Winter Genomics
Dec 2017 - Jun 2018 (6 months)
US Citizen Working Remote
Worked in conjunction with Winter Genomics and John Hopkins University teams to consult and re-write RNA-Seq bash scripting pipeline, utilizing newer technologies such as Nextflow and Docker
Pipeline was built to be deployable and extensible in multiple cluster environments while retaining consistent dependencies for versioning and reproducibility, and deploying the geno
US Citizen Working Abroad
Mostly worked in Java to export data into CSVs for stakeholders
Built distributed analytics computation pipelines in Apache Spark for on demand data delivery
Developed and maintained cloud analytics container system for ETL ingestion using Docker-Luigi-Spark-AWS-S3 framework - to automate the java-to-reporting pipeline
Developed automated reports and dashboards, reading
Bioinformatics Analyst
Human Longevity, Inc.
Aug 2016 - Feb 2017 (6 months)
Continuing the work from my internship, working on creating an automated dockerized somatic load plotting system for the production of report quality charts and figures, operating within the luigi distributed system
Developed two additional pipelines to access firebrowse significantly mutated gene data and copy number variation data for ingestion into the HLI datalake Ongoing R&D: algorithm develo
Bioinformatics Intern
Human Longevity, Inc.
Jun 2016 - Aug 2016 (2 months)
Worked in conjunction with the Bioinformatics Oncology team, led by Wayne Delport, to develop a new annotation pipeline, designed within the existing framework, to connect clinical data with cancer sequencing data from the GDC, in accordance with Human Longevity Inc. development and coding practices
Within the existing architecture, external data is fed in, annotated, standardized and stored using
Automated reporting for a LAMP stack
Met in Santa Monica weekly to discuss implementation plans for aggregating user data into consumer profile data from website and app usage
In-Home Math Tutor
mySTEMtutor.com
Jan 2016 - Jun 2016 (5 months)
Scheduled weekly lessons with students who need help with levels of math from algebra to calculus, as well as some physics
Coordinated sessions with a handful of students a week for 1 hour each, with personally designed lesson plans according to class, course content, learning and communication style. Travel to and from student homes independently on the bus from USC area, across Brentwood, Bel Ai
Assistant Bioinformatitian
Keck School of Medicine of the University of Southern California
Jan 2015 - Jan 2016 (1 year)
Working in congruence with Dr. Giridharan Ramsingh and bioinformatician Tim Triche to analyze and understand the changes in DNA methylated regions in relation to aging and the development of cancer
Developing BaseSpace applications intended to expedite genome alignment, sequencing, analysis, and visualization for the benefit of the academic and research community
Utilizing the bioinformatics onlin
USC Youth Camp Swim Instructor
Jan 2012 - Dec 2015 (3 years 11 months)
Teaching camp kids to swim in the ROTC building swimming pool
Lyon Center lap swim pool with facilities manager Jesus Santiago & ROTC lap swim pool
Research focus on the relationship between the endocrine system in young children with middlesex or intersex diagnosis, gender dysphoria, and developmental differences related to gendered sexual characteristics
Troy Hall First Floor South Wing 🎉
Worked with Brenda Osuna and Regan Smith to perform software installs of SAS and SPSS for graduate students
Worked with Sarah Feakins to process Deep Core Earth Samples for historic changes in biochemical earth samples
Lab Technician
Advancement Office Downtown Office- worked with Jane Roach and Xiomara to process USC gifts and donations. Manual data entry, and onboarding of new client donors, and processing of massive spreadsheet data into CRM software
Night Restock
The Yankee Candle Company, Inc.
Sep 2011 - Dec 2011 (3 months)
Greenfield Flagship Store
Secret shopper training and detection
Lifeguard
Hampshire Athletic Club
Sep 2009 - Dec 2011 (2 years 3 months)
Worked as Lifeguard at Hampshire Athletic Club.
Swim Instructor
Hampshire Athletic Club
Jan 2009 - Dec 2011 (2 years 11 months)
Worked as Swim Instructor at Hampshire Athletic Club.
Facilities Manager
LSSE Department, Town of Amherst MA
Apr 2011 - Aug 2011 (4 months)
Managed both ToA pools (War Memorial & Mill River) and Groff Park Wader
Lifeguard Scheduling
Chemical Testing
Ice Cream Concession Stand
Public Swim Lesson Scheduling
Camp Swim Lesson Scheduling
Park & Facility Maintenance
Lifeguard
LSSE Department, Town of Amherst MA
May 2008 - Aug 2011 (3 years 3 months)
Worked as Lifeguard at LSSE Department, Town of Amherst MA.
Swim Lessons Instructor
LSSE Department, Town of Amherst MA
Apr 2007 - Aug 2011 (4 years 4 months)
Worked as Swim Lessons Instructor at LSSE Department, Town of Amherst MA.
Education
Degrees, certifications, and relevant coursework
Marks Meadow Elementary School
Elementary School
Amherst Regional Middle School
Middle School
University of Southern California
Bachelor of Arts - BA, Applied Mathematics
2012 - 2015
Spring Admit: 2012
Amherst College
2010 - 2011
Math classes while in high school
Amherst Regional High School
High School Diploma
2007 - 2011
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Social media
Interested in hiring Jacob?
You can contact Jacob and 600K+ other talented remote workers on Himalayas.
Message JacobGet matched with your dream remote job
Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
