Mark O. Email & Phone Number

Tampa, Fl, Us

Remote

Leveraged dbt to architect and optimize data warehouse models in Redshift, collaborating closely withcross-functional stakeholders to drive business intelligence initiatives and address organizationalchallenges.Developed a customizable process to maintain GDPR compliance by anonymizing sensitive PII data inRedshift. This was developed using Python, deployed as a Docker image to AWS ECR, with tasks launchedon an ECS container, and orchestrated with Airflow.Created data ingestion pipelines with AWS services, such as API Gateway and Firehose, which enabledengineering teams across the organization to fire domain events into the data lake.Facilitated the marketing team's ability to send personalized job alert emails by implementing reverse ETLprocesses, transferring activation layer data models to the Iterable marketing platform via Hightouch.

Denver, Colorado, United States

Engineered scalable ETL data pipelines using Hive and PySpark on EMR clusters, adeptly tuning forperformance optimization, ensuring cost-effective data transfer and transformation to the S3 data lake.Led the initiative to consolidate customer data from Shaw and its subsidiary, Freedom Mobile, creating aunified data source. Successfully loaded and synchronized this data from Snowflake into ElasticSearchusing PySpark on EMR, facilitating comprehensive data analysis and reporting.Designed customizable templates for defining ETL pipelines, freeing developers from the task ofprovisioning AWS resources, allowing them to concentrate on writing Spark and Hive code. Thesetemplates were transformed into more intricate CloudFormation templates, which were then deployed inthe CI/CD process.

Denver, Colorado, United States

Modernized the month-end process on the IBM i server by implementing solutions with CL and RPG-IV.Created a process to build and send flexible Bill of Lading documents to the printer in the warehouse.