Jon Tavernier

My Resume Jon Tavernier

[email protected] | 312-623-8660 | jontav.com

Summary

I am a technology professional who enjoys designing, building, documenting, and implementing scalable solutions that last for years and meet stakeholder needs. I enjoy helping teammates learn to do the same.

Experience

Zoro

- present

Staff Data Engineer, Enterprise AI Team, - present

  • Advance the use of AI by building a platform for stakeholders to create and run Agents, MCPs, Skills, etc.
  • Educate others on the current state of AI tools, Agents, and practices.
  • Environment: GCP Agent Platform, Google ADK, OpenAI, Codex, FastMCP, A2A, AG-UI, A2UI, Python

Staff Data Engineer, Data Engineering Team, -

I helped gather and made data easier to use. Here's how I helped do that in Google Cloud Platform:

  • Implemented and maintained scalable cloud computing solutions for large-scale data processing.
  • Designed batch and streaming data pipelines, data movement standards and patterns, etc.
  • Shared knowledge, created technical documentation, setup local development, etc.
  • Helped other data engineers on the team with all the above.
  • Environment: BigQuery, Apache Airflow (Cloud Composer), PubSub, Docker, Kubernetes (GKE), Cloud Run, Apache Spark (Dataproc), Apache Beam (Dataflow), Terraform, Jenkins, git, SQL, Python.

Senior Data Engineer, Data Engineering Team, -

  • In my first two years, I led the technical direction of Zoro's Data Platform team, launched a new analytical technology stack on Google Cloud Platform, and helped others on the team in many areas.

Raise Marketplace

-

Senior Data Warehouse Developer, Data Team

  • Partnered with data scientists and data analysts to understand business needs and data, developing easier-to-use, integrated data sets focused on supply, demand, purchases, buyers, sellers, web and mobile sessions, and transactional and campaign email messages.
  • Helped replace a legacy analytical data solution by designing, developing, and implementing a new analytical data store in Google BigQuery, including conceptual, logical, and physical designs of denormalized tables that drive self-service analytical capabilities in Looker.
  • Acquired and integrated data from more than 15 sources, including Adjust, Desk.com, Salesforce, Algolia, Google, Firebase, Sailthru, Linkshare, and Promoter, by interacting with REST APIs and batch exports.
  • Investigated production issues including zombie processes spawned by Docker containers in Kubernetes, stuck Apache Airflow DAGs, missing vendor data, data-quality concerns, slow queries, and high CPU usage.
  • Identified business and technical needs, shortlisted solutions, and created technology proof of concepts.

Allscripts

-

Expert Software Engineer, Care Management & Care Director Team

  • Led and supported the Allscripts Care Management and Care Director SQL Server data warehouse environments, their customers, real-time reporting, analytical queries, and data-loading processes.
  • Collaborated with internal business analysts and external customers to define requirements for data products such as data marts, SQL Server Reporting Services reports, and data extracts.
  • Developed utilities in Python and C# to aid troubleshooting efforts and reduce development time.

Networked Insights

-

Senior Data Engineer, Architecture Team

  • Oversaw a Pivotal Greenplum data warehouse environment, a massively parallel processing shared-nothing database technology, including its storage, performance, and availability.
  • Designed, built, loaded, and maintained denormalized, distributed, and partitioned data structures.
  • Enhanced and created more than 20 PL/pgSQL analytical functions used by a customer-facing web application.
  • Aligned the team's deployment process with that used and supported by other groups within the company.
  • Created Google BigQuery ETL logic to incrementally extract data from terabytes of JSON documents, transform it into smaller relational data sets, and load the results into append-only tables.
  • Investigated technologies including AWS Redshift, Azure Data Warehouse, ScaleDB, MySQL, and PostgreSQL.

Northwestern University: Northwestern Medicine EDW

-

Chief Data Architect and Manager of Source System Loads, -

  • Managed ETL processes that acquired data from more than 100 source systems representing dozens of storage technologies into the EDW environment, requiring frequent collaboration with other teams.
  • Planned and developed data structures in a 20+ terabyte Microsoft SQL Server 2012 environment to integrate and deduplicate data from dozens of clinical applications, including Epic, Cerner, and Athena.
  • Created, researched, and encouraged best practices in information architecture, SQL Server Integration Services (SSIS) ETL, SQL query optimization, data materialization, design reviews, and team processes.
  • Interviewed and evaluated candidates for Data Architect, Data Warehousing Specialist, and Power User roles.
  • Managed the migration of 157 SQL Server Agent jobs to a new server and established owners for every job.

Data Architect, -

  • Developed a Cerner inpatient-vitals data mart standardizing more than 100 million rows of data over ten years.
  • Extracted, loaded, and transformed data using SSIS from sources stored in Oracle, SQL Server, PostgreSQL, Informix, XML, CSV, Access, Excel, and text files.

Northwestern Medicine: Northwestern Medical Group

-

Application Programmer Analyst II, Clinical Information Systems Team

  • Acted as liaison to the Division of Cardiology's physicians, nurses, and professional staff, incorporating business and clinical requirements into the Epic electronic medical record (EMR) and other applications.
  • Extended Epic EMR functionality by proposing, designing, and coding more than 55 projects in InterSystems Caché (MUMPS), many of which improved integration between Epic and other applications.

Epic Systems Corporation

-

Technical Services, MyChart Application Team

  • Supported large health care organizations, including Fairview and Kaiser Permanente, and their IT and business-office professional staff with installations of MyChart, Epic's patient-portal web application.
  • Identified, captured, and analyzed workflow business requirements to develop technical-solution specifications using Epic Programming Points, Visual Basic, ASP, JavaScript, XML, HTML, and CSS.
  • Worked closely with InterSystems Caché, a NoSQL database management system, and Epic Chronicles.

Education and Certifications

  • Fellow, Association of American Medical Colleges Information Resources Leadership Institute,
  • Business Analyst Certification, Northwestern University School of Continuing Studies,
  • Bachelor of Science in Computer Information Systems, Indiana University Kelley School of Business,