David Kritzberg, Data Engineer and Software Developer in Emeryville, United States
David Kritzberg

Data Engineer and Software Developer in Emeryville, United States

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.
David is now available for hire

Portfolio

Experience

Location

Emeryville, United States

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.

Employment

  • 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), AWS RDS, AWS Lambda, Cloud Infrastructure, Healthcare IT, Data Visualization, T-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, 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, 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, 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, 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, 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, AWS 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, 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

  • Ph.D. in Economics
    2000 - 2006
    University of Colorado - Boulder, CO, USA
  • Bachelor's Degree in Economics
    1994 - 1996
    University of California at Davis - Davis, CA, USA

To view more profiles

Join Toptal
Share it with others