Jonathan March Email & Phone Number

• An extended period of time that I've been taking away from the tech industry, after resigning from my position at Quantcast. I wanted to focus on family and personal healing. Professionally, I also wanted to retool a.
• Lots of personal DW and ETL off open/gov datasets
• SQL-based deep Neural Networks from scratch
• Electronics, soldering, and Arduino hacking with C/C++
• Learning rust for command-line, TUI, and stored procedures
• LakeHouse streaming/storage/compute architectures centered around PostgreSQLOtherwise:

San Francisco, CA, US

• I was hired as a Director to oversee and unify four geographically dispersed data teams (about 15 people), with team members working remotely from the Bay Area, Toronto, Brooklyn, London, and Dublin. The teams were:
• Data Warehousing
• Data Science (Product Analytics)
• Business Analytics / Business Intelligence
• Consumer Insights (marketing and client-related analysis)Other than extra-hands support across the above workloads, I:
• Designed and articulated a vision for a more unified and automation-ready Data Platform

Textur was a SaaS business, offering an end-to-end Data Management platform with Integration, Streaming, and Modeling. Think: "Fivetran" + streaming fact/dimension API + "dbt cloud".Our Data API and Data Collection systems integrated customer first- and third-party datasets and streamed them directly into heavily-optimized Data Warehouse Fact and Dimension.

San Francisco, California, US

• Worked as a Senior Data Engineer, making SQL/python enhancements to the Data Warehouse and ETL systems.

San Francisco, CA, US

• Served as the head of Data Architecture, one of the three primary pillars of Data@Lyft (the other two being Data Analytics and Data Science).
• Built Lyft's Data Warehouse (Redshift-based) and Data Mart (PostGIS-based). The Redshift install grew to a roughly 100TB cluster around the time I left. The PostGIS instance was loaded with multiple demographic and GIS.
• Was responsible for the overall architecture and design of the warehouse and mart schemas, as well as the sophistication and quality of all SQL-based analysis/modeling at the company (whether data science or data.
• Designed and built a custom ETL system that supported full table rebuilds, incremental table updates, as well as custom python-based transforms (with simply a function that received/returned pandas dataframes).
• Provided functionality for scriptable-SQL (sequenced tmp tables), as well as cross-database export/load with extremely minimal config beyond raw SQL files.
• Developed and deployed automated ETL dependency detection and ETL scheduling solutions to ensure reliable production of all dimensional models.

• Co-designed and developed an external-facing Wikia Activity Monitor ("WAM") metric used to measure fandom across 300,000+ Wikia communities (http://www.wikia.com/WAM). The proprietary algorithm was developed as a way.
• Built a process for extracting datasets from Freebase and matching against content across the entire Wikia network. The algorithm achieved nearly 100% accuracy in identifying and associating 500+ Wikis with their TV.
• Consulted with Engineering and Product management about how to design data-related features, measure effectiveness using our event streams, and effectively utilize the existing data/reporting infrastructure.
• Held the Data Analytics and Data Architecture vision for the company's Enterprise Data Warehouse + Google Analytics strategy.
• Continued to function as lead Data Architect, engineering enhancements to the infrastructure I put in place prior to taking on the Director of Analytics role.

• Primary Data Architect for multi-terabyte, replicated MySQL Data Warehouse, providing analytics capabilities for a site with 100+ million monthly unique visitors, 1.5+ billion monthly pageviews, and 8+ billion monthly.
• Built framework for reliable 15-minute event ingestion, as well as a fully custom ETL system to transform and aggregate rollup data.
• Implemented job queue/worker system to efficiently ETL daily from 350,000 source databases.
• Designed, built, and then Product Managed a Report Tool used throughout the company to query, chart, and share analysis.
• Co-led a team responsible for a highly custom Google Analytics implementation.

San Francisco, CA, US

• Vertica & PostgreSQL Data Warehousing, Analytics, and Business Intelligence Solutions.
• Primary Data Architect for numerous new Dimension and Fact loading strategies. Designed and built a heavily-used, Ruby- and SQL-based Rollup system that allowed for simple aggregation and backfilling of metrics across.
• Designed and constructed an internal Geo Location system within Vertica. The system allowed SQL-based mapping of customer events to global locations and time zones. Used this system to estimate each user's time zone.
• Implemented A/B Test treatment group tracking within Vertica such that user's would be accurately tracked throughout the life-cycle of each test. Designed and wrote the SQL queries (with test statistics calculations).
• Developed custom Survival Models (in Vertica/SQL) against customer billing transactions to show instantaneous hazard rates and long-term survival curves. This analysis formed the basis for lifetime value (LTV) estimates.
• Designed and developed a Cohort tracking system that kept records of user and network transitions in and out of specific Cohorts. Implemented against base Vertica data such that all metrics could be easily joined and.

Chiyoda-ku, Tokyo, Japan, JP

• Data Architect responsible for design, implementation, and maintenance of the Data Warehouse.
• Primary person responsible for the integrity of TypePad, Vox, Movable Type, and LiveJournal metrics.
• Architected MySQL Data Warehouse schema, ETL job and dependency management system, and custom Perl modules for high-throughput data processing; reduced “all day” running scripts down to minutes!
• Worked with teams across the entire company, clarifying business success criteria, defining proper metrics, performing ad-hoc queries, and conducting in-depth data analysis of customer patterns and trends.
• Developed custom Pentaho reports; designed and implemented an automated email reporting system.
• Analyzed Personifi content classifications and developed a tool for generating custom clusters of blogs and blog posts based on term affinities.

• Database Development Lead for Search Engine Marketing (SEM) project releases within a team spanning San Mateo, Austin, and Ukraine offices.
• Responsible for database development and reporting code that processed and stored many terabytes of ecommerce data per year.
• Provided analytic code in PL/SQL utilizing UTPLSQL for unit testing.
• Built a Web Application Testing library in Ruby/Watir for improving QA efficiency.
• Responsible for original QA Lab setup, as well as on-going administration of Subversion.

• Worked as music producer, composer, multi-instrumentalist, and digital artist on a regular basis.
• Explored fractal imagery/animations, sound design, psycho-acoustics, and computational intelligence algorithms.

• Hired as a Software Engineer within Client Services.
• Primary PL/SQL developer for the Nissan North America and Nissan Canada projects.
• Responsible for the implementation of a new program enrollment framework, a dealer properties editor, and a highly custom billing/invoicing system.
• Transitioned to a Java development position in a newly formed Data Solutions Product Group.
• Contributed to DMi’s new Part Invoice product utilizing Java, XML, and Oracle Object technologies.
• Wrote data cleansing code in Perl as needed.

Austin, Texas, US

• Primary Programmer Analyst responsible for support and development of online catalog PL/SQL code.
• Monitored and guaranteed weekly content releases.
• Maintained and improved inter-communication and data transfer between multiple subsystems for publishing print catalog and related content to the web.

Austin, TX, US

• Contractor responsible for all production and development database administration.
• Designed and implemented a development process for maintaining frequent database schema changes.
• Performed routine data extraction/migration, query writing/tuning, and general database administrative tasks for Oracle, Microsoft SQL Server, and MySQL databases.

Austin, TX, US

• Hired as an Oracle Database Administrator. Became Trilogy’s SQL Server database expert.
• Designed and taught a two-session course to bring consultants up to the SQL Server expert level.
• Developed a Java/Swing application for reorganizing database tables and indexes on multiple DBMS.
• Wrote a performance tuning guide outlining steps for tuning MS SQL Server databases.
• Configured network OS installs for a UNIX automated testing environment.
• Traveled to consulting deployments to evaluate and optimize OS, DB, and application performance.

• Paid my dues as a UNIX Admin, installing machines and compiling almost everything from scratch.
• Wrote Perl scripts to automate admin tasks and developed a client/server app using Perl/Tk.
• Completed five weeks of Oracle training before taking over the full-time Oracle DBA's job.