Mark Mayo Email & Phone Number

The Cloud, Us

New York, Us

New York, Ny, Us

Managed team of 5 : 4 data-engineers (2 remote), 1 data-opsStack: AWS, Snowflake, Greenplum, Postgres, MySQL/Postgres Aurora/RDS, Kinesis, Python, Shell, Tableau, Looker• Managed Snowflake POC, implementation, and deployment unifying our data analytics platform (deprecating BQ, and MySQL aurora)• Introduced, and advocating for best practices in data warehouse engineering (converting from ETL -> ELT paradigm)• Migrating from in-house scheduling framework to Airflow• Working with DevOps to standardize data-engineering infra, and deployment (SDLC) using Terraform, CircleCI, K8's, and Ansible• Collaborating with various teams to understand and deliver data requirements from POC to production across several domains• Working with software engineers and DevOps to standardize micro-service data lake environment utilizing Kinesis, Firehose, Lambda, S3, and Snowflake

Managed team of 5: 2 data-engineers , 2 data-ops/DBA ( *1 remote), 1 principal engineerStack: AWS/Managed bare-metal, Snowflake, Greenplum, Postgres, MongoDB, Python, Shell, R, Tableau• Migrated from in-house managed bare-metal Greenplum appliance to Snowflake DbaaS• Collaborated with Snowflake to test various private preview features eg. Idp (OKTA), UI beta testing, XML parsing, PrivateLink, KMS encryption• Worked closely with Finance/Data Warehousing team to execute scheduled 10k/10q exercises• POC Matillion integration with Finance, and Analytics• Collaborated with Data Analytics on consulting efforts• Continued enterprise data support across several verticals

Managed team of 7 : 2 data-engineers , 4 data-ops/DBA (*2 remote), 1 principal engineerStack: AWS/Managed bare-metal,Greenplum, Postgres, MongoDB, Python, Shell, R, Tableau• Unified data-engineering, and dataops teams to support OLTP/OLAP/ALP/MLP environments• Scaled Greenplum DW from appliance to managed Greenplum bare-metal• Collaborated with SECOPS to remediate, and identify SOX1, SOX2 compliance issues for data warehouse/data analytics/data science environments• Responsible for enterprise data pipelines, and integrations using in-house proprietary ELT/ETL framework• Enterprise query optimization support for OLTP, and OLAP on various verticals (finance, RISK, data science, revenue operations, web analytics, product analytics, platform engineering)• Initial POC for Snowflake (DBAAS) platform

Brooklyn, New York, Us

• Optimizing ETL pipelines• Migrating legacy processes to current best practices• Reverse engineering black box ETL processes• Analytics support• Data Science liason• Vertica DBA

Chicago, Illinois, Us

Roles: Data Warehouse Engineer, ETL Developer, Data-Ops, and Reporting Engineer • Build, develop, monitor and maintain company Data Warehouse environment• Introduced and converted ETL to ELT process for schema on read transformations• Design, develop, implement, monitor, and document ELT integration jobs• DBA, Query and file support for Data Science, Marketing, Operations, and Businessdevelopment teams• Support for initial basic data profiling for newly acquired data sources• Collaborate with data science, and analysts to integrate newly vetted data KPI's• Report and dashboard development, optimization, automation and deployment

New York, Ny, Us

Roles: Data warehouse developer, ETL Developer, DBA, Data Analyst, Reports Developer• Develop and maintain the Marketing analytics data warehouse• Design, document, implement and maintain core table structures, and data-martsdriving mission critical processes and R&D• Develop and maintain ETL, monitoring systems and integrity processes• Data profiling of newly acquired data and integration with existing data warehouse• Technical lead in the reports development cycle from gathering requirements, data validation,and presentation• Identify KPI's from various reports and worked with business analysts to develop strategies toleverage intelligence from marketing campaigns