Data Warehouse Development: - Maintain, improve data model in Data Warehouse with more than 100 source systems and 10 "subject areas" (data marts). - Work closely with businesses users to clarify requirements, and maintain tight feedback loop during development to ensure the most efficient delivery. (SQL)Data Pipeline Development: - Maintain and improve 150+ ingestion/integration pipelines. (Python, bash, Snaplogic)Infrastructure Modernization Guidance: - Utilize a strong knowledge of modern data engineering methodologies to provide guidance throughout a department wide infrastructure modernization effort. - Build out 6 PoC's for candidate tools/technologies. (dbt, dlt, DataHub, Airbyte, Fivetran, Snowflake)Software Development Process Improvements: - Plan and guide a migration of over 50 repositories from SVN to git/GitHub.- Lead initiative to implement CI/CD strategy for DW/Application development.- Develop internal CLI utilities to improve developer efficiency. Documentation: - Develop and implement a documentation system deployed on GitHub pages for the data infrastructure team for internal and cross-departmental use. (Docusaurus, Markdown, React, CSS, GitHub Actions.- Craft git/GitHub documentation, including guides, architecture and conceptual information, and an internal standards reference.

- Reform legacy data management and analytics infrastructure through design and implementation of ELT data pipelines, on-prem data warehouse, and company-wide reporting infrastructure.- Develop internal API for integrating legacy ERP with new data infrastructure, with features like HTTP bearer authentication and interactive documentation. (Python, FastAPI, SQL, Docker)- Lead the continuous development and improvement of dashboards and reports for over 30 KPIs for 6 different departments using Power BI.- Administer the access and governance of reporting resources for 24 internal stakeholders in 6 departments.- Test and implement new data pipelines between the data warehouse and all data sources and storage systems at organization.- Maintain and periodically improve 45 active ETL pipelines, having never dropped below a weekly goal of a 96.40% execution success rate. (Docker, Meltano, dbt, Python, SQL)- Develop 11 internal web applications to fill data lifecycle gaps such as production and quality assurance data capture (Docker, Python, Streamlit)- Create full technical documentation and end-user guides for software and tools engineered for the organization (MkDocs, Docker)- Build and document CI/CD process for software development at the company (Git, GitHub, Python)

- Assess and map current and legacy data management strategy and analytics framework.- Assess and improve organizational OLAP data model.- Transition KPI reporting from Microsoft Excel to Microsoft Power BI.- Develop plan to migrate OLAP data storage from flat files and Excel to centralized data warehouse.- Digitize data collection methods to improve data quality and decrease latency between capture and analysis.

I spent two months living in Italy with my girlfriend.Having spent the past 3 years acquiring Italian, we wanted to use the language to explore northern and central Italy. We spent most of the time in and around Bologna staying with Italian friends we made at the climbing gym.

Perform Data Analysis and Preparation/Organization with SPSS and SPSS syntaxConduct Database searches and created comprehensive organizational system for searchesOversee the work of other research assistants Currently working with Dr. Csizmadia on a Meta-Analysis and NCFR conference proposal