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 leads data pipeline automation and orchestration efforts.
Work at Trella Health
John Ortiz has been employed at Trella Health as a Data Engineer since 2021. In this role, he is responsible for automating the creation of data buckets for the Edge platform, utilizing tools such as Jenkins and Airflow. He leads the orchestration and automation of data pipelines for the Marketscape product platform, employing Apache Airflow and Snowflake. Additionally, he manages the migration of legacy ETL pipelines to a modern Airflow/Snowflake environment, ensuring efficient data processing and management.
Previous Experience in Data Engineering
Prior to his current position, John Ortiz worked as a Data Engineer at MediaCom for five months in 2021. He also held the role of Data Engineer at EightBar from 2019 to 2021. His experience includes a position as a Data Analytics Captain at COOP Captain in 2020 and a Data Engineering Fellow at Insight Data Science for one month in 2019. These roles contributed to his expertise in data engineering and analytics.
Education and Expertise
John Ortiz holds a Master’s Degree in Information Systems - Data Analytics from Baruch College, which he completed from 2017 to 2018. He also earned a Bachelor of Business Administration in Finance and Investments from the same institution, studying from 2013 to 2016. His technical skills are further enhanced by multiple NanoDegrees from Udacity in Data Analytics, Data Engineering, and Data Streaming, completed between 2018 and 2020.
Background in Research and Data Analysis
John Ortiz began his career in research, working as a Research Assistant at Binghamton University from 2009 to 2010. He later returned to Baruch College in 2013 for a brief period as a Research Assistant. His early experiences in research provided a foundation for his analytical skills, which he has applied in various data-focused roles throughout his career.
Technical Skills and Tools
In his role as a Data Engineer, John Ortiz utilizes various technical tools and programming languages. He owns the Airflow Directed Acyclic Graph (DAG) creation process and regularly writes ad-hoc scripts in Python. His work involves pressing data from Snowflake into SQLite database files to support front-end applications that require rapid response times. His proficiency in these technologies supports his contributions to data pipeline automation and management.