Joshua Schlichting

Software Engineer and Programming Enthusiast

I am a software engineer with a decade of experience in the fintech industry. For the last 10 years I've worked directly with stakeholders at all levels of management to understand their needs and provide suitable software, data, and cloud solutions to solve those needs in an automated manner.


Experience

Director, Data Engineering

Best Egg

Leads and mentors a team of software engineers through the software development lifecycle as they design, develop, test, deploy, and maintain serverless ETL pipelines in the AWS cloud.

Identifies and resolves issues through the meticulous debugging of data pipelines spanning multiple layers of technology which include Docker, GitHub Actions, Python, Go, SQL, dbt, and various AWS services such as S3, CloudFormation, CloudWatch, Lambda, Step Functions, and more.

Works with stakeholders including the Marketing, CRM, Finance, Operations, Product, and Development teams to assist with data-related technical issues and support their data infrastructure needs.

Ensures data assets are monitored for data quality

Reviews pull requests and provides feedback to keep code base aligned with industry best practices.

May 2024 - Present

Managing Data Engineer II

Best Egg
March 2024 - May 2024

Managing Data Engineer

Best Egg

Leads a team of software engineers through the software development lifecycle as they develop, test, deploy, and maintain serverless ETL pipelines in the AWS cloud.

Builds internal tooling with Python and Go for data team needs.

Engages in debugging AWS cloud applications deployed to Lambda and Fargate using CloudWatch.

Reviews pull requests and provides feedback to keep applications aligned with industry best practices.

March 2022 - Present

Senior Lead Software Engineer

Best Egg

Designs and develops data pipelines using Python, Kafka, Snowflake, MySQL, and AWS technologies.

Assembles large, complex data sets that meet functional / non-functional business requirements.

Identifies, designs, and implements internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Works with stakeholders including the Marketing, CRM, Finance, Operations, Product, and Development teams to assist with data-related technical issues and support their data infrastructure needs.

Develops repeatable and scalable data quality audits.

May 2021 - March 2022

Technical Architect

Sallie Mae

Develops modern software solutions to remove dependencies on outdated technology using Python/.NET.

Uses Python, JavaScript, PostgreSQL, Snowflake Data Warehouse, and the Django web framework to create and maintain internal monitoring systems responsible for monitoring over 100 daily automated processes.

Develops and maintains software to manipulate TN3270 terminal via MicroFocus Reflection .NET API's and a custom domain specific language.

Creates and maintains fault tolerant .NET file monitoring software responsible for monitoring critical files, validating their formatting using regular expressions, ensuring their proper execution via a custom domain specific language, and logging all status reports and errors to data warehouse.

Uses C#/.NET to create user access system used to track individual access to production and development environments on Windows Server 2008.

Performs configuration and administration of Red Hat Linux servers for supporting multiple Python virtual environments and Apache web servers.

Creates and maintains bash shell scripts responsible for the migration of code from remote git repositories to QA and production environments.

Designs robust headless Python processes used for monitoring and performing critical updates to customer accounts.

Develops and maintains custom Python libraries crucial for department's daily Python needs.

Leads the development efforts of business automation solutions using Python, and Snowflake SQL, to drive down operational costs and decrease corporate risks.

Analyzes legacy IT processes and identifies potential areas for improvement, optimization, and automation.

Leads the development of reporting solutions using Python, .NET, SAS, Data Toad, and Aginity Workbench for Netezza to provide high quality and actionable results.

Provides architectural oversight to the team on reporting structures and methodologies to ensure consistency and accuracy.

March 2017 - May 2021

Reporting Analyst

Sallie Mae

Work in Visual Studio (using C#, ASP.NET MVC, JavaScript, jQuery, Razor, HTML, CSS, and Bootstrap) to develop reporting wiki page, providing the company with a central location to find information and meta data related to all reporting and data feeds.

Develop with Visual Studio (C# and FlexCel for Excel), batch file scripting, and SAS E-Guide to automate routine work, reducing man-hours lost to manually performed tasks. These tasks include executing SQL queries, producing Excel workbooks for executive level reporting, and production data feeds necessary for daily bank operations.

Support back-end of reporting wiki website by developing a normalized relational database and appropriate entity relationship diagrams for such.

Work with project managers and department leaders to design, develop, and implement new data feeds needed to improve the call center’s ability to support customer inquiries.

Query/analyze databases and information systems using Microsoft SQL Server Management Studio, Aginity Workbench for IBM Netezza, SAS Enterprise Guide, Data Toad and more.

Monitor hundreds of scheduled tasks to ensure that databases are being fed current and accurate data.

Update stored procedures, tables, and functions as business needs change and evolve.

Prepare and present data/reports to all levels of management.

Create data views to facilitate customer reporting needs as well as the needs of the reporting team.

January 2015 - March 2017

Technical Training Instructor

Tactical Aircraft Maintenance, F-22 Raptor (2A3X7)
United States Air Force

Educated journeymen, craftsmen, and superintendent-level maintainers on how to operate and navigate Oracle's Unix based Solaris Operating System which is necessary to view aircraft systems theory and record aircraft maintenance history in the Air Force's Integrated Maintenance Information System (IMIS).

Repaired unsupported Windows desktops using various Linux distributions; maintained systems necessary for every day support section functions.

Instructed entry-level maintainers in the USAF to inspect, repair, service, and maintain F-22 Raptor components and systems.

Unit Training Manager:

Tracked and maintained training records and task completion data in a variety of databases to include Training Business Area (TBA) and Core Automated Maintenance Systems (CAMS).

Monitored Upgrade Training and Career Development Course (CDC) progression and completion.

January 2011 - January 2015

Education

The Pennsylvania State University

Master of Software Engineering
Master of Software Engineering
2019 - 2021

University of Phoenix

B.S. Information Technology
Concentration in Software Engineering

GPA: 3.8

2013 - 2016

Community College of the Air Force

Associate of Applied Science
Instructor of Technology and Military Science
2011 - 2013

Community College of the Air Force

Associate of Applied Science
Aviation Maintnance Technology
2010 - 2012

Skills

Competencies
  • Working directly with stakeholders and deriving requirements from their needs
  • Designing software with SOLID architecture
  • Writing automated unit tests
  • Debugging and troubleshooting
  • DevOps and CI/CD
  • Leading and managing teams of engineers
Primary tools
Other tools I have used professionally

About me

My tech story starts in the 1990's when I was a child. My parents bought a family PC for all of us to use and I became obsessed. I wasn't just excited to play games on it, I'd go on to learn everything I could about it. There was this fun sense of power you had when you knew practically everything there was to know about how computers worked in the 1990's (heck, even today!). Within a year or two my family purcahsed a newer machine and gave me the initial family computer all to myself. At this point I was running ethernet through the house and configuring the family computer to act as a network bridge so that I could pass some of that sweet sweet 56k up to my bedroom. From then on through high school, I was hosting LAN parties, designing levels for Quake 2 and Counter-Strike, hosting dedicated servers for all of my favorite games, and building websites.

After high school, I wanted to serve my country. As such I entlisted in the U.S. Air Force and shortly thereafter I was a Crew Chief on the world's most advanced fighter jet; the F-22 Raptor. During my time as an F-22 maintainer, I was selected to teach the career field's regionally accreddited college courses to airmen both new and tenured. I loved serving my country and wearing the uniform, and after an extended enlistment that took me to 7.5 years of active service, I hung up the uniform one last time to persue my knack for technology.

Immediately after separating from the military, I was hired at Sallie Mae to be a "Reporting Analyst." In this role, my job was to query all sorts of data bout the company and build automated reports for executives. I was using tools like C#, .NET, and SQL Server to to build, automate, and distribute these critical reports all over the company. It's all history from there. My hunger for programming has kept growing and never stopped. These days I enjoy writing Go.