Develop integration pipelines to ingest clients’ EHR data and push back data following transactions in a daily sync job. Stabilize ETL processes post-implementation by monitoring the syncs through Airflow DAGs and AWS Cloudwatch and optimizing in sandbox environments. Fix database issues via Django production scripts and cover with tests leveraging factories for mock patient, visit and invoice data. Coordinate with internal and external stakeholders to gather end-to-end project requirements.
Built ETL processes and services to extract third-party API payloads and store to internal data warehouses and further feed business intelligence tools. Consolidated databases by helping build a data lake to validate and normalize relevant datasets, making them more easily accessible to non-engineering teams. Developed an internal cloud-based application to serve as a central portal that team members could use to run automated reports.
Automated dashboards, reports, and presentation materials commonly used by account managers to reduce time spent on repetitive, low-value tasks. Owned Salesforce administration, revenue operations, and the tech stack for the Customer Success department. Analyzed multiple features of datasets to develop core metrics and KPIs and variable compensation models for the Customer Success department.