# Justine S. > Leader utilizing data to catalyze change Location: San Francisco Bay Area, United States Profile: https://flows.cv/justines I am passionate about using data to catalyze change and create positive impact in our community. My core competencies include data engineering with Airflow, dbt, Databricks, and Looker, technical project management with agile methodologies, back-end development with AWS and sst, and front-end development with React. I have 12 years of experience working with data, as a data engineer, and full-stack engineer, people manager, consultant, and technical co-founder, in various domains and industries. I’d love to chat! Please reach out to connect with me. ## Work Experience ### Senior Software Engineer II @ Ignite Reading Jan 2024 – Present ### Senior Software Engineer @ EducationSuperHighway Jan 2023 – Jan 2024 • Technical lead for full-stack process to save user & application data from our website to a database and transform it for internal use. Project management included systems design, working with the team to get agreement on the best path forward, creating cards for the team, working with the team 1:1 as a mentor, and reporting progress to management & internal stakeholders • Technical lead for data engineering project to transform BigQuery data for internal use, including mentoring data analysts to provide necessary skills for continual maintenance of the data pipeline • Built & maintained back-end AWS infrastructure using sst & aws-cdk to build lambdas, queues, APIs, databases, security groups, policies, roles, EC2 instances, Cloudfront distributions, hosted zones, & more • Built & maintained front-end React code which supports an application for users to apply for government funding for their internet service • Championed best practices by creating a tech plan process, documenting APIs, implementing SSO for our AWS sign-in, creating best practices for unit & load testing, linting, routing logs to DataDog for alerting, creating PR templates for our repositories, using Github actions for deployments, and implementing feature flags • Enhanced organizational culture by participating in DEI Council & Social Committee, by working on initiatives to support the organization and planning social events ### Senior Data Engineer @ Lob Jan 2022 – Jan 2023 | San Francisco, California, United States • Built & maintained a data pipeline orchestrated with Airflow, which utilizes dbt, Databricks, and assorted custom Python jobs, such as an hourly sync from OLTP databases into Redshift database • Built & maintained a data lake to ingest semi-structured data like CSVs and logs utilizing Retool for ingestion, S3 for storage, Lambdas for validations and transformations, and AWS Glue and Spectrum for transforming data into Redshift database • Built & maintained Looker views, explores and dashboards written in LookML for various stakeholders • Migrated complex SQL logic previously stored in Looker PDTs or Spark jobs into simplified, best practice dbt transformations structured with facts and dimensions • Ensured best practices of new and existing data products by utilizing linting, unit testing, dbt tests for data quality, Github actions for deployments, and testing outside of production environment • As co-chair of Diversity and Inclusion Working Group, led company-wide discussions around sensitive topics and planned culturally relevant events ### Technical Co-Founder @ Tally Up Jan 2020 – Jan 2022 • Developed our analytics web product’s front and back end by pulling the data in from a Snowflake database using node.js and creating visualizations with d3.js, which includes a login and user specific data pull. • Designed and built the data architecture within Snowflake by creating an ETL pipeline that transformed public data sets into final metrics that fed into our website. • Managed our website’s server as well as the storage of large datasets using AWS services. ### Data Architect & Engineer @ Unknown Jan 2020 – Jan 2022 Designed and implemented ELT data pipelines which automatically pulled data through multiple transformations. • Utilized python and Google Cloud Functions, Storage, and Pub/Sub to transform PDF invoices into line items of data which were then flagged for cleanliness based on historical costs and inserted into a BigQuery database. • Designed and implemented automated triggers in a mySQL database to take in a user’s inputs and display complex financial calculations to the client facing website. • Built automated triggers in a Postgres database to aggregate data from multiple sales channels and transform into holistic sell-through metrics. • Migrated a client off of legacy systems Mode and Postgres by implementing all one-off calculations into a single source of truth within a new Snowflake database and building a series of dashboards in Tableau. ### Director Of Analytics @ Insightful Labs Jan 2020 – Jan 2022 I built out and implementing data strategy solutions for small businesses. Strategy recommendations include improving coding efficiency, integrating disparate data sources into a database, and creating dashboards to inform business decisions. ### Data Analytics Manager @ EducationSuperHighway Jan 2014 – Jan 2020 | San Francisco EducationSuperHighway is a non-profit organization that operates more like a start-up. As the leader of our analytics team, I blended the stories told by our data with the expertise from across our organization to create insights that power change. By improving data transparency at the FCC, I’ve empowered schools to keep their internet providers accountable with metrics that had been otherwise impossible to calculate. As a result, we reached our mission of getting students high-speed broadband, and the organization was sunset in 2020. During this transition, I retained the majority of our analysis team through the final years of our organization’s existence by ensuring they had the growth opportunities they deserve to make a positive impact in their future endeavors. ### Visiting Fellow @ Education Pioneers Jan 2015 – Jan 2015 | San Francisco Bay Area I chose to become an Education Pioneers Fellow because I am dedicated to using my skills to make a positive impact on the community. • learned about the complex structures which the education system is required to hurdle when attempting to change, as well as the changes which are so urgent to be made. • made lasting connections with my cohort, which I would like to acknowledge as a community of professionals I can trust in for support. • expanded my awareness regarding my self and my place in the world. ### Senior Actuarial Analyst @ Towers Watson Jan 2011 – Jan 2014 | San Francisco, CA • Gained statistical expertise by completing a series of rigorous exams for credentials • Checked data for reasonableness by reconciling and creating data questions • Programmed assumption and methodology changes, quantifying each change • Consulted directly with clients • Performed deterministic and stochastic projections of liabilities ### Assistant @ University of California, Santa Barbara Jan 2011 – Jan 2011 Assisted a professor with his lesson plans by writing code for in-class examples ## Education ### Bachelor of Science in Actuarial Science UC Santa Barbara ## Contact & Social - LinkedIn: https://linkedin.com/in/justine-s-9ba4aa12 - Portfolio: https://justineschott.github.io/ --- Source: https://flows.cv/justines JSON Resume: https://flows.cv/justines/resume.json Last updated: 2026-03-29