Jesse Kraut

About Jesse Kraut

Programming Languages: C#, T-SQL, DAX, PythonDatabase Management Systems: Microsoft SQL Server, SnowflakeData Lake Technologies: AWS S3, AWS AppFlow, AWS LambdaDatabase Reporting Software: Power BI Desktop and ServiceDevelopment Software: Microsoft Visual Studio, SnowparkAnalytic/ETL Software: SSIS, SSAS, Snowflake Pipeline (Streams and Tasks)

Experience

1. Senior Cloud Data Engineer

   Broughton Partners

   Jun 2022 — Present · Savannah, GA, US

   Architected several Data Pipelines for the Operations, Sales, Marketing and Finance team. Designed the entire Pipeline framework with an AWS S3 Data Lake and Snowflake data warehouse. Utilized the Snowflake features such as Pipes, Procedures, Steams and Tasks to load the incremental data. Designed 10 Lambda functions using Python to pull from Cloud based APIs for the Marketing Team. Worked with multiple Software as a Service platforms to build into the Snowflake Pipeline. The return on investment was around 600K with the Pipeline developments and project work. Developed around 70 new Snowflake data pipelines and designed the reporting abstraction layer. Remediated several Qlik Reports to use the new Snowflake data pipeline. Designed the data governance and security layer across all the platforms to keep consistency for good patterns. Created Architectural diagrams, documentation, and Pipeline audit reporting in Power BI for troubleshooting.

Education

• University of Pittsburgh

  Bachelors of Science, Computer Science

  1996 — 2001

Skills

• Business Intelligence
• Analysis Services
• Data Warehousing
• Sql
• Asp.net
• Business Intelligence Tools
• C#
• Software Development
• T-Sql
• Ssis
• Mdx
• Microsoft Sql Server
• Ssas
• Crystal Reports
• Etl
• Software Documentation
• Javascript
• Ssrs