David is available for hire
Hire DavidDavid Kritzberg
Verified Expert in Engineering
Data Engineer and Software Developer
Location
Emeryville, United States
Toptal Member Since
May 6, 2021
After completing his doctorate in economics, David worked for a year as a professor before switching gears into data engineering and data science. He's built a consulting business in the healthcare system space, providing custom solutions and currently bootstrapping SaaS products for surgery centers.
Portfolio
Appian Data Services
SQL, MySQL, APIs, Tableau, Tableau Server, Financial Forecasting...
Kannact
Electronic Medical Records (EMR), Electronic Health Records (EHR), APIs...
Pfizer - PGS Operations Insights
Data Engineering, SQL, ETL, Data Modeling, Data Pipelines, Python, Cypher...
Experience
Availability
Part-time
Preferred Environment
Linux, MacOS, Windows, Slack, Asana, Emacs, Pandas, Python 3, SQL, Tableau, Databases
The most amazing...
...EHR and ERP supplies utilization integration I've built identifies discrepancies and opportunities in orthopedics cases, saving hospitals $400,000.
Work Experience
Co-founder
2012 - PRESENT
Appian Data Services
- Developed and maintained a financial reporting suit and budgeting application used by thousands of managers, executives, and analysts within a large healthcare system in California.
- Built subject-oriented data marts, complex business logic in SQL queries, and Tableau dashboards for multiple customers within health systems.
- Assisted multiple health system clients with ERP (WorkDay) and EHR (Epic) migrations, including requirements gathering, reverse engineering business logic, validation, and refactoring.
Technologies: SQL, MySQL, APIs, Tableau, Tableau Server, Financial Forecasting, Anomaly Detection, Budgeting, Financial Reporting, Dashboards, Business Intelligence (BI), ETL, Data Engineering, Azure SQL, Amazon S3 (AWS S3), Amazon RDS, AWS Lambda, Cloud Infrastructure, Healthcare IT, Data Visualization, T-SQL (Transact-SQL), Azure, Business Logic, MariaDB, GitHub, Data Warehousing, Data Science, Relational Databases, Amazon Web Services (AWS), Google Sheets, Data Analysis, Azure SQL Data Warehouse (SQL DW), Jupyter Notebook, Databases, Schemas, Data Analysis Consultant, Data Management, Reporting, BI Reports, ETL Tools, Data Warehouse Design
Healthcare System Integration Consultant
2022 - 2023
Kannact
- Advised the CTO on data interoperability options in the context of a rapidly shifting competitive landscape with changes in the regulatory and technical frontier.
- Conducted research to anticipate the impact of regulation on the opportunity to build new data-sharing arrangements between diverse players.
- Collaborated with vendors to build a set of options for the client to build internal tools to interact with.
Technologies: Electronic Medical Records (EMR), Electronic Health Records (EHR), APIs, API Integration, JavaScript
Data Engineer
2021 - 2022
Pfizer - PGS Operations Insights
- Served as the primary data engineer building a resource optimization application to increase the on-time completion rate of critical processes to guarantee drug safety and learn from history.
- Designed the DB schema for permissions, team dynamics, and work history. Pulled data from Redshift, Neo4j, and APIs that hooked into ML models.
- Optimized code to onboard new sites as users, allowing them to quickly build teams, assign work, and track progress against targets and history.
Technologies: Data Engineering, SQL, ETL, Data Modeling, Data Pipelines, Python, Cypher, GraphDB, Neo4j, Data Lakes, Databases, Schemas, Data Management, Redshift, Star Schema, Data Warehouse Design
Consultant Data Engineer
2021 - 2021
Groups Recover Together
- Recovered logic from an ineffectively documented EMR database to build a set of revenue cycle management KPIs for a behavioral health startup.
- Designed and implemented data mart for RCM and financial reporting; created complete documentation for the data mart to hand off to internal resources.
- Created a weekly scorecard for presentation and analysis in Tableau.
- Assisted in the design and execution of automated validation checks to establish a source of truth for the organization.
Technologies: Azure SQL, eClinicalWorks, Tableau, SQL Server Management Studio, Pandas, JSON, T-SQL (Transact-SQL), Business Logic, GitHub, Data Analytics, Relational Databases, Data Analysis, Startups, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports
Economist and Data Engineer
2021 - 2021
USAID
- Pulled data from Crunchbase to develop a database of investors, transactions, acquisitions, and businesses in Africa.
- Merged and cleaned pandas data and built Tableau visualizations to help the team explore data and assign industry mappings and geographical patterns.
- Quantified indirect international connections between investors and businesses to identify strategic relationships.
Technologies: Tableau, Neo4j, Pandas, Crunchbase API, Dashboards, Research, Econometrics, Business Intelligence (BI), Data Engineering, Finance, Economic Analysis, Economics, International Development & Economics, Data Visualization, Data Pipelines, Data Modeling, PostgreSQL, GitHub, Data Warehousing, Data Analytics, Relational Databases, Data Analysis, Microsoft Excel, Jupyter Notebook, Databases, Schemas, Data Analysis Consultant, Data Management, Reporting
Consultant Data Engineer
2015 - 2020
El Camino Health
- Built a data warehouse and data integration layer as a platform for analysis of several financial and clinical information domains inside a growing health system.
- Automated reporting, developed analytical solutions to business problems, and translated business logic into technical terms to surface opportunities and threats to the executive team.
- Combined utilization data from ERM with materials spending from the ERP system into a clean data mart; built financial performance dashboards of orthopedic supplies utilization to reveal inefficient use of implants and update preference cards.
- Built a comprehensive view of profitability for physician groups and clinics, including physician scorecards and profitability by service.
Technologies: SQL, SSIS Custom Components, Tableau, Tableau Server, Microsoft SQL Server, Dashboards, SQL Server Integration Services (SSIS), Business Intelligence (BI), ETL, Data Engineering, Data Visualization, Data Pipelines, Data Modeling, SQL Stored Procedures, Stored Procedure, Dashboard Design, T-SQL (Transact-SQL), JSON, Business Logic, Data Architecture, Data Warehousing, Data Analytics, Relational Databases, Migration, Data Analysis, Microsoft Excel, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports, ETL Tools, Data Warehouse Design
Data Engineer, Data Visualization
2017 - 2018
A Surgery Center in California
- Developed an income statement and balance sheet by service line and by surgeon for a surgery center.
- Created an ELT system integrating data from multiple vendor silos, including EMR system, surgical supplies system, time and attendance, and GL system.
- Designed and implemented data marts to read scrubbed data and feed clean views to the dashboard tool.
- Built dashboards to manage growth using profitability measures.
Technologies: Amazon S3 (AWS S3), Microsoft Power BI, Electronic Medical Records (EMR), Vendors & Suppliers, Profitability Analysis, Enterprise Resource Planning (ERP), Financials, APIs, Microsoft Access, SQL Stored Procedures, Stored Procedure, Dashboard Design, Business Logic, GitHub, Data Warehousing, Data Analytics, Relational Databases, Amazon Web Services (AWS), Data Analysis, Microsoft Excel, Startups, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports, ETL Tools, Data Warehouse Design
Consultant Data Engineer
2016 - 2016
Tesla
- Developed a test application to demonstrate the optimal approach to anticipating manufacturing problems in remote supplier factories before products arrived at assembly.
- Managed clients and a team of three engineers to beat deadlines and requirements.
- Built a test application in AWS and assisted internal resources with a plan to build an internal application based on our design.
Technologies: JavaScript, AWS Elastic Beanstalk, AWS Lambda, Python, ETL, Data Engineering, Amazon S3 (AWS S3), Cloud Infrastructure, Databases, Reporting
Data Engineer, Data Visualization
2008 - 2015
Sutter Health
- Developed and maintained in-house web-based financial reporting applications as the source of truth for thousands of internal users. The suite is still used heavily for reporting at Sutter today.
- Managed a small team of developers to add new features and maintain and validate pipelines and end-user features.
- Maintained a homegrown budget application with auditing features. Helped homegrown design budget build and spread applications used at all Sutter Bay area hospitals and foundations.
Technologies: SQL, SQL Server BI, SQL Server Integration Services (SSIS), Tableau, Tableau Server, Dashboards, Microsoft SQL Server, Business Intelligence (BI), ETL, Data Engineering, Data Visualization, Stored Procedure, SQL Stored Procedures, Dashboard Design, T-SQL (Transact-SQL), Business Logic, Data Architecture, Data Warehousing, Data Analytics, Relational Databases, Data Analysis, Oracle, Microsoft Excel, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports, ETL Tools, Data Warehouse Design
Economist
2002 - 2006
University of Colorado Boulder
- Implemented techniques of optimal survey design to estimate choice parameter values.
- Used choice experiments to confirm social psychology predictions that having a companion and the companion's relative ability are critical determinants of site choice.
- Revealed that site choice models of recreation demand omit an endogenous variable—a result of a cooperative game: when they omit a companion's presence in the description of site characteristics.
- Contributed to the overall project. Additional information available at www.sciencedirect.com/science/article/pii/S1755534513000055.
Technologies: Survey Design, Econometrics, Data Analysis, Data Science, Economics, Discrete Choice Models, Experimental Design, Statistical Data Analysis
Experience
Health System Comparison Tool
An interactive visualization tool to analyze hospital financial performance with respect to their peers across a range of measures. Users can select criteria for defining market competition. Performance depends on factors such as market share and payer mix, estimated from panel regression. Data sources include multiple public data sets combined in a data mart, then fed into stats models, and then into Tableau.
Orthopedic Implant Supplies
Built a data mart inside a hospital, pulling bill-only invoices from the ERP system and matching that against preference card excepted and actual utilization in the EMR system to identify billing abuse for orthopedic implant supplies in surgery cases. Built a Tableau dashboard to reveal inconsistencies from preference cards by physician, procedure, and vendor. Management was able to show this information to the ortho co-management group, set savings targets, and track progress.
SaaS Income Statement by Service Line for A Surgery Center
Built a quarterly financial statement by physician and by service line that integrated accounting, EMR, supplies utilization, and time and attendance through APIs and bash scripts, scrubbed and organized in an AWS RDB, and then fed to Tableau Online. Required substantial scrubbing, automation, and business rules for allocating costs by procedure. The dashboard tool empowered the management to see profitability by physician and by service line in order to optimize growth.
Skills
Languages
SQL, Python 3, Python, Stored Procedure, Bash, T-SQL (Transact-SQL), Cypher, JavaScript
Paradigms
Business Intelligence (BI), ETL, Functional Programming, Anomaly Detection, Data Science
Storage
Azure SQL, Relational Databases, Databases, SQL Server Integration Services (SSIS), MySQL, PostgreSQL, SQL Stored Procedures, MariaDB, Microsoft SQL Server, Neo4j, Amazon S3 (AWS S3), SQL Server Management Studio, Data Pipelines, JSON, Data Lakes, Redshift
Other
Research, Dashboards, Data Engineering, Data Analysis, Business Logic, Data Warehousing, Data Analytics, Reports, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports, Data Warehouse Design, Econometrics, Discrete Choice Models, Data Visualization, Data Modeling, Data Architecture, ETL Tools, Game Theory, SSIS Custom Components, Tableau Server, APIs, Financial Forecasting, Budgeting, Financial Reporting, Economics, Statistics, Philosophy, Amazon RDS, Cloud Infrastructure, Healthcare IT, Finance, Economic Analysis, International Development & Economics, Survey Design, Experimental Design, Statistical Data Analysis, Electronic Medical Records (EMR), Vendors & Suppliers, Profitability Analysis, Enterprise Resource Planning (ERP), Financials, Dashboard Design, Migration, GraphDB, Startups, Azure SQL Data Warehouse (SQL DW), Financial Modeling, Electronic Health Records (EHR), API Integration
Tools
Tableau, SQL Server BI, GitHub, Google Sheets, Microsoft Excel, Slack, Asana, Emacs, StatsModels, MATLAB, eClinicalWorks, Microsoft Power BI, Microsoft Access
Platforms
Linux, MacOS, Windows, Jupyter Notebook, AWS Elastic Beanstalk, AWS Lambda, Azure, Amazon Web Services (AWS), Oracle
Industry Expertise
Teaching
Libraries/APIs
Pandas, Crunchbase API
Education
2000 - 2006
Ph.D. in Economics
University of Colorado - Boulder, CO, USA
1994 - 1996
Bachelor's Degree in Economics
University of California at Davis - Davis, CA, USA