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 Engagements:Data Strategist -- Media & Entertainment Non-Profit▪ 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 platform with integrated marketing technology.Principal Data Architect -- Health & Wellness Brand▪ 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 accomplished in Airflow.Data Architect -- National Food Delivery Platform▪ 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 Redshift databases). Implementation included batch and continuous loading, custom logging and alerts, role-based access security and governance monitoring, and automated, self-healing deployment.Data Engineer -- Financial Tech Company▪ 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.▪ Developed fully automated processes to backup, restore, migrate data, and import database objects. Created ongoing replication processes using AWS’ Database Migration Service to sync data and schema between on-premise databases & S3 hosted data lake.

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 address specific business needs and deployed through Spotfire using MS SQL Server, Azure DevOps, Python, HTML/CSS, and Javascript (AngularJS).• 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.• Presented new designs and functionality in live demo before stakeholders, development teams, and executives.

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 schedule tasks.• 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 implementing and tracking trace flags, smoke tests, SQL Management Studio's reporting features and using other QA measures.* Crafted and implemented data mining strategies across multiple databases (Teradata & Oracle deployed Clarity database and TPMG MS SQL Server) in order to identify billing anomalies, duplicates, and erroneous overpayments of medical claims.* Generated executive-level, interactive monthly reports tracking internal KPIs with information retrieved from multiple databases. Created compelling presentations and interactive visualizations using the MS Power BI suite (Power Query, Power Pivot, & T-SQL.)