In addition to continued responsibilities from previous role:

• Design, build, test and deploy a new, unified ETL pipeline to replace existing data ingest pipelines and API integrations; focus on modularity and easy extensibility.

• Optimize pipeline performance by leveraging external tools (such as AWS) and implementing async processing (reduced API call execution time by over 600%).

• Build an in-house API and a JavaScript/React-based UI to let internal teams interact with the new pipeline + operational database (e.g. upload configurations, retrieve job statuses, kick off a job from the UI)

• Maintained, debugged, and extended the features of 5 different data import wizards

in the Ellevation UI.

• Led clean-up efforts of discrepant data across clients; implemented database

triggers and constraints to ensure data integrity going forward.

• Increased visibility into failures by creating automated alerts (e.g. Slack API);

prevented failures proactively by building robust unit test suites.

In addition to continued responsibilities from previous role:

• Managed and monitored the API integration between Ellevation and Aeries (the most common Student Information System in CA); expanded its functionality as product needs arose.

• Streamlined data onboarding by automating steps typically taken in the UI as well as creating internal and partner-facing reference materials.

• Transformed and imported data for all CA-based clients (140+ school districts).

• Set up and maintained automated data pipelines; created custom solutions to mitigate data quality issues and satisfy varying partner needs.

• Consistently exceeded SLAs in a high-speed, high-volume inquiry environment. Considerably reduced import times by building a library of reusable/easily customizable data manipulation scripts.

• Addressed product inquiries from 700+ school districts via ZenDesk, phone and Zoom screenshare, often providing consultation to primary district stakeholders. Proactively identified and communicated partner challenges to Account Managers along with proposed action plans.

• Served as a product expert. Configured various features of the Ellevation platform to fit clients’ varying goals, data models and compliance needs. Tested and reported unintended platform behavior to the engineering team.

• Optimized support request response time by creating 150+ macros and implementing automated triggers in ZenDesk. Conducted team-internal trainings on database querying, UI data wizard use and troubleshooting data discrepancies.