Learn Data Skills
Beta
John Santiago

John Santiago

Data Engineer

Hakkoda

Technologies

My Portfolio Highlights

My New Course

Joining Data in SQL

My New Course

Joining Data in SQL

Quantitative navigator, guiding decision-makers through the sea of data.

My Work

Take a look at my latest work.

course

Exploratory Data Analysis in SQL

course

Data Manipulation in SQL

course

Joining Data in SQL

course

Exploratory Data Analysis in SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

Hakkōda | Aug 2024 - Present

Data Engineer I

N/A

Hakkōda | May 2023 - Aug 2024

Associate Data Engineer II

- Executed On Prem SQL Server Snowflake Migration of Healthcare Data using Metadata-Driven Ingestion with Azure Data Factory and Fivetran HVR - Innovated CI/CD processes using DBT Core and Azure DevOps, ensuring seamless integration and deployment of data models - Engineered a scalable, innovative product using Python, Fivetran HVR APIs, and Snowflake, efficiently ingesting over 1000 healthcare tables for client solutions - Demonstrated POC Snowflake-Azure Security Integrations: Privatelink, SSO, SCIM, RBAC, Dynamic Masking, Tag Masking, Network Policies - Provided guidance and training to junior team members and interns, fostering a collaborative and growth-oriented team environment through DBT Internal Capstone - Successfully managed client relationships, delivering tailored data solutions that meet specific business needs and driving project success generating revenue - Developed and optimized Snowflake stored procedures for complex data processing, query generation, and object creation, implemented dynamic SQL generation for flexible and efficient query execution, and utilized Snowflake scripting to automate data workflows and enhance ETL processes
Show More

BizAnalytica | Sep 2022 - May 2023

Jr. Data Analyst

- User Defined Functions: Created original User Defined Functions (UDFs) to generate queries with filters based on provided parameters, used in SQL stored procedures. - UDF and UDTF Refactoring: Refactored UDFs and User Defined Table Functions (UDTFs) from SQL Server, migrating them to Snowflake using SQL or JavaScript. - Parameter Handling in PowerBI: Collaborated with a PowerBI Architect to handle single and multi-value parameters with edge cases in UDFs to ensure accurate query result sets. - Snowflake External Function for Azure: Worked alongside the client's Senior Software Engineer to develop a Snowflake External Function for Azure through the Azure Portal. - DBT Cloud and Mini Project: Completed DBT Cloud courses and a mini project from a Udemy DBT course, enhancing data transformation skills. - Clean Data for PowerBI: Created clean and accurate datasets for use in PowerBI, ensuring reliable and insightful reports. - Data Transformation and Documentation: Transformed, tested, and documented data, maintaining high standards of data quality. - Team Collaboration: Communicated results effectively and collaborated with data team members to meet project goals and deadlines.

DAS42 | Mar 2022 - Sep 2022

Associate Analyst (Data Engineer Focus)

- ETL Processes and Airflow: Successfully implemented ETL process solutions in internal Airflow projects and client work, coaching coworkers to understand the ETL process. - Data Warehousing: Contributed to building a Snowflake data warehouse for client infrastructure using Excel files. - Data Discovery and Modeling: Played a key role in data discovery, modeling, and profiling for clients. - Fivetran Transformations: Utilized Fivetran Transformations to call stored procedures with idempotent SQL scripts for raw-to-conformed data transformations. - Custom Connectors: Developed an Azure Functions Python API script implemented as a custom connector in Fivetran. - Data Visualization and Analysis: Leveraged Looker to create marketing and recruiting dashboards using UFC data (Kaggle) from Snowflake, analyzing the best fighters to market and typical fighters to recruit in both male and female divisions (Internal Project) - Team Collaboration and Debugging: Collaborated closely with team members to debug errors and meet project deadlines, ensuring successful delivery and client satisfaction.

My Education

Take a look at my formal education

Bachelor of Science - BS, Computer Science  · (August 2017 - DecemberColorado School of Mines | 2021
Lakewood High School | 2017

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free