John Ortiz
About John Ortiz
John Ortiz is a Data Engineer with extensive experience in data analytics and engineering. He currently works at Trella Health, where he automates data processes and leads orchestration efforts for various platforms.
Work at Trella Health
John Ortiz currently serves as a Data Engineer at Trella Health, a position he has held since 2021. In this role, he is responsible for automating the creation of data buckets for the Edge platform using Jenkins and Airflow. He leads the orchestration and automation efforts of data pipelines for the Marketscape product platform, utilizing Apache Airflow and Snowflake. Ortiz manages the Airflow Directed Acyclic Graph (DAG) creation process and frequently writes ad-hoc scripts in Python. His work includes migrating legacy ETL pipelines to an Airflow/Snowflake environment and pressing data from Snowflake into SQLite database files to support front-end applications that require rapid response times.
Previous Work Experience
Before joining Trella Health, John Ortiz held various positions in the data engineering and analytics field. He worked at COOP Captain as Data Analytics Captain for six months in 2020. He was a Data Engineering Fellow at Insight Data Science for one month in 2019. Ortiz also served as a Global Scholar at PreScouter, Inc. for two years from 2019 to 2021. His experience includes working as a Data Engineer at EightBar for two years and at MediaCom for five months in 2021. Additionally, he gained experience as a Database Administrator Apprentice and Research Assistant at Baruch College.
Education and Expertise
John Ortiz holds a Master’s Degree in Information Systems - Data Analytics from Baruch College, which he completed in 2018. He also earned a Bachelor of Business Administration (B.B.A.) in Finance and Investments from Baruch College from 2013 to 2016. Ortiz has further developed his skills through various educational programs, including a Data Analytics NanoDegree and a Data Engineering NanoDegree from Udacity, both completed in 2018 and 2019, respectively. He also studied Data Streaming at Udacity, achieving a NanoDegree in 2020.
Technical Skills and Tools
John Ortiz possesses a range of technical skills relevant to data engineering. He is proficient in using Apache Airflow for orchestrating data pipelines and has experience with Snowflake for data storage and processing. Ortiz is skilled in writing Python scripts for data manipulation and automation tasks. His expertise includes automating data workflows, managing ETL processes, and optimizing data retrieval for front-end applications. He has a solid understanding of database management and data analytics principles.