RichClegg

Resume

Lead Data Engineer · Greater Chicago Area

Download PDF

Experience

Senior Data Engineer · UTurn Data Solutions

Jan 2025 - Present · Chicago, IL

Bushel

2021 - Jan 2025 · Fargo, ND

Data Engineer · Grainbridge

2021 · Omaha, NE
  • Designed the data lake and warehouse on AWS S3 serving QuickSight and SageMaker.
  • Built PySpark ETL on AWS Glue and ingestion from RDS and DynamoDB.
  • Created a serverless app using Step Functions and Lambda to monitor and retry Glue workflows.

Senior Data Engineer · Amplifi Loyalty Solutions

2020 - 2021 · Naperville, IL
  • Led architecture and implementation of serverless data pipelines on Glue, S3, Athena and Aurora.
  • Wrote Python ETL (pandas, NumPy) for business-critical pipelines and advised on testing and deployment.

Data Analyst · SPR

2019 - 2020 · Chicago, IL
  • Automated business processes with Python on Jupyter, built dashboards, and created a Postgres master data management database.
  • Reduced risk by fixing bash and PHP scripts in a Salesforce data pipeline.

Director of Data Impact · RPH Innovations, LLC

2018 - 2019 · Chicago, IL
  • Led enterprise architecture strategy and ran a data lake on AWS Redshift Spectrum.
  • Reduced operating costs by over $100,000 through workflow automation.

Information Services Technical 2 · Argonne National Laboratory

2016 - 2017 · Chicago, IL
  • Advised researchers on scholarly communication and DOE scientific and technical information compliance.

Web Services Librarian and Computer Science Faculty Member · Dominican University

2013 - 2016 · River Forest, IL
  • Led development of a SharePoint portal, supervised a service desk of eight, and provided data governance for an open-source publication database.

Skills

Languages
PythonSQLBashGo
AWS
S3GlueAthenaRedshiftStep FunctionsLambdaECSMWAASecrets ManagerEKSAmazon Quick
Data and orchestration
AirflowSpark on KubernetesBigQuerySQL ServerPySpark
DevOps
TerraformCI/CDAzure DevOpsKubernetesSnykRenovate
AI and search
Amazon BedrockBedrock Knowledge BasesBedrock inference profilesAmazon OpenSearch

Education

Certifications