Stephen Horn Email & Phone Number

San Diego, Ca, Us

San Diego, Ca, Us

Staff Data Engineer lead that reports to the Illumina Global Operations AMR Data Analytics Division.• Designs, deploys and manages data architectures, cloud infrastructures, streaming data pipelines and graph algorithms for Illumina's Global Operations AMR division.• Develops data ingestion/ETL pipelines between manufacturing software/sensors/logs and data warehouses/S3 buckets/Iceberg tables/Snowflake through NiFi, Kafka, Flink, Spark, Python (PySpark) and Airflow.• Builds and reviews PostgreSQL, MS SQL, Iceberg and Snowflake schemas while developing graph processing/graph algorithm outputs through TigerGraph Cloud.• Designs, manages and deploys AWS EC2 and EKS clusters to support internal data application deployment and scalability in production.• Manages AWS accounts (VPC, IAM, etc.) and cloud storage/computation costs for manufacturing while working with external vendors and internal IT/legal/finance partners on new data opportunities, data governance/security and legal agreements.

San Diego, Ca, Us

Senior Data Engineer that reported directly into San Diego HQ manufacturing while overseeing the initial integrations of Apache Iceberg.• Designed, deployed and managed data architectures, cloud infrastructures, streaming data pipelines and graph algorithms for Illumina's Oligo, Beadpool, Decoder Pool, Array, FFN & Primer manufacturing.• Developed data ingestion/ETL pipelines between manufacturing software/sensors/logs and data warehouses/S3 buckets/Iceberg tables/Snowflake through NiFi, Kafka, Flink, Spark, Python (PySpark) and Airflow.• Built and review PostgreSQL, MS SQL, Iceberg and Snowflake schemas while developing graph processing/graph algorithm outputs through TigerGraph Cloud.• Designed, managed and deployed AWS EC2 and EKS clusters to support internal data application deployment and scalability in production.• Managed AWS accounts (VPC, IAM, etc.) and cloud storage/computation costs for manufacturing while working with external vendors and internal IT/legal/finance partners on new data opportunities, data governance/security and legal agreements.

San Diego, Ca, Us

Senior Business Data Analyst that reported directly into San Diego HQ manufacturing and manufacturing upper management.• Designed and delivered automated data reporting and streaming data solutions for Illumina's Flow Cell, Array, Oligo/Beadpool and FFN/Primer manufacturing and manufacturing technical operations.• Developed data ingestion/ETL pipelines between manufacturing software/sensors/logs and PostgreSQL databases/S3 buckets/Snowflake through NiFi, Kafka, Flink and Python (Apache Airflow).• Built and reviewed PostgreSQL, MS SQL and Snowflake database queries, tables, indexes, views, materialized views and stored procedures/functions while developing out virtual databases in Denodo.• Developed desktop and TV dashboards for live KPI reports/web applications through Tableau, Splunk and R Markdown/R Shiny/Python (RStudio Connect) while maintaining on-premise and cloud-based Ubuntu, CentOS, RHEL and Amazon Linux 2 servers/EC2 instances for data pipelines.• Analyzed cloud storage and computation/service costs for manufacturing while reviewing/testing cloud based applications and Docker/Kubernetes containers.

San Diego, Ca, Us

• Designed and delivered automated data reporting solutions for Flow Cell, Array, Oligo/Beadpool and FFN/Primer manufacturing.• Built and optimized desktop and TV dashboards for live manufacturing and engineering KPI reports/web applications through Tableau and R Markdown/R Shiny/Python (RStudio Connect).• Developed and reviewed MS SQL and PostgreSQL database queries, tables, indexes, views and stored procedures/functions while building out virtual databases in Denodo.

San Diego, Ca, Us

• Collaborated with Manufacturing, Engineering, IT, Supply Chain and Finance partners to design and deliver automated data reporting solutions for Flow Cell and Array manufacturing. • Built and optimized desktop and TV dashboards for live manufacturing and engineering KPI reports/web applications through Tableau and R Markdown/R Shiny/Python (RStudio Connect).• Developed MS SQL and PostgreSQL database queries and views while assisting the data architect in data architecture projects and building views in Denodo.

Carlsbad, California, Us

• Built and managed data visualizations/dashboards for client regulatory content/reports through Tableau, R Markdown and Jupyter Notebook while performing data collection, cleansing and analysis using R, Python and SQL.• Managed DEV, TEST and PROD Tableau sites (as a server site administrator) while running workbook and data source deployment with Power Tools: Deployment.• Completed, reviewed and submitted regulatory/environmental data reports, documents, permit applications and interior/exterior site maps (using AutoCAD).• Lead data processing related Lean Six Sigma and JDI projects as a certified LSS Green Belt.• Assisted in machine learning and neural network development utilizing Scikit-Learn and Tensorflow.

Carlsbad, California, Us

• Completed, reviewed and submitted client regulatory/environmental data reports, documents, permit applications and interior/exterior site maps (using AutoCAD).• Performed data collection, cleansing and analysis using R, Python and SQL while creating R Markdown and Jupyter Notebook reports.• Communicated and worked with agency and client contacts regarding environmental data, regulations and site compliance issues.• Performed internal/external data management tasks, FTP tasks and site compliance monitoring.

Carlsbad, California, Us

• Completed, reviewed and submitted client regulatory/environmental data reports, documents, permit applications and interior/exterior site maps (using AutoCAD).• Tracked, collected and inputted client regulatory data, chemical inventories and hazardous waste activity/information using SQL and Excel.• Communicated and worked with agency and clients contacts regarding compliance and data quality issues.

San Marcos, California, Us

San Marcos, California, Us