I am a Senior Data Engineer with over 10 years of experience designing, building, and optimizing scalable data pipelines and data platforms. I have a strong background in ETL/ELT development, data warehousing, and distributed data processing across structured and unstructured datasets. I am proficient in Python, SQL, and the modern data stack technologies including Snowflake, dbt, and cloud platforms. I architect robust data solutions, improve data reliability, and enable analytics and machine learning workflows.

John Roberts

I am a Senior Data Engineer with over 10 years of experience designing, building, and optimizing scalable data pipelines and data platforms. I have a strong background in ETL/ELT development, data warehousing, and distributed data processing across structured and unstructured datasets. I am proficient in Python, SQL, and the modern data stack technologies including Snowflake, dbt, and cloud platforms. I architect robust data solutions, improve data reliability, and enable analytics and machine learning workflows.

Available to hire

I am a Senior Data Engineer with over 10 years of experience designing, building, and optimizing scalable data pipelines and data platforms. I have a strong background in ETL/ELT development, data warehousing, and distributed data processing across structured and unstructured datasets.

I am proficient in Python, SQL, and the modern data stack technologies including Snowflake, dbt, and cloud platforms. I architect robust data solutions, improve data reliability, and enable analytics and machine learning workflows.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
See more

Language

English
Fluent

Work Experience

Senior Data Engineer / Analytics Engineer at Piper Sandler
June 1, 2018 - Present
Designed and maintained scalable ETL/ELT pipelines using Python, SQL, and SSIS; migrated legacy data workflows to AWS and Snowflake; built data warehouse schemas (star/snowflake) and OLAP models; implemented Airflow-based workflow orchestration; developed dbt transformations; built batch and near real-time pipelines with Spark and Kafka; optimized complex SQL queries to improve performance; collaborated with analytics teams to deliver production-ready datasets for BI and ML use cases.
Data Engineer at Unum
August 1, 2016 - May 1, 2018
Built and maintained scalable ETL pipelines using Python and SSIS; integrated large datasets from Teradata into enterprise data warehouse systems; designed SSAS cube models and warehouse structures for improved reporting performance; implemented data quality checks; automated data extraction and transformation workflows.
Data Engineer / Data Analyst at JPMorgan Chase & Co.
January 1, 2015 - July 1, 2016
ETL development using SSIS and Python to support large-scale data ingestion; supported big data workflows with Hadoop and MySQL; applied advanced transformations to standardize datasets; designed structured data models to improve usability; managed Power BI pipelines including refresh scheduling and gateway configuration for reporting.

Education

Master of Science in Computer and Information Sciences at St. Mary's University
January 1, 2019 - January 1, 2021
Bachelor of Science in Management Information Systems at Robert Morris University
January 1, 2002 - January 1, 2007

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Professional Services