Nathan Meinzer Email & Phone Number

San Francisco, California, United States

Raleigh-Durham-Chapel Hill Area

Los Angeles, California

• Data Platform Architect designing and implementing modern data architectures on the cloud, with a focus on fully automated data ingestions surfacing data to business users and web applications.Representative.
• Data Strategist leading team to assess marketing technology maturity, identify pain points, document current state architecture and develop detailed technological roadmap for transitioning organization to a modern data.
• Led team of engineers to modernize data platform, surfacing data to a web-based application that surfaces data to external customers, end-to-end from source to user in 3 minutes or less.
• Platform consists of an S3 ingestion, transformation via Lambda or Kinesis Firehose, presentation in Snowflake for querying from external application Gateway API. Orchestration, logging, and event notification is.
• Designed and implemented enterprise data platform: cloud-based data warehouse in Snowflake combining data from APIs, databases, and flat files ingested via AWS (lambda functions, Glue, S3, migration from Oracle and.
• Created a data pipeline migrating legacy data ecosystem to an AWS hosted data lake using PySpark executed via serverless AWS Glue jobs, with data landed on S3 and accessed via Redshift & Athena.

Portland, Oregon

• As part of an Agile (Scrum with Kanban) team, designed and created enterprise level analytics financial reporting solution for major hospital and healthcare entities. Interactive dashboards and reports tailored to.
• Wrote and maintained complex stored procedures in to extract, transform, and load (ETL) data from client-side Epic Clarity databases into software product for performant, accurate presentation.
• Implemented DacPac database model for multi-server build & deploy.
• Debugged and refactored error handling scripts written in IronPython to enhance user experience and increase usability.
• Optimized queries using SSMS to analyze execution plans and isolate and refactor inefficient database design (indices, check constraints, etc.) and query plans (temporary tables, set operators, recursive queries, CTEs).
• Ensured data integrity using test-driven design principles and writing code to satisfy known, identified edge cases.

Beaverton, OR

• Developed Python & JSON scripts to transfer legacy data architecture into Spark/S3 and Snowflake data foundation. Data ingested from Excel, Oracle, Teradata & SAP Connect using Apache Airflow, SSIS, and Alteryx to.
• Developed data models for existing Tableau and Excel driven dashboards, ensuring data integrity by analyzing and duplicating SQL queries with complex business logic.

Portland, Oregon Area

(same as above)

* Led team charged with testing deployment of automatic queries and generated reports in Teradata-to-Oracle (TD2EX) database migration, including designing and optimizing complex SQL queries with nested functions, stored procedures, cursors, and user-defined parameters.* Ensured data integrity and automated monitoring processes functionality by.